Mappy EDR

IS3280 Data Management
Assignment 5
Mapping ER Diagrams to Tables

Submit via D2L.

You can create your tables using the Table feature in word [or you can use Gliffy, Visio…]. The Table should be 1 column and the number of rows equals the number of attributes. Underline primary keys and italicize foreign keys. Use only the box border. The Table name goes above the table. For example:

TABLE_NAME
PrimaryKey
AttributeOne
AttributeTwo
AttributeThreeForeignKey
*the above table has a single attribute as a primary key

TABLE_NAME
CompositePrimaryKey
CompositePrimaryKey
AttributeOne
AttributeTwo
AttributeThreeForeignKey
*the above table has two attributes that make up a composite primary key

1. Convert the ER Diagram below to a list of tables. Be sure to identify primary keys and foreign keys.

EMPLOYEE (KSUID, LastName, FirstName)
PARKING SPACE (KSUID, ParkingSpaceNo, LotName)

2. Convert the ER Diagram below to a list of tables. Be sure to identify primary keys and foreign keys.

FARMER (TagNo, FName, LName, County, State)
Cow (TagNo, Breed, DOB)

3. Convert the ER Diagram below to a list of tables. Be sure to identify primary keys and foreign keys.

AUTHOR (AuthNo, AuthName)
BOOK (ISBN, Title, AuthNo)

4. Convert the ER Diagram below to a list of tables. Be sure to identify primary keys and foreign keys.

CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, Zip, Phone, Email, ReferID)

5. Map the following super-type, sub-type relationship to tables. Be sure to identify primary keys and foreign keys.

HOUSE (PropertyID, NumberOfBedrooms, Other­Attributes, PropertyType)
APARTMENT_HOUSE (PropertyID, NumberOfUnits, ManagerName, OtherAttributes, PropertyType)
COMMERCIAL (PropertyId, NumberOfUnits, TotalFloorSpace, OtherAttributes, PropertyType)