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 189 total

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

Grid  List 

Set Descending Direction
  1. CMIS 320 Lab 1 Homework Data modeling diagram

    CMIS 320 Lab 1 Homework Data modeling diagram

    Regular Price: $15.00

    Special Price: $12.00

    CMIS 320 Lab 1 Homework Data modeling diagram


    Homework Submission Requirements:
    Homeworks should be submited as an attached file in your assignment folder. text for coding and result of execution and MS Word format for documenting are preferred. Data modeling diagram could be copied and pasted into a Word doc.
    You must name your file to include your first initial of your first name and last name.
    Part I is 4 points and Part II is 1 points. Total is 5. Quiz is not required for grading.


    Part I: Data Modeling
    Consider a student club or organization in which you are a member. What are the data entities of this enterprise? List and define each entity. Then, develop an enterprise data model showing these entities and important relationships between them. (See figure 1-3a on page 11 for an example enterprise data model)


    Part II: Lab 1
    In this class, we need a functional database system to complete the tasks, such as project 2 and Learning SQL. The school provides you with an Oracle database instance on NOVA unix server for this purpose. You all should have your accounts set up. What you need to do is to activate it for this class.

    Learn More
  2. 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
  3.  ITS407 Module 8 Entities and Attributes

    ITS407 Module 8 Project Ace Software MySQL Database For Mom and Pop Johnson video store

    Regular Price: $25.00

    Special Price: $20.00

    ITS407 Module 8 Project Ace Software MySQL Database For Mom and Pop Johnson video store


    You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database.


    You sit down with Mom and Pop to discuss their business, and watch their operation for about a week. You discover quickly that a video and a DVD are both copies of a movie kept in a separate plastic case that is rented out. They have several copies of each movie they rent, therefore there are several videos and DVDs for each movie title. You learn that in their inventory they have several thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The video and DVD prices to them are based on the quantity of their shipment and the past business they have done with each company.


    The price of a DVD for a movie might be different than the price of a video for the same movie, even from the same distributor. Each distributor provides different types of movies (e.g., suspense, horror, mystery, comedy, etc.). A single distributor may provide several different types of movies in both video and DVD format. It is possible to obtain the same movie from multiple distributors and at different wholesale prices.


    Each video and DVD has a unique identification number that Mom and Pop assign in their inventory, in addition to the distributor's serial number for the item. Each movie also has a unique identification number Mom and Pop assign in addition to the title and any movie IDs the distributors use in their electronic catalogs. Distributors provide electronic catalogs to Mom and Pop, and the information from these catalogs must be included in the database.


    Mom and Pop need to record when a video or DVD is rented, when a video or DVD is returned, and all customer charges such as late and damaged fees, failure to rewind fees, and taxes. They need a report of which videos are returned late because there are standard and late charges. On occasion there are discount prices for certain movies or types of movies. Customers want to rent movies based on actors or actresses, running length, type of movie, rating, year released, the director, and the Academy Awards won (by the movie, the actors, the actresses and/or the directors). Customers also want to know how many videos they have rented in the last month, year, and so forth. Mom and Pop need to keep only basic information on customers in their database, such as name, address, telephone numbers, etc.


    There must be no limit to the number of video and/or DVD copies of a movie that Mom and Pop can have in their inventory. Video/DVD ID numbers, movie ID numbers, and distributor ID numbers for videos, DVDs, and movies are all different. Also, each movie must be able to have an unlimited number of actors, actresses, directors, and Academy Awards (i.e., Oscars). Other types of awards (e.g., Golden Globe, People's Choice, etc.) are not of interest for this application. The rental of equipment, sale of videos, DVDs, popcorn, etc., is not to be kept in the database.


    1) Identify and describe the entities and their attributes.
    2) Develop relationship sentence pairs.
    3) Draw an ERD with Visio.
    4) Develop metadata from the ERD and document in an Excel spreadsheet.
    5) Using your selected RDBMS (SQL Server, Oracle, or MySQL), develop and execute an SQL script file of DDL SQL to create the database tables in the metadata document.
    6) Using your selected RDBMS, develop and execute an SQL script file of DML SQL INSERT statements to populate the tables using SQL INSERT statements for at least 5 rows of data per table.
    7) Using your selected RDBMS develop and execute an SQL script file to:
     a) Show the contents of all tables
     b) Retrieve all of the customers' names, account numbers, and addresses (street and zip code only), sorted by account number
     c) Retrieve all of the DVDs rented in the last 30 days and sort in chronological rental date order
     d) Update a customer name to change their maiden names to married names. You can choose which row to update. Make sure that you use the primary key column in your WHERE clause to affect only a specific row.
     e) Delete a specific customer from the database. You can choose which row to delete. Make sure that you use the primary key column in your WHERE clause to affect only a specific row.


    The metadata should be submitted in an Excel spreadsheet. All other outputs for the database design, SQL code, and SQL results should be submitted in a single Word file in order, by step, and clearly labeled.

    Learn More
  4. IM300 Week 5 Hotel Database Part 4 Cover Sheet

    IM300 Week 5 Optimizing the Database Hotel Database Part 4

    Regular Price: $25.00

    Special Price: $20.00

    IM300 Week 5 Optimizing the Database Hotel Database Part 4


    Resources: SR-bi-003 – Hotel Database, the results from SR-bi-003 – Hotel Database Part 3, and Oracle® Database Express® Virtual Desktop


    Complete the service request by implementing referential integrity and constraints in your database:
    Create an AFTER trigger on the Hotel table that deletes any records from the Rooms table that match (:old.HOTEL_ID).
    Apply at least six constraints within the database.
    Create a newly generated DDL script.


    Create a fax cover sheet addressed to the project manager for the referential integrity and constraints work you have completed and include a newly generated DDL script to show your progress on the project.

    Learn More
  5. IM300 Week 5 Learning Team Analyze the Execution Plan Letter

    IM300 Week 5 Learning Team Analyze the Execution Plan Letter

    Regular Price: $20.00

    Special Price: $15.00

    IM300 Week 5 Learning Team Analyze the Execution Plan Letter


    A member of your team questions the necessity of an execution plan for the new database system. You reply in a letter.
    Resources: University of Phoenix Material: Execution Plan Instructions
    Analyze the execution plan created by the database using the query and instructions found in the Execution Plan Instructions document.


    Write a draft of your business letter to a database administrator including the following:
    An explanation of why it is important for them to understand execution plans.
    How execution plans can be used to improve the performance of the database.
    Format your letter consistent with APA guidelines.
    The execution plan is attached which I ran against the oracle DB HR and the attached pictures are the result.

    Learn More
  6. 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
  7. Access 2010 Chapter 5 Babbage CPA Firm database

    Microsoft Access 2010 Chapter 5 Apply Your Knowledge

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 5 Apply Your Knowledge
    Reinforce the skills and apply the concepts you learned in this chapter.


    Adding Date/Time and OLE Fields, Using an Input Mask Wizard, and Querying Date/Time Fields


    Instructions: Start Access. If you are using the Microsoft Access 2010 Complete or the Microsoft Access 2010 Comprehensive text, open the Babbage CPA Firm database that you used in Chapter 4. Otherwise, see your instructor for information on accessing the files required in this book.


    Perform the following tasks:
    1. Add the Start Date and Picture fields to the Bookkeeper table structure, as shown in Figure 5 – 84. Create an input mask for the Start Date field. Use the Short Date input mask type.
    2. Add the data shown in Table 5–1 to the Bookkeeper table.
    3. Query the Bookkeeper table to find all bookkeepers who started after January 1, 2012. Include the Bookkeeper Number, First Name, Last Name, Hourly Rate, and Earnings YTD in the query results. Save the query as Start Date Query.
    4. Submit the revised database in the format specified by your instructor.

    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. Access Chapter 7 Make It Right Query 1

    Microsoft Access 2010 Chapter 7 Make It Right Correcting Errors in the Query Design

    Regular Price: $20.00

    Special Price: $15.00

    Microsoft Access 2010 Chapter 7 Make It Right Correcting Errors in the Query Design

    Analyze a database, correct all errors, and/or improve the design.

    Instructions: Start Access. Open the College Pet Sitters database. See the inside back cover of this book for instructions for downloading the Data Files for Students, or see your instructor for information on accessing the files required in this book.

    College Pet Sitters is a database maintained by a small pet-sitting business owned by college students. The queries shown in Figure 7 – 37 contain a number of errors that need to be corrected before the queries run properly. The query shown in Figure 7 – 37a displays the Enter Parameter Value dialog box, but this is not a parameter query. Also, the owners wanted to assign the name, Total Amount, to the Balance + Paid calculation. Save the query with your changes.

    When you view the results for the query shown in Figure 7 – 37b, you get 30 records. You know this is wrong. Also, the query did not sort correctly. The query results should be sorted first by sitter number and then by descending balance. Correct the errors and save the query with your changes.

    Change the database properties, as specified by your instructor. Submit the revised database in the format specified by your instructor.

    Learn More

Items 1 to 10 of 189 total

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

Grid  List 

Set Descending Direction