Question: Example - Problem Description A company runs a business and has employees, departments and projects. The details of employees, departments and projects are maintained. Employees

 Example - Problem Description A company runs a business and has

Example - Problem Description A company runs a business and has employees, departments and projects. The details of employees, departments and projects are maintained. Employees have dependents. Example - Data Model Requirements Summary 1. The company has a record of each employee's name, id, age, .... 2. An employee can have many dependents 3. An employee can work in many projects 4. Each project has a name, a unique number, a location .... 5. An employee belongs to one department 6. A project belongs to one department 7. A department has a unique number, a manager, and many locations Your lab assignment is to come up with similar requirements (as shown in the example above) for the two problems listed below. You can make reasonable assumptions and develop appropriate business rules: Problem # 1 Description A Library Management System database keeps track of books, authors and publishers. The details of library staff and library users are maintained. Staff maintains the book catalog with all the book author and publisher details. The Library staff can issue, return and reserve books to library users. The system maintains reserve date, issue date and return date. Problem #2 Description The Saudi Football League System database keeps track of teams, matches and stadiums. The details of team members, fans, management, coach, support staff and system users are maintained. Staff maintains the matches schedule, location, results and current team standing

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 Databases Questions!