Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started