2.1 XYZ Corporation, an IT and Digital media company is restructuring their organisation, part of whichincludes redesigning their database into a relational database. You have been tasked with redesigningthe new database. You have been given the following business rules, a manager can be a projectmanager or project lead. A project manager oversees a department, a project lead oversees a project.An employee can be a programmer or designer. A programmer must be front-end or back-end or both.A designer must always have a project they are working on.Draw the EERD for XYZ corporation and include all the necessary attributes.
Question
2.1 XYZ Corporation, an IT and Digital media company is restructuring their organisation, part of whichincludes redesigning their database into a relational database. You have been tasked with redesigningthe new database. You have been given the following business rules, a manager can be a projectmanager or project lead. A project manager oversees a department, a project lead oversees a project.An employee can be a programmer or designer. A programmer must be front-end or back-end or both.A designer must always have a project they are working on.Draw the EERD for XYZ corporation and include all the necessary attributes.
Solution
I'm sorry, but as a text-based AI, I'm unable to draw diagrams. However, I can guide you on how to create an Enhanced Entity Relationship Diagram (EERD) based on the given business rules.
-
Entities: From the business rules, we can identify the following entities: Manager, Employee, Department, Project, Programmer, Designer.
-
Attributes: Each entity will have its own attributes. For example, Manager and Employee might have attributes like ID, Name, Contact Information etc. Department might have attributes like DepartmentID, DepartmentName etc. Project might have attributes like ProjectID, ProjectName, ProjectDeadline etc. Programmer might have attributes like ProgrammingLanguage, Experience etc. Designer might have attributes like DesigningTool, Experience etc.
-
Relationships: Now, let's define the relationships between these entities based on the business rules.
- A Manager can be a Project Manager or Project Lead. This can be represented as a disjoint relationship between Manager, Project Manager and Project Lead.
- A Project Manager oversees a Department. This can be represented as a one-to-many relationship between Project Manager and Department.
- A Project Lead oversees a Project. This can be represented as a one-to-many relationship between Project Lead and Project.
- An Employee can be a Programmer or Designer. This can be represented as a disjoint relationship between Employee, Programmer and Designer.
- A Programmer must be front-end or back-end or both. This can be represented as a disjoint relationship between Programmer, Front-end Programmer and Back-end Programmer.
- A Designer must always have a Project they are working on. This can be represented as a many-to-one relationship between Designer and Project.
-
Constraints: The constraints can be derived from the business rules. For example, a Designer must always have a Project they are working on. This means that the relationship between Designer and Project is mandatory.
Remember to include all necessary attributes for each entity and to clearly label all relationships and constraints.
Similar Questions
The project manager has the most authority in the __________________ type of organization.a.Functionalb.Project expediterc.Projectized organizationd.Matrix
Question 4According to the Module 1 reading "What Makes Someone a Data Scientist”, the author defines a data scientist as someone who finds solutions to problems by analyzing data using appropriate tools and then tells stories to communicate their findings to whom?1 pointThe publicTheir supervisorThe companyThe relevant stakeholders
You are the project manager for the XYZ project. This a complex project involving the installation of hardware in a data center and the development of a new software application. The hardware installation requires a very specific process be followed and has fixed requirements. The software portion has known
In developing a Management Information System, which one of the following criteria should be the first concern of the designer? A. Selection of computer hardware. B. Definition of needs and objectives. C. Development of the database alternatives. D. Establishment of a project team and schedule.
The office Staff of XYZ Corporation presently consists of three bookkeepers( A,B, and C) and five secretaries (D,E,F,G,and H). Management is planning to open a new office in another city using three secretaries and two bookkeepers of the present staff. To do so they plan to separate certain individuals who do not function well together. The following guidelines were established to set up the new office.Bookkeepers A and C constantly find fault with one another and should not be sent as a team to the new office.C and E function well alone but not as a team.They should be separated.D and G have not been on speaking terms for many months. They should not go together.Since D and F have been competing for a promotion, they should be a team.1. If A is moved as one of the bookkeepers, which of the following CANNOT be a possible working unit?ABDEHABDGHABEFHABEGHABFGHClear selection2. If C is sent to the new office which member of the staff cannot go with C?BDFGHClear selection3. If D goes to the new office which of the following is (are) true? C cannot go.A cannot goH must also goI OnlyII OnlyI and II OnlyI and III OnlyI, II and III12. Five executives of a European corporation hold a conference in Rome:Mr. A converses in Spanish and ItalianMr. B converses in Spanish and EnglishMr. C converses in English and ItalianMr. D converses in Spanish and FrenchMr. E a native Italian can also converse in French1. Which of the following can act as interpreter when Mr C and Mr D wish to confer?Only Mr AOnly Mr BOnly Mr EMr A or Mr BAny of the other 3 executives2. Which of the following cannot converse without an interpreter?Mr B and Mr EMr A and Mr BMr A and Mr CMr B and Mr DMr A and Mr E3. Besides Mr E which of the following can converse with Mr D without an Interpreter?Only Mr AOnly Mr BOnly Mr CMr A and Mr BMr A, Mr B and Mr C4. Of the languages spoken at this conference which are the two least common?English and SpanishEnglish and FrenchItalian and SpanishEnglish and ItalianFrench and Spanish
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.