Week 4

Post date: Oct 09, 2016 6:1:15 AM

Quiz 1 will be on Week 5 (Monday)

Chapter 7: Data Modeling Using Entity-Relationship (ER) Model(Cont...)

Weak entity type

ER diagrams, naming conventions, and design issues

ER Ex 1:

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.

Sample of a solution

ER Ex 2:

You are asked to set up a database called "ArtBase" that builds a product for art galleries. The core of this product is a database with a schema that captures all the information that galleries need to maintain.

Galleries keep information about artists, their names (which are unique), birthplaces, age,and style of art. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price must be stored. Pieces of artwork are also classified into groups of various kinds, for example, portraits, still lifes, works by Picasso, or works of the 19th century; a given piece may belong to more than one group.

Each group is identified by a name (like those just given) that describes the group. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique name, address, total amount of dollars spent in the gallery (very important!), and the artists and groups of art that the customer tends to like.

Draw the ER diagram for the database.

Solution