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 1 to 10 of 34 total

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

Grid  List 

Set Ascending Direction
  1. Chapter 3 Case Problem Level 1 Antiques

    Succeeding in Business with Access Chapter 3 Case Problem 1 and 3

    Regular Price: $25.00

    Special Price: $20.00

    Succeeding in Business with Access 2010
    Chapter 3 Analyzing Data for Effective Decision Making

    Case Problem Level 1 - managing Customer Information for NHD Development Group Inc.
    Antiques.accdb complete solution from Step 1 - Step 12.

    Case Problem Level 2 - Retrieving Employee Information for MovinOn Inc.
    MovinOn.accdb complete solution from Step 1 - Step 12.

    Learn More
  2. MSCD610 Week 7 Logical ERD

    MSCD610 Week 7 Course Project Details Hotel Database

    Regular Price: $30.00

    Special Price: $25.00

    MSCD610 Week 7 Course Project Details Hotel Database


    The course project is to develop a Data Model and Database Design for a set of business case requirements. Students should informally review their ER model with the facilitator in week 4 or 5.


    This project should follow a top-down database design process and produce the following outputs:
    1. A set of business information requirements in the form of a business case abstract.


    2. A complete ERD that models those requirements.
    This model should include the following:
    a. A definition of each entity
    b. The unique identifier for each entity
    c. The attributes associated with each entity
    d. The relationships between the entities including their cardinality, optionally, and names


    3. A physical implementation of a database from the logical design (ERD).
    The tables should be normalized to 3NF. For this design include:
    a. The name for each table
    b. The primary key for the table, and any secondary keys
    c. Any foreign keys
    d. A data dictionary
    e. Any sample data available


    4. The DDL scripts for implementing the physical database design for this database. Include the referential integrity constraints for these tables. Also include the DDL for any needed indexes and/or views. If necessary, indicate any database tuning which is anticipated on this database.


    5. Create the designed Oracle database, and load it with sample data. Then print the definition of the tables, indexes, and any views. Print sample report(s) showing the query definitions in the business requirements have been met.

    Learn More
  3. Access 2010 Chapter 5 Lab 1 ECO Clothesline Database

    Microsoft Access 2010 Chapter 5 Lab 1 Adding Fields and Creating Multitable Forms for the ECO Clothesline Database

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 5 Lab 1 Adding Fields and Creating Multitable Forms for the ECO Clothesline Database


    Problem: ECO Clothesline needs to maintain additional data on each sales rep. The company needs to add the date each rep started as well as notes concerning the sales rep and a picture of the sales rep. The company wants a form that displays sales rep information and the customers for whom they are responsible.


    Instructions: If you are using the Microsoft Access 2010 Complete or the Microsoft Access 2010 Comprehensive text, open the ECO Clothesline 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 Start Date, Notes, and Picture fields to the end of the Sales Rep table. Save the changes to the structure of the table.
    2. Add the data shown in Table 5 – 2 to the Sales Rep table. Adjust the row and column spacing to best fit the data. Save the changes to the layout of the table.
    3. Create the form shown in Figure 5 – 87. Use Sales Rep Master Form as the name of the form and Customers of Sales Rep as the name of the subform. Users should not be able to tab through the Picture control. The title is centered with a font size of 24 and a font weight of bold.
    4. Query the Sales Rep table to find all sales reps who started before January 1, 2012, and who have computer skills. Include the Sales Rep Number, First Name, Last Name, and Notes fields in the query results. Save the query as Computer Skills Query.
    5. Submit the revised database in the format specified by your instructor.

    Learn More
  4. Chapter 6 Lab 1 Sales Rep Master List for the ECO Clothesline Database

    Microsoft Access 2010 Chapter 6 Lab 1 Adding Tables and Creating Reports for the ECO Clothesline Database

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 6 Lab 1 Adding Tables and Creating Reports for the ECO Clothesline Database


    Problem: ECO Clothesline needs to maintain data on a weekly basis on the open orders for its customers. These are orders that have not yet been delivered. To track this information requires a new table, an Open Orders table. The company also needs a report that displays sales rep information as well as information about customers and any open orders that the customer has. The company would like to show its appreciation to current customers by discounting the amount customers currently owe.


    Instructions: If you are using the Microsoft Access 2010 Complete or the Microsoft Access 2010 Comprehensive text, open the ECO Clothesline database that you used in Chapter 5. 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. Create the Open Orders table using the structure shown in Table 6 – 5.


    2. Import the Open Orders.txt file into the Open Orders table.


    3. Create a one-to-many relationship between the Customer table and the Open Orders table.


    4. Create a query that joins the Sales Rep and the Customer tables. Include the Sales Rep Number, Last Name, and First Name fields from the Sales Rep table. Include all fields except the Sales Rep Number field from the Customer table. Save the query as Sales Reps and Customers. 5. Create the report shown in Figure 6 – 86. The report uses the Sales Reps and Customers query as the basis for the main report and the Open Orders table as the basis for the subreport. Use the name Sales Rep Master List for the report. The report title has a Text Align property value of Distribute. The Border Width property is hairline and the subreport label is Open Orders. The report is similar in style to the Business Analyst Master List shown in Figure 6 – 1a on page AC 339.


    6. Create the Customer Discount Report shown in Figure 6 – 87. The report uses the Sales Reps and Customers query. Customers who have paid $500 or more will receive a 3% discount on the remaining balance, and customers who have paid less than $500 will receive a 1% discount on the remaining balance. The report includes subtotals and grand totals for the Balance and Amount Paid fields. The report is similar in style to the Discount Report shown in Figure 6 – 1b on page AC 340.


    7. Submit the revised database in the format specified by your instructor.

    Learn More
  5. Microsoft Access 2010 Chapter 9 Navigation Forms

    Microsoft Access 2010 Chapter 9 Macros Navigation Form PivotTables and Charts AC 538 to AC 590

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 9 Macros Navigation Form PivotTables and Charts AC 538 to AC 590


    The first part of the project you will be creating the Client View and Update Form.
    Save the PivotTable for Analyst and Course Offerings Query, p. AC 579
    Save the PivotChart for Analysts and Course Offerings Query, p. AC 589


    Project - Macros, Navigation Forms, PivotTables, and PivotCharts
    The owner of Camashaly Design have heard about navigation forms that enable users to access forms and reports by simply clicking tabs and buttons. A navigation form like the one shown in the Figure 9-1a is a form that includes tabs to display forms and reports. This navigation form contains several useful features. With the Client tab selected, you can click the client number on any row to see the data for the selected client displayed in the Client View and Update Form (Figure 9-1b). The form does not appear in a tabbed sheet, the way tables, queries, forms and reports normally do. Rather, it appears a s a pop-up form, a form that stays on top of other open objects, even when another object is active. Clicking the Business Analyst tab displays business analyst data. As with clients, clicking the business analyst number on any record displays data for that analyst in a pop-up form. Clicking the Form tab in the Camashaly Design navigation form displays button for each of the available forms (Figure 9-1c). You can open the desired form by clicking the appropriate button. Clicking the Reports tab displays an option group for displaying reports (Figure 9-1d). You can preview or export any of the reports on at a time by clicking the corresponding option button. Camashaly would like such a navigation form because they believe it will improve the user-friendliness of the database, thereby improving employee satisfaction and efficiency.


    Befor creating the navigation form, Camashaly will create macros, which are collection of actions designed to carry out specific tasks. To perform the actions in a macro, you run the macro. When a macro is run, Access will execute the various steps, called actions, in the order indicated by the macro. The navigation form macros are run by clicking certain buttons in the form.

    Learn More
  6. CMIS420 PROJECT 2 Mail-Order Database DML and DDL statements

    CMIS420 Advanced Relational Database PROJECT 2 Mail-Order Database

    Regular Price: $25.00

    Special Price: $20.00

    CMIS420 Advanced Relational Database PROJECT 2 Mail-Order Database


    Overview:
    Use SQL, PL/SQL, and Triggers to design and create a Mail-Order Database System. Please create your own data for testing purpose. Use the attached file "Project 2 Tables" as a guide to creating the tables. You should pre-populate the PARTS, CUSTOMERS, EMPLOYEE and ZIPCODES tables.


    Due Date:
    Check the due date in Syllabus for the exact date for this assignment. No project will be accepted after the due date.


    Deliverables:
    Turn in all SQL scripts in the form of a SQL script files. The script files should include,


    1. A script file containing all the DML and DDL statements. That is, the SQL used to create the tables and sequence and the SQL to pre-populate or insert records in the tables. Name this file XXX_PROJ2.sql, where XXX are you intials.
    2. A file containing the PL/SQL package (Specification and Body) that provides the functionality listed in the requirements below. Name this file XXX_PROJ2.pkg, where XXX are you initials.
    3. A file containing the database triggers. Name this file XXX_PROJ2.trg, where XXX are you initials.
    4. Finally, provide a test SQL*PLUS routine (PL/SQL anonymous block) that will test the PL/SQL functionality developed. Name this file XXX_PROJ2_tst.sql, where XXX are your initials.


    You should submit your assignment through WebTycho as you did for previous assignments.
    Use winzip or any zip software to package the four (4) files into one file called XXX_project2.zip, where XXX are your initials.


    Requirements:
    The Mail-Order Database consists of the following tables and attributes. Please ensure that all constraints are created when creating the tables. All constraints other than NOT NULL constraints must be named.
    1. EMPLOYEE(ENO, ENAME, ZIP, HDATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
    2. PARTS(PNO, PNAME, QOH, PRICE, REORDER_LEVEL, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
    3. CUSTOMERS(CNO, CNAME, STREET, ZIP, PHONE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
    4. ORDERS(ONO, CNO, ENO, RECEIVED, SHIPPED, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
    5. ODETAILS(ONO, PNO, QTY, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
    6. ZIPCODES(ZIP, CITY)
    7. ORDERS_ERRORS(TRANSACTION_DATE, ONO, MESSAGE)
    8. ODETAILS_ERRORS(TRANSACTION_DATE, ONO, PNO, MESSAGE)
    9. RESTOCK(TRANSACTION_DATE, PNO)


    • The EMPLOYEE table contains information about the employees of the company. The ENO (Employee Number) attribute is the primary key. The ZIP attribute is a foreign key referring to the ZIPCODES table.
    • The PARTS table keeps a record of the inventory of the company. The record for each part includes its number (PNO) and name (PNAME) as well as the quantity on hand (QOH), the unit price (PRICE) and the reorder level (REORDER_LEVEL). PNO is the primary key for this table.
    • The CUSTOMERS table contains information about the customers of the mail-order company. Each customer is assigned a customer number (CNO), which serves as the primary key. The ZIP attribute is a foreign key referring to the ZIPCODES table.
    • The ORDERS table contains information about the orders placed by customers, the employee who took the orders, and the dates the orders were received and shipped. Order number (ONO) is the primary key. The Customer number (CNO) attribute is a foreign key referring to the CUSTOMERS table, and the ENO attribute is a foreign key referring to the EMPLOYEES table.
    • The ODETAILS table contains information about the various parts order by the customer within a particular order. The combination of ONO and PNO attributes forms the primary key. The ONO attribute is a foreign key referring to the ORDERS table, and the PNO attribute is a foreign key referring to the PARTS relation.
    • The ZIPCODES table maintains information about the zip codes for various cities. ZIP is the primary key.
    • The ORDERS_ERRORS table contains information about any errors that occurred when an order is processed. Transaction date is the date of the transaction.
    • The ODETAILS_ERRORS table contains information about all errors that occur when processing an order detail. Transaction date is the date of the transaction.
    • The RESTOCK table contains information about all parts (PNO) that are below the reorder level. Transaction date is the date of the transaction.


    1. Write a package called Process_Orders to process customer orders. This package should contain four procedures and a function, namely;
    Add_order. This procedure takes as input customer number, employee number, and received date and tries to insert a new row in the Orders table. If the received date is null, the current date is used. The shipped date is left as null. If any errors occur, an entry is made in the Orders_errors table. A sequence called Order_number_seq should be used to populate the order number (ONO) column.
    Add_order_details. This procedure receives as input an order number, part number, and quantity and attempts to add a row to the Odetails table. If the quantity on hand for the part is less than what is ordered, an error message is sent to the Odetails_errors table. Otherwise, the part is sold by subtracting the quantity ordered from the quantity on hand for this part. A check is also made for the reorder level. If the updated quantity for the part is below the reorder level, an entry is made to the Restock table.
    Ship_order. This procedure takes as input an order number and a shipped date and tries to update the shipped value for the order. If the shipped date is null, the current date is used. If any errors occur, an entry is made in the Orders_errors table.
    Delete_order. This procedure takes as input an order number and tries to delete records from both the Orders and Odetails tables that match this order number. If any errors occur or there is no record that matches this order number, an entry is made in the Orders_errors table.
    Total_emp_sales. This function takes as input an employee number. It computes and returns the total sales for that employee.


    2. Create triggers on the PARTS, ORDERS, and ODETAILS tables to populate the CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY columns when an insert or update is made. Use SYSDATE and the pseudo column USER to populate these columns.


    3. Write a trigger that fires when a row in the Orders table is updated or deleted. The trigger should record the dropped order records in another table called deleted_orders. The deleted_orders table should also contain a date attribute that keeps track of the date and time the action (update or delete) was performed. This date is quite different from the CREATED_DATE and UPDATED_DATE from the Order table. Do not copy these dates to the deleted_order table. Please include the table creation script for the deleted_orders table in the script file.


    4. Create a sequence called order_number_seq that will be used to populate the order number (ONO) column.


    5. Write a PL/SQL anonymous block to test the above.

    Learn More
  7. 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
  8. 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
  9. Microsoft Access 2010 CHAPTER 4 Lab 2 Filtered Inventory Status Report

    Microsoft Access 2010 Chapter 4 Lab 2 Presenting Data in the Walburg Energy Alternatives Database

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 4 Lab 2 Presenting Data in the Walburg Energy Alternatives Database


    Problem: The management of Walburg Energy Alternatives already has realized the benefits from the database of items and vendors that you created. The management now would like to prepare reports and forms for the database.
    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 3. Otherwise, see your instructor for information on accessing the files required in this book.


    Perform the following tasks:
    1. Open in Layout view the Inventory Status Report that you created in Chapter 1. Add a total for the Inventory Value field. Be sure the total is completely displayed. Display the average cost. If there are fewer than 10 items on hand, the value should appear in a red bold font. Filter the report for all items
    where the number on hand is 5 or less. Save the filtered report as Filtered Inventory Status Report.


    2. Create the Items by Vendor report shown in Figure 4 – 84.


    3. Create the form shown in Figure 4 – 85. If there are fewer than 10 items on hand, the value should appear in a red bold font. Save the form as Item Update Form.


    4. Filter the Item Update Form for all items where the cost is less than $3.00 and sort the results in descending order by cost. Save the form as Filtered Item Update Form.


    5. Submit the revised database in the format specified by your instructor.

    Learn More
  10. 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

Items 1 to 10 of 34 total

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

Grid  List 

Set Ascending Direction