Question

ER Diagrams (Database Management Systems)

Problem 2: Produce an ER diagram for the following description.
A spreadsheet has a unique le location, composed of a path and a le name. A spreadsheet is
composed of a set of worksheets, each having a name, unique to that spreadsheet, and a set of cells.
Each cell has a unique location within the worksheet, designated by (row, column), and a value.

Problem 3: You are given a description and an ER diagram below. Find at least ten (10)
mistakes in the diagram. Submit the diagram with your corrections, as well as an English descrip-
tion of each mistake. You must assume that all domain information to be reected in the diagram
is mentioned in the description.

You get three (3) points for each corrected mistake; even if correcting a mistake requires several
changes to the diagram, you get only three points. For each correction, you will receive one (1)
point for your textual description of the mistake, and two (2) points if you fully correct the issue
in your diagram. Please number each textual description, and label the associated change(s) in the
diagram, such that your submission is clear and understandable. You will get extra credit if you
nd mistake(s) your instructor has not anticipated.

Websites at AwesomeSites.me are either stores or blogs. Each site has a unique URL and a descrip-
tive title. Each blog is a single page with biographical information about the owner (note: individuals
may own as many blogs as they wish) and a set of posts. A stores is a catalog of products. Each
product has a unique ID, a description, and a price. Additionally, each product may belong to one
or more product categories (used for organization on the site). Each category has a name, unique
ID, and an associated color code.

URL Title WEBSITE URL URL STORE BLOG Bio Owner SELLS BELONGS TO ID PRODUCT CATEGORY Price Name Name ID

Problem 4: You have been given the task of writing a textual description of the ER dia-
gram below, which is unfortunately in a foreign language. For simplicity, your description can make
use of typical English grammar rules, such as ending nouns with an \s" (e.g. all Dobers . . . ) and
common verb endings (e.g. Totabs are huk'ed by Dobers).

The goal of this task it to recognize that a well-written ER diagram can communicate a great deal
of domain structure without the need for semantic meaning. However, if you are able to come up
with a semantic mapping that is consistent with the diagram, you will be awarded extra credit.

Answer 1

Puoblom & Name spreadsheet compose has o 0l Conta Path Valu de docatienae cilibn celunn