Homework answers / question archive / Draw an ERD for the following scenario: Assume you are hired to design a database to keep track of the companies located in Cyprus

Draw an ERD for the following scenario: Assume you are hired to design a database to keep track of the companies located in Cyprus

Computer Science

Share With

Draw an ERD for the following scenario: Assume you are hired to design a database to keep track of the companies located in Cyprus. There are different types of companies. Each company has a company id, a name, a (located) city and multiple phone numbers. Companies are uniquely identified by company id. The companies are either domestic or foreign companies. Additionally for foreign companies, the origin country name and investor name must be kept in the database. Each company operates maximum four (4) departments, and each department belong to exactly one company. Each company employs zero or up to twenty (20) employees, and each employee works for zero or one department. For each employee, unique employee id, name (first and last), salary and date of birth (dob) must be kept in the database. One of the employees is the supervisor of all other employees in the company. Each employee may or may not have one or more dependents (children, spouse, etc.), and each dependent belongs to only one employee. Dependents' name and dependent id must be kept in the database. Dependents are identified by employee id and dependent id together. This means that if an employee decides to leave the company, all dependent information will be deleted from the database. Clearly indicate multiplicities, cardinalities and primary keys in the ERD.