Q1: Design an E-R Diagram for the following scenario.
A relational database is to be designed for a medium sized Company dealing with industrial applications of computers.
The Company delivers various computer products to its customers. Some products serve generic purpose, therefore, they are sold to various customers.
The Company has number of employees in each department; each is specialized in one particular area (i.e. consultant, programmer, support, system analyst, developer) but each area contains many employees.
For product delivery, projects are carried out in an inter-disciplinary way. The Company starts one new project for each requested product. When a project is undertaken, a team is formed by grouping employees from different departments that can share different groups.
An employee is also assigned as the project manager of the team who is entirely and exclusively responsible for the control of the project. An employee can manage more than one team. Teams and projects are only formed when a product order is placed.
Q2: Design a relational database by mapping the entity-relationship diagram (ERD) below into a relational model.
