Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

(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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transact SQL Cookbook Help For Database Programmers

Authors: Ales Spetic, Jonathan Gennick

1st Edition

1565927567, 978-1565927568

More Books

Students also viewed these Databases questions

Question

Is SHRD compatible with individual career aspirations

Answered: 1 week ago