Question: Draw Entity - Relationship Model ( E - R Model ) 1 . ( Company Project ) AllforYou.com requests you to develop a database. The

Draw Entity-Relationship Model (E-R Model)1.(Company 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. 2.(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. 3. A college course may have zero, one or more scheduled sections. Attributes of Course include a unique Course_ID, Course_Name, and Units. Attributes of Section include Section_Number (e.g.,1 or 2) and Semester_ID. Semester_ID is composed of Semester and Year. A combination of Section_Number and Semester_ID 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!