Scribd
Upload
889 views2 pages

P3 - EER Diagram

The document describes an assignment to model a magazine, writer, and subscriber database using an Entity-Relationship (E-R) diagram. It provides details on the entities and relationships to include in the diagram, and instructions to draw the diagram in Microsoft Visio and submit the file. It also provides additional questions to modify and expand the initial E-R diagram.

Uploaded by

Melya witri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
889 views2 pages

P3 - EER Diagram

The document describes an assignment to model a magazine, writer, and subscriber database using an Entity-Relationship (E-R) diagram. It provides details on the entities and relationships to include in the diagram, and instructions to draw the diagram in Microsoft Visio and submit the file. It also provides additional questions to modify and expand the initial E-R diagram.

Uploaded by

Melya witri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

MJ 514 BASIS DATA

Pokok Bahasan Enhanced Entity-Relationship Diagram (EE-R Diagram)


TIK 1. Memodelkan permasalahan di dunia nyata ke dalam model E-R
2. Membuat Diagram E-R
Setoran File Visio dan Word di-zip, upload dengan nama NIM.zip
Batas Akhir Setoran Akhir sesi Praktikum

Instructions: Answer the following question in this file with Blue font color, for the ER
Diagram, use Microsoft office Visio, draw ER on separate page in 1 File.

1. Give an ER diagram for a database recording information about magazines, writers, and
subscribers, including:
 For each magazine, its name, its writers, its editor, and the cities to which it is
delivered.
 For each writer, their name. (Note: a writer can write for more than one magazine,
but can only edit, at most, one magazine.)
 For each subscriber, their name, favorite writers, city of residence, and what
magazines they receive.
For all entities and relationships, select and specify keys.

2. Modify (1.) above to record for each writer the history of magazines which they have
edited, including the start date and ending date of the position for each such magazine.
(You do not have to redraw the complete diagram, just the modification.) use different
line color for the modification (in Visio)

3. Explain whether your design in (2.) is able to represent a scenario in which a writer can
be the editor of the same magazine over two distinct time periods. For example, an
editor that was fired and then re-hired by a magazine. If your design does not handle
this situation, draw the modification to the ER diagram. use different line color for the
modification (in Visio)

4. At the institutions of the university we find hundreds of copying machines - all of them
malfunctioning now and then. To come to grips with those never-ending problems the
University Copy Supervisor has made up his mind: creating a database storing relevant
information about the machines and repairs will be of great help. In this database he
wants to store information regarding the machines and repairs as follows:
 The copy machines. Each machine is of a specific model and has been given a
unique number (they are numbered 1, 2, 3 etc). It’s purchased on a specific date and
is owned by a specific institution.

1
 Machine models. Each model is of a certain brand (e.g. Xerox, Olivetti, Selec,
Ricoh). Most of the model names are short - no more than 30 characters. (Keep in
mind that it’s possible that different brands have models with the same name.)
 The institutions. Each has a three-character code and a name (e.g. the Institution
for Mathematics has the code IMA).
 Error reports. When a copying machine malfunctions, a report is written stating
which machine is malfunctioning, the date the report is written, and a short
description of what the problem is. The report is given a unique number.
 Repair companies hired to fix the reported errors. Each of the companies has
been given a unique number. Of course, the name and phone number of the
company are recorded. Each company has one or a few technicians/contacts the
university can call for service. Each company is specialized on certain machine
models. To get cheaper repairs the university on its company list has at least two
companies competent to do repairs on the same model. This also has the advantage
of getting the service quicker when in hurry (if one company can’t come quick
enough the other one might).
 Information is recorded about every repair for each machine: date when the repair
was ordered, date when the repair was done (i.e. the error was fixed). Of course, the
university wants to keep track on which one of the reported errors have been fixed.
Information about the repair is stored as soon as it has been ordered.
Construct an ER diagram for the database. For any missing information make a
reasonably assumption.

You might also like