Consider a company database. Suppose that after the requirements collection and analysis phase, the database designers provide the following description. ● Employee Attributes: Name, Id, Address, Gender, Dob and Doj. ● Department Attributes: D_no, Name and Location. ● ● ● ● Project Attributes: P_No, Name and Location. Dependent Attributes : D_name, Gender and relationship. An employee works in only one department but can work on several projects. Every department must have one manager. One department has many projects and a project can come under at least one departments. A. Design an ER model to present the above information. B. Change the ER model to include the following: ● An employee can be a staff or a faculty. For staff employees we store position. For faculty employees we store rank. Only Faculty employees can work on projects.

Consider a company database. Suppose that after the requirements collection and analysis phase, the database designers provide the following description. ● Employee Attributes: Name, Id, Address, Gender, Dob and Doj. ● Department Attributes: D_no, Name and Location. ● ● ● ● Project Attributes: P_No, Name and Location. Dependent Attributes : D_name, Gender and relationship. An employee works in only one department but can work on several projects. Every department must have one manager. One department has many projects and a project can come under at least one departments. A. Design an ER model to present the above information. B. Change the ER model to include the following: ● An employee can be a staff or a faculty. For staff employees we store position. For faculty employees we store rank. Only Faculty employees can work on projects.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

If we live in a free and open society, what purpose do barriers serve? Please include at least two instances of such restrictions in your response.
Quèstion 7 If the period is 5s, the corresponding frequency is 0.2 Hz 0.3 Hz 0.4 Hz 0.5 Hz Moving to another question will save this response.
Is war driving legal? Research the legality of war driving in your home state. Is it considered illegal? Or is the law a gray area? Is it an ethical issue? Do you think war driving should be legal or illegal? What should the penalties be? Defend your position.
Could you please explain the concept of privacy? How well do you understand the need of keeping your own information private? Create a list of five different approaches.
Do you believe the government and law enforcement organizations should have access to user accounts on social media platforms like Facebook in order to investigate potential unlawful activity? What precisely is happening here?