An organization has many departments through-out the country. Data held on each department is id, location,...

 

Transcribed Image Text:

An organization has many departments through-out the country. Data held on each department is id, location, and phone number. Id is used to uniquely identify a department. A department has one or more than one employee and each employee is employed in one and only one department. For employee eid, name, address, dob and contact number is required to be stored. Eid serves as a primary key. Address of employee composed of city, zip code, street number and house number. An employee may have more than one contact numbers. An employee may be a manager or an engineer or a developer. For manager role is required to be stored. For engineer engineering type is required to be stored and for developer domain expertise is required to be stored. An employee belongs to exactly one group. No other type of employee can be incorporated in the system. A department has one or many vehicles. Attributes of vehicle includes id, model, make, vehicle type i.e. (Ac or non-Ac). Vehicles are categorized into two types either Car or Bus. For car transmission type is required to be stored and for Bus passenger's capacity is required to be stored. Each vehicle doesn't belong to multiple sub groups. A manager is allocated zero or one car. A car is allocated to exactly one manager. An engineer is allocated zero or one Bus but a bus is allocated to one or many engineers. A manager manages one and only one department and a department has more than one manager to manage it. A department has one or many projects and each project belongs to exactly one department. Attributes of project includes project id, project title, project budget, project starting date and project ending date. A project may be Software project or construction project. A software project has a distinct attribute platform and construction project has as distinct attribute site. An engineer works on one and only one construction project whereas a construction project has one or many engineers working on it. A developer works on one or more software projects and a software project has one or many developers working on it. When a project is assigned to a developer, its assignment date is stored. Create an Entity Relationship diagram that captures this information. Be certain to indicate identifiers and cardinality constraints. An organization has many departments through-out the country. Data held on each department is id, location, and phone number. Id is used to uniquely identify a department. A department has one or more than one employee and each employee is employed in one and only one department. For employee eid, name, address, dob and contact number is required to be stored. Eid serves as a primary key. Address of employee composed of city, zip code, street number and house number. An employee may have more than one contact numbers. An employee may be a manager or an engineer or a developer. For manager role is required to be stored. For engineer engineering type is required to be stored and for developer domain expertise is required to be stored. An employee belongs to exactly one group. No other type of employee can be incorporated in the system. A department has one or many vehicles. Attributes of vehicle includes id, model, make, vehicle type i.e. (Ac or non-Ac). Vehicles are categorized into two types either Car or Bus. For car transmission type is required to be stored and for Bus passenger's capacity is required to be stored. Each vehicle doesn't belong to multiple sub groups. A manager is allocated zero or one car. A car is allocated to exactly one manager. An engineer is allocated zero or one Bus but a bus is allocated to one or many engineers. A manager manages one and only one department and a department has more than one manager to manage it. A department has one or many projects and each project belongs to exactly one department. Attributes of project includes project id, project title, project budget, project starting date and project ending date. A project may be Software project or construction project. A software project has a distinct attribute platform and construction project has as distinct attribute site. An engineer works on one and only one construction project whereas a construction project has one or many engineers working on it. A developer works on one or more software projects and a software project has one or many developers working on it. When a project is assigned to a developer, its assignment date is stored. Create an Entity Relationship diagram that captures this information. Be certain to indicate identifiers and cardinality constraints.