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.
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.
Quiz 2 (Database Design)
This is a derived attributeand should be removed.1. Activity Table
This attribute does not depend on theprimary key (Department) and should be moved to a different table.2. Department Table
This is a repeating group and should be moved to a new entity.3. Employee 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