mis 320
Download
Skip this Video
Download Presentation
MIS 320

Loading in 2 Seconds...

play fullscreen
1 / 6

MIS 320 - PowerPoint PPT Presentation


  • 275 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

MIS 320

Quiz 2 (Database Design)

instructions
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].
2 department table

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

2. Department Table
4 bartender s table

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