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 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
Get step-by-step solutions from verified subject matter experts
