Study the following E-R diagram representing a company database and then answer the questions that follow. (Assume
Fantastic news! We've Found the answer you've been seeking!
Question:
Study the following E-R diagram representing a company database and then answer the questions that follow. (Assume no other entities or relationships exist)
- Give ONE example EACH of a multi-valued attribute, an attribute of a relationship and a derived attribute.
- What is the minimum number of projects that an employee can work on? What is the maximum? How do you know?
How would this diagram change if there were some employees who didn't work in any department.
While converting this to a relational model, which attribute(s) will become a relation (table)? Explain briefly.
While converting to a relational model, if we create a primary-key foreign-key relationship to show WORKS_FOR between the two relations for DEPARTMENT and EMPLOYEE, which relation will get the foreign key field? Explain briefly.
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date: