Question: Draw Entity - Relationship Model ( E - R Model ) 1 . ( Company Project ) AllforYou.com requests you to develop a database. The
Draw EntityRelationship Model ER ModelCompany Project AllforYou.com requests you to develop a database. The company wants to collect specific data about its employee, department, division, and project as follows: Employee: Employee ID Name, BOD, Hire date, Certificate Department: Department ID Name, Budget Division: Division ID Name, Budget, Region Project: Project Number, Description, Period Business Rules A department employs many employees, but each employee is employed by one and only one department. Some employee, known as rovers are not assigned to any department, but a department must have at least one employee. A division operates one or many departments, but each department is operated by one and only one division. An employee may be assigned many projects, but some employees in supportive department or division are not assigned to any project. A project has one or many employees assigned to it One of the employees manages each department, and each department is managed by one and only one employee. One of the employees runs each division, and each division is run by one and only one employee When an employee is assigned to a project, his role, assigned period, and name of supervisor are recorded. Art Museum An art museum owns a large volume of art works. Each work is described by an item code identifier title, type, and size; size is further composed of height, width, and weight. A work is developed by an artist, but the artist for some works is unknown. An artist may develop several works. An artist is described by an artist ID identifier name, and date of birth. Only data about artists for works currently owned by the museum are kept in the database. The museum sometimes participates in exhibitions and display possessed art works. An exhibition is described by an exhibition ID city to host the exhibition, period start and end date Only data about exhibitions, which display art works, are kept in the database. Art works can be loaned to other galleries. A gallery may loan several art works and an art work can be loaned to several galleries over time. Not all art works are loaned to galleries. A gallery is described by a gallery ID identifier name and city. Only data about galleries, which have loaned or are currently loaning art works, are kept in the database. Each time a work is loaned, the date the work was loaned and the date it was returned are kept in the database. A college course may have zero, one or more scheduled sections. Attributes of Course include a unique CourseID CourseName, and Units. Attributes of Section include SectionNumber eg or and SemesterID SemesterID is composed of Semester and Year. A combination of SectionNumber and SemesterID can distinguish one section from another section for the same course but does not uniquely identify a section.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
