Reference no: EM132209788
Show tables you would design for the following situation. Your design should avoid modifications problems and implement relations. indicate the atrributes in the tables that would uniquely identify the row( ie primary key), document any assumptions you make that would affect the way you woud have designed your table.
The stuff corporation is a company with approx 500 employees that produces stuff. A database is required to keep track of all employees, departments and vendors. Obviously, an employees name, adress, office phone number and salary is needed in the database. the following additional business policies for the stuff corporation exist:
1. Employees are either engineers or administrative staff, but not both
2. An employee must have a degree in engineering to be considered an engineer.
3. It is important to record the universities that engineers have attended, what kinds of engineering degrees those universities offer, and what kind of degree our engineer has. All degrees earned by an engineer should be recorded in the database
4. The stuff corporation is divided into departments: accounting, research and development and marketing. An employee can be reported to only one department. Each department has several employees but only one manager. Managers are classified as "managerial" administrative staff. It is important to know the name and phone number of each departmetns manager.
5. Each department is responsible for purchasing its equipment and supplies from vendors. Stuff corporation has to pay for these things so the vendor's name and adress is needed. A record of every purchase (item, cost, and date of purchas) is needed. A vendor may supply equipment or supply to many departments. It is not necessary to know everything a vendor sells, only the things purchased and which department purchased them is needed.