Database

Need Help in Database Assignment?
We can help you if you are having difficulty with your Database Assignment. Just email your Database Assignment at admin@assignmentcache.com.
We provide help for students all over the world in Database Assignment.

Items 21 to 30 of 35 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4

Grid  List 

Set Ascending Direction
  1. ITCO231 Unit 5 HR Database Tables

    ITCO231 Unit 5 HR Database

    Regular Price: $25.00

    Special Price: $20.00

    ITCO231 Unit 5 HR Database


    Update the database diagram, and generate the data definition language (DDL) for the Contacts table and any others that you wish according to the following diagram. Be sure to define the appropriate relationship between the Contact table and the Employee table.


    Add data to your database and validate that your records loaded properly. In tabular format, include 3 rows for each table, making sure that the primary–key and foreign–key relationships are properly applied.
    Next, you will insert the 20 rows of data that you identified (using the concepts you worked on identifying the primary and foreign keys), then perform queries using JOIN syntax of the database.
    Task 1: Create 3 rows of data for each table ensuring that the referential integrity is valid.
    Task 2: Add the 20 rows of data to the appropriate table in your database (using any appropriate method available).
    Task 3: SELECT all columns and all rows of the tables. Create a screenshot of each query and output data, and submit them.
    Task 4: Write SELECT statements for the following (include a screenshot of the SQL and its execution, including the resulting data):
    Display the employee id, contact id, first_name, middle name, last_name, and phone number for all employees.
    Rows returned
    Display the employee id, contact id, first_name, middle name and last_name, and email address for all employees.
    Rows returned
    Display the employee id, contact id, first_name, middle name, last_name, phone number, and email address for all employees.
    Rows returned
    Combine all of the DDL/SQL statements (text only), diagram and screenshots into a single Word document. Submit it for grading.

    Learn More
  2. ITSE 2309 Oracle Olympics Database Queries

    ITSE 2309 Project Database Programming Oracle Olympics Database

    Regular Price: $30.00

    Special Price: $25.00

    ITSE 2309 Project Database Programming Oracle Olympics Database


    Project Objective: Design and implement a database from requirements and execute queries using SQL.
    1. Design a database for tracking Olympic events and results.
    2. Write scripts to create the database and populate the tables.
    3. Write SQL queries to produce reports.


    Deliverables
    1. Create an ER Diagram for your Olympics database.
    2. Write a short design document (1 or 2 pages) describing your choices and reasons for designing your database as you did.
    3. Provide scripts to create, populate, and teardown the Olympics database.
    A. makeOlympicsDb.sql – Script to create tables, constraints, & any DB objects.
    B. populateOlympicsDb.sql – Script to add records to the database tables.
    C. dropOlympicsDb.sql – Script to delete all tables and database objects.
    4. Provide one or more scripts (with .sql file extension) to execute the queries defined for the project. Each script should include comments with your name and query/question number.


    Database Requirements
    The International Olympic Committee is creating a database for their upcoming summer Olympic games. Each sport has competitions for several different events. The competitions for each sport are assigned to a specific venue. A competitor is an individual athlete representing a particular country. Each event is scheduled for a single day and time, and we save a single result for each athlete competing in the event.
    Note: For this project, there are no qualifying rounds.
    The goal of the database is to identify when and where competitions occur, the athletes competing in events, and the medalists for each competition. Medals are awarded:
    1. Gold for 1st place
    2. Silver for 2nd place
    3. Bronze for 3rd place
    For each competition, results are stored for each athlete. The results are recorded as an elapsed time, a score, or a measurement.


    Data Population
    To test the database, you need to populate with data to demonstrate that the database will meet requirements and produce desired reports. For demonstration purposes, the data should be populated with events and competitors for Gymnastics, Track and Field, and Swimming. Use your own creativity to name athletes and choose countries for the competitions. Provide at least 5 competitors for each event. Some athletes should compete in multiple events and some compete in only a single event.


    Queries
    1. List all the Olympic events in which women compete, sorted alphabetically. No duplicates.
    2. List all the Olympic sports with the earliest event date/time and latest event date/time for the events contested in the sport. Order results by the name of the sport. Each sport should only be listed once.
    3. List all events scheduled for August 3rd, with the time and venue of the event. Sort events by the time, with the earliest event listed first. If more than one event starts at the same time, sort by the name of the event.
    4. For Gymnastics, list each event and the names of all the athletes competing in those events. Sort results by the name of the event, and secondarily by the name of each athlete.
    5. List all the countries in your database and the number of individual athletes from each country. Sort by country name.
    6. List all the names of athletes who compete in more than one event along with the name of his/her event and the competition date/time. Sort results by the athlete’s name.
    7. List each sport, the names of each event (including gender), and the number of competitors entered into each event.
    8. List results for Track and Field’s 100 Meter race with times for each athlete, with fastest time first. List the athlete’s name, country, and race time.
    9. List all medal results for events that have already occurred and been entered into the Olympics database. List the sport, event, athlete’s name, country and medal (Gold/Silver/Bronze). Order results by the sport, event, and place. (Gold Medal = 1st Place, Silver = 2nd Place, Bronze = 3rd Place)
    10. List the countries that won the most cumulative medals in descending order, listing the number of gold, silver, and bronze medals, along with the total. Report should be sorted with the most medals listed first in the report down to the country with the fewest medals. If countries have the same number of medals, the most Gold/Silver/Bronze next followed by alphabetic listing by country name.

    Learn More
  3. MIS562 Week 4 Homework Part 1

    MIS562 Week 4 Homework Oracle Queries Database

    Regular Price: $25.00

    Special Price: $20.00

    MIS562 Week 4 Homework Oracle Queries Database


    Part 1
    Using the tables created in week 2:
    Question ( 4 pts per question)
    1. Show a list of all employee names and their department names and the employees for each department. Be sure to show all departments whether there is an employee in the department or not. Use an outer join.
    2. Select all employee names and their department names. Be sure to show all employees whether they are assigned to a department or not. Use an outer join.


    Using the student schema:
    Question ( 3 pts per question)
    3. Write a query that that performs an inner join of the grade, student, and grade_type tables using ANSI SQL 99 syntax.
    4. Write a query that that performs an inner join of the grade, student, and grade_type tables using the Oracle inner join convention.
    5. List all the zip codes in the ZIPCODE table that are not used in the STUDENT or INSTRUCTOR tables. Use a set operator.
    6. Write a SQL statement using a set operator to show which students enrolled in a section that are not enrolled in any classes. Exclude students with student id less than 300.


    Part 2
    Question ( 5 pts per question)
    1. Write and execute two INSERT statements to insert rows into the ZIPCODE table for the following two cities of your choice. After your INSERT statements are successful, make the changes permanent.
    2. Create a sequence called STUDENT_ID_NEW that begins with 900 and increments by 1. If the sequence already exists, drop the sequence and recreate it.
    3. Make yourself a student by writing and executing an INSERT statement to insert a row into the STUDENT table with data about you. Use one of the zip codes you inserted in Exercise 1. Only insert values into the columns STUDENT_ID using the sequence you created in step 2, FIRST_NAME, LAST_NAME, ZIP, REGISTRATION_DATE (use a date that is five days after today), CREATED_BY, CREATED_DATE, MODIFIED_BY, and MODIFIED_DATE. Issue a COMMIT command afterwards.
    4. Write an UPDATE statement to update the data about you in the STUDENT table. Update the columns SALUTATION, STREET_ADDRESS, PHONE, and EMPLOYER. Be sure to also update the MODIFIED_DATE column and make the changes permanent
    5. Delete the row in the STUDENT table and the two rows in the ZIPCODE table you created. Be sure to issue a COMMIT command afterwards
    6. Create a table called TEMP_STUDENT with the following columns and constraints: a column STUDID for student ID that is NOT NULL and is the primary key, a column FIRST_NAME for student first name; a column LAST_NAME for student last name, a column ZIP that is a foreign key to the ZIP column in the ZIPCODE table, a column REGISTRATION_DATE that is NOT NULL and has a CHECK constraint to restrict the registration date to dates after January 1st, 2000.
    7. Write an INSERT statement violating at least two of the constraints for the TEMP_STUDENT table you just created.
    8. Write another INSERT statement that succeeds when executed, and commit your work.
    9. Alter the TEMP_STUDENT table to add two more columns called EMPLOYER and EMPLOYER_ZIP. The EMPLOYER_ZIP column should have a foreign key constraint referencing the ZIP column of the ZIPCODE table. Update the EMPLOYER column.
    10. Alter the table once again to make the EMPLOYER column NOT NULL.
    11. Write a statement that drops the EMPLOYER_ZIP column.
    12. Drop the TEMP_STUDENT table once you're done with the exercise.
    13. Create a non unique index called crse_modified_by_i on the MODIFIED_BY column of the course table
    14. Change the registration date of Paula Valentine to today’s date. Create a view called CURRENT_REGS reflecting all students that registered today. (You will need to execute this query in question 6 on the same day you change the date)
    15. Create a view called roster reflecting all students taught by the instructor Marilyn Frantzen. Query the view.
    16. Given the MY_EMPLOYEE view, what information is the user allowed to retrieve? Who can update the SALARY column through the view? Hint: The USER function returns the name of the currently logged in user.
    CREATE OR REPLACE VIEW my_employee AS
    SELECT employee_id, employee_name, salary, manager
    FROM employee
    WHERE manager = USER
    WITH CHECK OPTION CONSTRAINT my_employee_ck_manager

    Learn More
  4. Microsoft Access 2010 Chapter 5 Lab 2 Adding Fields and Creating Multitable Forms for the Walburg Energy Alternatives Database

    Microsoft Access 2010 Chapter 5 Lab 2 Adding Fields and Creating Multitable Forms for the Walburg Energy Alternatives Database

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 5 Lab 2 Adding Fields and Creating Multitable Forms for the Walburg Energy Alternatives Database

    Problem: The management of Walburg Energy Alternatives has found that they need to maintain additional data on suppliers. Management needs to keep track of the last date an order was placed, whether the vendor accepts returns, and whether the vendor allows online ordering. Management also would like to attach to each vendor’s record Excel files that contain historical cost data. Walburg Energy Alternatives requires a form that displays information about the vendor as well as the items that are purchased from vendors.

    Instructions: If you are using the Microsoft Access 2010 Complete or the Microsoft Access 2010 Comprehensive text, open the Walburg Energy Alternatives database that you used in Chapter 4. Otherwise, see the inside back cover of this book for instructions on downloading the Data Files for Students, or contact your instructor for more information about accessing the required files.

    Perform the following tasks:
    1. Add the fields Last Order Date, Returns, Online Ordering, and Cost History to the end of the Vendor table structure. Last Order Date is a Date/Time field, Returns and Online Ordering are Yes/No fields, and Cost History is an Attachment field. Create an input mask for the Last Order Date that uses the Short Date input mask.
    2. Add the data shown in Table 5 – 3 to the Vendor table.
    Table 5 – 3 Data for Vendor Table
    Vendor Code Last Order Date Returns Online Ordering Cost History
    AS 3/30/2012 Yes No AS_History.xlsx
    JM 3/26/2012 No Yes JM_History.xlsx
    SD 4/4/2012 Yes Yes SD_History.xlsx
    3. Create the form shown in Figure 5 – 88. Use Vendor Master Form as the name of the form and Items of Vendor as the name of the subform. The title is raised, semi-bold, and distributed with a font size of 24. The labels are blue, bold, and etched with a transparent border style. The fields have a sunken special effect.
    4. Open the Vendor Master Form and then open the cost history for Asterman Industries. Change the previous cost for item 4553 to $40.95. Save the change to the workbook.
    5. Query the Vendor table to find all vendors that accept returns and allow online ordering. Include the Vendor Code and Name in the query results. Save the query as Returns-Online Query.
    6. Submit the revised database in the format specified by your instructor.

    Learn More
  5. Microsoft Access 2010 Chapter 8 Client View and Update Form

    Microsoft Access 2010 Chapter 8 Advanced Form Techniques Camashaly Design database AC 466 - AC 520

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 8 Advanced Form Techniques Camashaly Design database AC 466 - AC 520


    Save the Client View and Update Form. AC 499 - AC 500.
    Save the Multipage Form. AC 500 - AC 518


    Project - Advanced Form Techniques
    Camashaly Design wants two additional form to use with its Clients and Business Analyst tables. The first form Client View and Update Form (Figure 8-1a), contains the fields in the Client table. The form has five command buttons: Next Record, Previous Record, Add Record, Delete Record, and Close Form. Clicking nay of these buttons causes the action indicated on the button to take place.
    The form also contains a combo box for the Business Analyst Number field that assists users in selecting the correct analyst (Figure 8-1b).
    To assist users in finding a client when they know the clients name, the form also includes a combo box they can use for this purpose (Figure 8-1c). After clicking the arrow, the user can simply click the client they want to find; Access then will locate the client and display that clients data in the form (Figure 8-1d).


    For the second new form, Camashaly Design needs a multipage form that lists the numbers and names of the analyst. Selecting the first tab, the one labelled Datasheet, displays a subform listing about the course offering for clients of the selected analyst (Figure 8-2a).
    Selecting the other tab, the one labelled Charts, displays two charts that illustrate the total hours spent and hours remaining by the analyst for the various courses (Figure 8-2b). In both charts, the slices of the pie represent the various course. They are color coded and legend at the bottom indicates the meaning of various colors. The size of pie slice gives a visual representation of the portion of the hours spent or hours remaining by the analyst for the particular course. The chats also includes specific percentages. If you look at the bottom purple slice in the Hours Spent by Course Offering chart, for example, you see that the color represent course C04. It signifies 42% of the total. Thus, for all the hours already spent on the various course offering by analyst 11, 42% have been spent on course C04.

    Learn More
  6. Microsoft Access 2010 Chapter 10 Lab 1 Administering the ECO Clothesline Database

    Microsoft Access 2010 Chapter 10 Lab 1 Administering the ECO Clothesline Database

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 10 Lab 1 Administering the ECO Clothesline Database


    Lab 1: Administering the ECO Clothesline Database
    Problem: ECO Clothesline has determined a number of database administration tasks that need to be done. These include creating a template, splitting the database, creating indexes, and adding table and field properties.


    Instructions: If you are using the Microsoft Offce Access 2010 Comprehensive text, open the ECO Clothesline database that you used in Chapter 9. Otherwise, contact your instructor for more information about accessing the required files.


    Perform the following tasks:
    1. Open the Open Orders table in Datasheet view and add the Quick Start Priority field to the table. Assign a High priority to orders for customers AM23 and JN34. Assign a Low priority to the order for TT21. All other orders have a Normal priority.
    2. The Main Menu navigation form should display automatically when a user opens the database.
    3. Open the Customer table in Design view and create custom input masks for the following fields: Customer Number, State, Postal Code, and Sales Rep Number. The Customer Number field should consist of two uppercase letters followed by two numbers. The State field should contain two uppercase letters. Both the Postal Code and Sales Rep Number fields only can contain numbers.
    4. Create an index on the Customer Name field that does not allow duplicates. Create an index on the combination of Customer Type and Customer Name. Name the index TypeName.
    5. Save the ECO Clothesline database as a template with data but not as an application part. Create a new database from the ECO Clothesline template. Name the database ECO New. Split the ECO New database.
    6. Open the front-end database and add a logo to the Customer Master Form. You can create your own logo or use one o the sample pictures included with Microsoft Access. (Hint: See the BTW on page AC 645 for assistance with this task.)
    7. Submit the revised databases in the format specified by your instructor.

    Learn More
  7. ITCO231 Unit 3 HR Database Tables

    ITCO231 Unit 3 HR Database Tables

    Regular Price: $25.00

    Special Price: $20.00

    ITCO231 Unit 3 HR Database Tables


    Create the needed tables in the SQL server environment (just tables, no relationships yet).


    Use integer (INT) data types for all ID columns.
    Use DATE data types for all date-related columns.
    Rate related columns should be DECIMAL data types.
    All other data types should be VARCHAR.
    In addition, create 3 additional tables that could be consistent in a database for a human resources (HR) application, including an appropriate table name and appropriate columns.
    Create and submit a screenshot of your database diagram based on the tables, and generate the data definition language (DDL) for each table.
    Submit a consolidated Word document with the screenshot and the DDL for all tables (text only, no screenshots).

    Learn More
  8. Succeeding in Business with Microsoft Access 2013 Steps to Success Level 2 qryDuplicatePostalCodes

    Succeeding in Business with Microsoft Access 2013 Steps to Success Level 2

    Regular Price: $25.00

    Special Price: $20.00

    Succeeding in Business with Microsoft Access 2013 Steps to Success Level 2


    Hudson Bay Pharmacy is ready to crearte more complex queries to analyze employee data. Kim Siemers, human resources manager for Hudson Bay, asks for your help in creating queries that extract the employee information she needs from their database. As you create and save the new queries be certain to use the "qry" perfix as a part of the naming convention. Also consult your instructor for instruction about submitting results.


    1. Start access and open Hudson.accdb database from STS folder.


    2. Kim wants to identify employees who live in the same neighborhood in Edmonton so they can create car pools and share rides to work. In Edmonton, the postal codes roughly correspond to neighborhood. Prepare a list of employees who live in the same neighborhood so that Kim can create a list of employees who can share rides to work. Name the query qryDuplicatePostalCodes.


    3. A new policy at Hudson Bay Pharmacy is that all employees must acquire and maintain certifications in adult, infant, and child CPR and in using defibrillators. Kim asks you to identify employees who have not completed any certification training. Save the query as qryNoTraining.


    4. Kim also needs to list all employees and the classes they have taken. The results should include current employees who have not attended training as well as those who have. Save the query as qryEmployeeTraining.


    5. Kim also needs to identify employees whose CPR or defibrillators certification has expired, depending on the time period she specifies. Show all employees whose Adult CPR, Child/Infant CPR, or Defibrillators Use certification has expired in any specified time period. Save the query as qryUpToDate.


    6. Mai Yan, manager of Hudson Bay Pharmacy, wants to identify the five current nonsalaried employees who are earning the highest wages per hour. These are the five employees who have been working for the pharmacy the longest or who have regularly received raises for their work. List the top five wage earners of all the current nonsalaried employees. Save the query as qryTop5HourlyRates.


    7. To prepare for employee reviews, Kim needs to calculate the minimum, maximum, and average hourly rates for each job category. Provide this information for her, saving the query as qryMaxMinAvgHourlyRate.


    8. Mai is considering offering life insurance as an employee benefit, and needs to know the current age of all employees. Provide this information for her. Be certain to provide an appropriate name for the column with the result and to show the ages in descending order. Include the job title and format the results so that they include one decimal place. Also show the first name and last name together. Save the query as qryEmployeeAge.


    9. Kim asks you to provide one other statistical analysis. Show the average age of employees by job title. Save this query as qryAvgEmployeeAge.


    10. Close the Hudson.accdb database and Access.

    Learn More
  9. IM300 Week 4 Hotel Database Part 3 DDL script

    IM300 Week 4 Integrity and Constraints Hotel Database Part 3

    Regular Price: $25.00

    Special Price: $20.00

    IM300 Week 4 Integrity and Constraints Hotel Database Part 3


    Resources: SR-bi-003 – Hotel Database, the results from SR-bi-003 – Hotel Database Parts 1 & 2, Oracle® Database Express® and Microsoft® Visio® Virtual Desktop.


    Complete Service Request SR-bi-003 - Hotel Database–Part 3.


    Normalize the entities and attributes to at least the third normal form.


    Use Microsoft® Visio® diagramming tools to create an entity-relationship diagram (ERD) that demonstrates the logical design of your normalized database.


    Create and alter tables in the city’s Oracle® Database Express® database to implement the ERD design.


    Generate a new DDL script.


    Create a fax cover sheet addressed to the project manager for the ERD and a newly generated DDL script to show your progress on the project.

    Learn More
  10. Assignment 9-8 Maintaining an Audit Trail of Product Table Changes

    Oracle 11g PL/SQL Joan Casteel Chapter 9 Hands-On Assignments Part 9-5 to 9-8

    Regular Price: $30.00

    Special Price: $25.00

    Oracle 11g PL/SQL Joan Casteel Chapter 9 Hands-On Assignments Part 9-5 to 9-8

    Assignment 9-5: Processing Discount
    Brewbean's is offering a new discount for return shoppers. Every fifth completed order gets a 10% discount. The count of orders for a shopper is placed in a packaged variable named pv_disc_num during the ordering process. The count needs to be tested at checkout to determine whether a discount should be applied. Create a trigger named BB_DISCOUNT_TRG so that when an order is confirmed (the ORDERPLACED value is changed from 0 to 1), the pv_disc_num packaged variable is checked. If it's equal to 5, set a second variable named pv_disc_txt to Y. This variable is used in calculating the order summary so that a discount is applied, if necessary.
    create a package specification named DISC_PKG containing the necessary packaged variables. Use an anonymous block to initialize the packaged variables to use for testing the trigger. Test the trigger with the following UPDATE statement:
    UPDATE bb_basket
    SET orderplaced = 1
    WHERE idBasket = 13;
    If you need to test the trigger multiple times, simply reset the ORDERPLACED column to 0 for basket 13 and then run the UPDATE again. Also, disable this trigger when you're finished so that it doesn't affect other assignments.


    Assignment 9-6: Use Triggers to Maintain Referential Integrity
    At times, Brewbean's has changed the ID numbers for existing products. In the past, developers had to add a new product row with the new id to the BB_PRODUCT table, modify all the corresponding BB_BASKETITEM and BB_PRODUCTOPTION table rows, and then delete the original product row. Can a trigger be developed to avoid all these steps and handle the update of the BB_BASKETITEM and BB_PRODUCTOPTION table rows automatically for a given change in product ID? If so, create the trigger and test by issuing an update statement, which changes the IDPRODUCT of 7 to 22. Do a rollback to return the data back to its original state. Also, disable the new trigger after you have completed the assignment.


    Assignment 9-7: Updating Summary Data Tables
    The Brewbean's owner uses several summary sales data tables every day to monitor business activity. The BB_SALES_SUM table holds the product ID, total sales in dollars, and total quantity sold for each product. A trigger is needed so that every time an order is confirmed or the ORDERPLACED column is updated to 1, the BB_SALES_SUM table is updated accordingly. Create a trigger named BB_SALESUM_TRG that perform this task. Before testing, reset the ORDERPLACED column to 0 for basket 3, as shown in the following code, and use this basket to test the trigger.
    UPDATE bb_basket
    SET orderplaced = 0
    WHERE idBasket = 3;
    Notice that the BB_SALES_SUM table already contains some data. Test the trigger with the following UPDATE statement, and confirm that the trigger is working correctly:
    UPDATE bb_basket
    SET orderplaced = 1
    WHERE idBasket = 3;
    Do a rollback and disable the trigger when you're finished so it doesn't affect the other assignments.


    Assignment 9-8: Maintaining an Audit Trail of Product Table Changes
    The accuracy of product table data is critical and the Brewbean's. owner wants to have an audit file that containing information on all DML activity on the BB_PRODUCT table. This information should indicate the ID of the user performing a DML action, the date, the original values of the changed row, and the new values. This audit table needs to track specific columns of concern, including PRODUCTNAME, PRICE, SALESTART, SALEEND, and SALEPRICE. Create a table named BB_PRODCHG_AUDIT that can hold the relevant data. Then create a trigger named BB_AUDIT_TRG that fires an update to this table whenever one of the specified columns in the BB_PRODUCT table is changed.
    Be sure to issue the following command. If you created the SALES_DATE_TRG trigger in the chapter, it conflicts with this assignment.
    ALTER TRIGGER SALES_DATE_TRG DISABLE;
    Use the following update statement to test your trigger:
    UPDATE bb_product
    SET salestart = '05-MAY-03', saleend = '12-MAY-03', saleprice = 9
    WHERE idproduct = 10;
    When you have finished, do a rollback and disable the trigger so that it does not affect other assignments.

    Learn More

Items 21 to 30 of 35 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4

Grid  List 

Set Ascending Direction