Assignment # 1
Date:
Create ER Diagram for the following requirements
1. Creating Database for the National Football League (NFL)
NFL has many teams
Each team has a name, city, a coach, a captain and a set of players
Each Player belongs to only one team
Each player has a name, a position ( such as forward, defender, goalkeeper), a skill
level and a set of injury records
A game is played between two teams ( host and guest) and has a date and score
2. Construct an E-R diagram for a car-insurance company whose customers own one or
more cars each. Each car has associated with it zero to any number of recorded accidents.
3. Construct an E-R diagram for a hospital with a set of patients and a set of
medical doctors. Associate with each patient a log of the various tests and
examinations conducted.
4. Create E-R diagram for a college. A college contains many departments which can offer
any number of courses. Many instructors can work in a department and an instructor can
work only in one department. For each department there is a Head. An instructor can be
head of only one department. Each instructor can take any number of courses, but course
can be taken by only one instructor. A student can enrol for any number of courses and
each course can have any number of students.
5. Create E-R diagram for a database used to record student registration as following
A Course has an ID (for unique identification), syllabus, title, credits and
prerequisites.
A Student has an ID (for unique identification), name, and program.
An Instructor, has an ID (for unique identification), name, department, and title.A
Student may enrol into one or more Courses, while an Instructor teaches one or
more Courses.
Course Offering, the linked entity has a time (of course), section no., room id,
year and semester.
6. Construct an ER Diagram for Company having following details :
Company organized into DEPARTMENT. Each department has unique name and a
particular employee who manages the department. Start date for the manager is
recorded. Department may have several locations.
A department controls a number of PROJECTS. Projects have a unique name,
number and a single location.
Company's EMPLOYEE name, ssno, address, salary, sex and birth date are recorded.
An employee is assigned to one department, but may work for several projects (not
necessarily controlled by her dept). Number of hours/week an employee works on
each project is recorded; The immediate supervisor for the employee.
Employee's DEPENDENT are tracked for health insurance purposes (dependent
name, birthdate, relationship to employee).
7. Create E-R diagram on the basis for the following scenario assuming your own attributes.
This system stores various information about driver, bus, tickets and customer. Driver
drives bus, customer travel from one place to another by bus. Driver checks the ticket of
each customer for validity. Each customer must have ticket to travel by the bus.
8. An IT firm provides multiple services to its clients. A client can take multiple services
with a service start date and service end date. A client has to pay annual to renew the
service for another year. Draw the E-R diagram for the given scenario (assuming anu
other relevant facts if necessary).
Due Date: