Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(e) Alphabet Inc. is an American multinational conglomerate created as the parent company of Google and several other companies previously owned by Google. You are
(e) Alphabet Inc. is an American multinational conglomerate created as the parent company of Google and several other companies previously owned by Google. You are asked to develop a database system for Alphabet to keep track of all their companies, departments, employees and hardware devices. The requirements for the database are provided below: There are several departments. Each department belongs to one company. Each department employs one or more employees and each em- ployee works for one department. Each company has a company code and an address. Each department has a department code, a name and the com- pany that the department belongs to. Each employee has an employee number, name, email and the department that he works for. Each device has a Name, Serial Number, Operating System Ver- sion and the Employee that it relates to. To clarify, a serial number (e.g. ABC123DEF456) should be stored as a string. Additionally, the "Operating Systems Version" (e.g. Windows-10-X64-Build- 12345) should also be stored as a string. Each employee may have one or more device, and each device belongs to one employee. (i) Draw an entity relationship diagram for Alphabet's database. You should include the attributes (Primary and Foreign keys also) described in the requirements for each relation. (6) (ii) Write the necessary SQL code to create the tables with appropri- ate Primary and Foreign keys for the Alphabet database. (7)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started