Mis 320
Download
1 / 6

MIS 320 - PowerPoint PPT Presentation


  • 269 Views
  • Uploaded on

MIS 320. Quiz 2 (Database Design) . Instructions. Write your student number (not your name) on a piece of paper. This quiz contains four situations. Each is a set of sample data that has been arranged in a database table. Each of these contains an error.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'MIS 320' - medwin


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Mis 320 l.jpg

MIS 320

Quiz 2 (Database Design)


Instructions l.jpg
Instructions

  • Write your student number (not your name) on a piece of paper.

  • This quiz contains four situations.

  • Each is a set of sample data that has been arranged in a database table.

  • Each of these contains an error.

  • Your job is to identify the error (2 pts.) and suggest a solution (½ pt.).

  • You may use any notes you have made and the class lecture notes.

  • Each situation will be visible for 3 minutes [in this demo version, press enter to advance].


1 activity table l.jpg

This is a derived attributeand should be removed.

1. Activity Table


2 department table l.jpg

This attribute does not depend on theprimary key (Department) and should be moved to a different table.

2. Department Table


3 employee table l.jpg

This is a repeating group and should be moved to a new entity.

3. Employee Table


4 bartender s table l.jpg

There is a M:M relationship between drinks and ingredients which requires a new entity (ingredients) and an intersection table.

4. Bartender’s Table


ad