Entity Relationship Diagrams

criteria
Define the connections between tables in database
Create an entity-relationship (ER)

model

can be represented as a collection of one or more

'objects', 'things' or 'entities'.
For example a school is made up of one or more buildings each of which contain classrooms, each classroom has a number of desks, chairs and so on. The School system can be represented as a collection of entities, each of which have a relationship with one another.

For example, if we look at the tables required for

an online store:

Staff
Products
Receipts
Customers

When we start to describe each of them we notice that they are related to each other.

For example:
The Receipt table records which product a customer has bought, and which date it was purchased on.

This describes the Receipt record, and looking at its structure we see that the primary keys from other tables are included in it.

we could say:

many students
Answer:
A league has many teams A team is only in

one league

Answer:
A player answers many questions
A question can be answered many times
Each answer is only applicable to one question
A player can give many answers
Each answer has only one player contributing

between an owner and a cat
Cat >---< Owner (even

though an Owner may own more than one cat, a cat might have more than one owner)

The relationship between a car and a drive
Car --- driver (a car can only be driven by one driver, a driver can only drive one car at one time)

The relationship between a unicycle and a wheel
wheel --- unicycle

The relationship between a house and a postcode
House >--- Postcode (a house is assign one postcode, but that same postcode might be assigned to many houses)

car.
The company keeps a record of the employee's name

and unique employee Number.
The company records the registration number of the car and the model and maker.

What are the entities about which data is stored?
Employee, Car. What is the relationship between Employee and Car?
A car is allocated to a single employee.
An employee is provided with a single car.

patient is assigned a unique patient ID. The following details

are recorded about each patient:
-patient name
-date of birth
Each ward has a unique name. The number of beds is recorded for each ward.
What are the entities about which data are stored?
Ward, Patient. What is the relationship between a Ward and Patient?
Each patient is allocated to a single ward.
Each ward can accommodate one or more patients

to set up online ordering facilities.Here are the data requirements

for the underlying database:
Each product item is assigned a unique item code and has an item description.
The quantity in stock of each item is recorded.
The unit price of each stock item is stored.
Each order is assigned a unique order number.
For each order, the customer name, delivery address and e-mail address are recorded.
For each order, the order date is recorded.
An order may consist of one or more different items.
The quantity of an item ordered may be more than one.
Customers details will not be stored for future orders.

catalogue.

Order.

What is the relationship between Item and Order? An order

consists of one or more items. An item may appear in one, none or several orders.
When the degree of a relationship is not obvious, look at some of the I Key terms entity occurrences in one list and link them with the members of the Entity occurrence: the details of one other list as in Tables 1 to 3. This shows that the relationship between instance of the entity. Item and Order is many-to-many

Cont.

that enroll students for AS and A2 courses. Here are the

data requirements:
Each course is assigned a unique course code and has a course name.
Each student is assigned a unique student ID and has their name, address and date of birth recorded.
Each student enrols on one or more courses.
The students enrolled on a course will be assigned to one of several sets taught by different teachers.
Teachers Are assigned unique initials.
The data constraint for this database is that teacher details will not be stored. What are the entities about which data are stored?
Course, Student, Set. What is the relationship between Course and Student?
A student may enrol on one or more courses.
A course may be taken by one or more students.
What is the relationship between Course and Set? A course may consist of one or more sets. A set belongsto just one course. What is the relationship between Student and Set? Students are assigned to one or more sets and each set will consist of one or more students

A guide dog will look after just one blind person and

a blind person will only have one guide dog.
Draw an entity-relationship diagram to represent this relationship.

2. Every car registered in the UK has a unique registration number and one registered keeper. The Driver and Vehicle Licensing Agency (DVLA) records the keeper's name and address. One person may keep several vehicles. Draw an entity-relationship diagram to represent this Relationship.
3. A lending library lends out books to borrowers. Each borrower may borrow several books. There may be more than one copy of popular books. The library records names and addresses of borrowers and each borrower has a unique borrower ID. Each book title is identified by its ISBN. Each book copy is identified by a unique accession number. Draw an entity-relationship diagram to represent this system.

entity is represented by a rectangular box and named using

a noun

Entity (noun )

Attributes (adjective)

Relations( verb)

minimum of detail about the object - in your mind

you be thinking about its size, buildings, name and so on. These are called its 'attributes'. An attribute describes one aspect of the entity.
A set of attributes for two entities named Product and Supplier