2) A Holding Company ABC, which consists of many production companies, needs a database to keep track of its business. A

[answerhappygod]

2 A Holding Company Abc Which Consists Of Many Production Companies Needs A Database To Keep Track Of Its Business A 1 (128.2 KiB) Viewed 17 times

2) A Holding Company ABC, which consists of many production companies, needs a database to keep track of its business. All companies within the holding have their own name, address, website and telephone number. Each company can have one or more departments and each department belongs to only one company. On the other hand, for each department; there is a common DepartmentNo, e.g.: department number of human resources is 1008 and department number of production planning is 1024. Each department must have a foundation date and an e-mail address that should be recorded and each department must have at least one employee. However, an employee may not be affiliated with any department or may be affiliated with more than one department. In addition, each employee has an unique ID. ABC holding works on a project basis. If the project needs more than one department; departments from different companies can work on the corresponding project together. Each department can take part in one or more projects. Each project has a projectID, starting date, end date and budget. In addition, each project belongs to a specific customer; however, a customer may have more than one project. Projects are audited by at least one controller, who works independently as required by law and are not members of the holding. A controller may not be affiliated with any project or may be affiliated with more than one project. Controllers write a report about a project after each supervision (A controller can audit the same project more than once.) and each report has a report number and audit date. a) Draw the ER-Entity relationship diagram. You can use assumptions, if you think that the cardinalities are not clearly stated. Write down your assumptions. b) Resolve Many-to-Many relationships in your diagram, if there are any c) Create tables of the corresponding E-R diagram. Show all attributes. Define the primary keys and foreign keys of the tables.