We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Entrance Examination System

The whole doc is available only for registered users

A limited time offer! Get a custom sample essay written according to your requirements urgent 3h delivery guaranteed

Order Now

An entity-relationship (ER) diagram is a specialized graphic that illustrates the relationships between entities in a database. ER diagrams often use symbols to represent three different types of information. Boxes are commonly used to represent entities. Diamonds are normally used to represent relationships and ovals are used to represent attributes.

Below are two (2) problems for you to answer. Read the instructions carefully for you to be guided on what to do. After answering the examination, please be reminded that you are instructed to do the following: 1. Encode your answers using Microsoft Word. Save the file following this format: _midterm_sadsign. Example is roldan_midterm_sadsign.

2. Send the file as an attachment to [email protected] before midnight of January 29, 2013. Late submission will not be entertained and will automatically have a grade of zero (0). Use the filename of the file as the SUBJECT for your email. 3. Refrain from distributing your answers to your classmates.

Entity-Relationship (E-R) Diagram Problem No. 1
Create an ER diagram for the following application from the manufacturing industry:
1. Each supplier has a unique name.
2. More than one supplier can be located in the same city.
3. Each part has a unique part number.
4. Each part has a colour.
5. A supplier can supply more than one part.
6. A part can be supplied by more than one supplier.
7. A supplier can supply a fixed quantity of each part.

Entity-Relationship (E-R) Diagram Problem No. 2
The Motor Vehicle Branch administers driving tests and issues driver’s licenses. Any person who wants a driver’s license must first take a learner’s exam at any Motor Vehicle Branch in the province. If he/she fails the exam, he can take the exam again any time after a week of the failed exam date, at any branch. If he passes the exam, he is issued a license (type = learner’s) with a unique license number. The person may take his driver’s exam at any branch any time before the learner’s license expiry date (which is usually set at six months after the license issue date). If he passes the exam, the branch issues him a driver’s License.

Create an E-R diagram following these steps.
1. Find out the entities in the specifications.
2. Find out the relationships among the entities.
3. Figure out attributes of the entities and (if any) of the relationships.
4. Figure out constraints between entities and relationships.
5. Check to see if you miss anything in the specifications.

Related Topics

We can write a custom essay

According to Your Specific Requirements

Order an essay
Materials Daily
100,000+ Subjects
2000+ Topics
Free Plagiarism
All Materials
are Cataloged Well

Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email.

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
Sorry, but only registered users have full access

How about getting this access

Your Answer Is Very Helpful For Us
Thank You A Lot!


Emma Taylor


Hi there!
Would you like to get such a paper?
How about getting a customized one?

Can't find What you were Looking for?

Get access to our huge, continuously updated knowledge base

The next update will be in:
14 : 59 : 59