Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sybase Database Administrators Handbook

Authors: Brian Hitchcock

1st Edition

0133574776, 978-0133574777

More Books

Students also viewed these Databases questions