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.
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