Question No1:

A company has a number of employees. The attributes of

EMPLOYEE include Emp_ID (identifier), Name, Address, and
Birthdate.
The company also has several projects. Attributes of PROJECT
include Proj_ID (identifier), Proj_Name, and Start_Date.
Each employee may be assigned to one or more projects, or may
not be assigned to any project.
A project must have at least one employee assigned to it, and
may have any number of employees assigner to it.
An employee s billing rate may vary by project, and the
company wishes to record the applicable billing rate
(Billing_Rate) for each employee when assigned to a particular
project. 1ST ERD DESIGN

Project_ID
Employee ID
Billing_Rate

Name EMPLOYEE PROJECT

Address Birthdate
Project_Name Start_Date

2ND ERD DESIGN

Attribute of the Relationship

Billing_Rate

EMPLOYEE PROJECT
Employee_ID
Project_ID
Name
Address Project_Name
Birthdate Start_Date

Every Project must have an Not Every Employee works

employee on a project
 Question No 2:

A university has a large number of courses in its

catalog.
Attributes of COURSE include Course_num
(identifier), Course_Name, and Credit_Hrs.
Each course may have one or more different courses
as prerequisites, or may have no prerequisites.
Similarly, a particular course may be a prerequisite for
any number of courses, or may not be a prerequisite
for any other course.
1st ERD Design
Course_Num

Course_Name COURSE

Credit_hrs
QUESTION NO:3rd
A laboratory has several chemists who work on one or more projects.
Chemists may also use certain kinds of equipment on each project.
Attributes of CHEMIST include Employee_ID (identifier), Name, and
Phone_no.
Attributes of PROJECT include Project_ID (identifier) and Start_Date.
Attributes of EQUIPMENT include Serial_no. and Cost.
The organization wants to record Assign_Date – that is, the date when All three entities
This relationship was created
a give equipment item was assigned to a particular chemist working on participate
to show
in an assignment.
a specified project. However,
what projects a chemist works
on. In the
A chemist must be assigned to at least one project and one equipment EQUIPMENT and
case where no equipment is
PROJECT do not need to
item. participate in any
used for a
project, there would be no way
A given piece of equipment need not be assigned, and a given project assignments. All entities
of showing
can have multiple
need not be assigned either a chemist nor a piece of equipment. assignments.
an assignment using the
Assigned
relationship.
ERD DESIGN

Employee ID
Project_ID

Name CHEMIST PROJECT

Start_Date
Phone_No Assign_Date

EQUIPMENT

Cost Serial_Number
QUESTION NO 4rth:

A College course may have one or more scheduled

sections, or it may not have a scheduled section.
Attributes of COURSE include Course_ID (identifier),
Course_Name, and Units.
Attributes of SECTION include Section_Number and
Semester_ID.
 Semester_ID is composed of two parts:
Semester and Year.
 Section_Number is an integer
that distinguishes one section from another for the
same course but it does not uniquely identify a
section.
ERD DESIGN

Course_ID Section_Number

COURSE SECTION

Course_Name Units Semester_ID

Semester Year