2 Parts. Diagrams, data dictionaries, data storage.
2 parts
PART 1
Create a Data Dictionary based on the ERD Teaching Professor example as noted below. The following Memorabilia Online Store Data Dictionary table is a guide to how a Data Dictionary is constructed.
In the Memorabilia Data Dictionary, the default value field consists of a null value when the information is not known. A character type is alpha text, which is used for names, descriptions, and anything related to alphabet letters. In the case of integers, currency, floating, and dates, the value could be zero or any number. A field is mandatory based on business rules established in the database. A field is unique to a “Yes” value in order to identify the primary and foreign keys.
An item in the catalog of products available for purchase by a customer.
| Product |
|
|
|
|
|
|
| Data Member Name | Description | Type | Additional Type Information | Default Value | Mandatory? | Unique? |
| Product Number | The unique identifier of the item in the catalog | Integer | 00000000 to 99999999, always 8 digits including leading zeroes | 0 | Yes | Yes |
| Description | Short description of the product for customer consumption | Character | min:1, max:256 | null | No | No |
| Unit Cost | The current list price of the product | Currency | GBP min $0.00 max $1000000.00 | null | Yes | No |
| Product Number | The unique identifier of the item in the catalog | Integer | 00000000 to 99999999, always 8 digits including leading zeroes | 0 | Yes | Yes |
| Description | Short description of the product for customer consumption | Character | min:1, max:256 | null | No | No |
The table below provides a template for the use of a Data Dictionary in new systems development. It has the standard format for loading data element information into a Metadata Database Repository (MDR). This template not only defines the required format and content for the Data Dictionary, but it can also be used as a checklist to define all entities in the data model.
Template for the Data Dictionary Teaching Professor Assignment
| Teaching Professor |
|
|
|
|
|
|
| Data Member Name | Description | Type | Additional Type Information | Default Value | Mandatory? | Unique? |
| <data member name> | <describe the meaning of the data member in the problem domain> | <Character or Integer> | <specify max and min length and any specifically disallowed characters> | <if required> | Yes/No | Yes/No |
| <data member name> | <describe the meaning of the data member in the problem domain> | <Character or Integer> | <specify a range if known> | <if required> | Yes/No | Yes/No |
| <data member name> | <describe the meaning of the data member in the problem domain> | <Character or Integer> | <specify max and min values, no of decimal points and unit of measurement> | <if required> | Yes/No | Yes/No |
| <data member name> | <describe the meaning of the data member in the problem domain> | <Character or Integer> | <specify the values that the field can take on> | <if required> | Yes/No | Yes/No |
| <data member name> | <describe the meaning of the data member in the problem domain> | <Character or Integer> | <specify the currency and max and min values> | <if required> | Yes/No | Yes/No |
| <data member name> | <describe the meaning of the data member in the problem domain> | <Character or Integer> | <specify the expected presentation format if there is one> | <if required> | Yes/No | Yes/No |
PART 2
Create a Data Dictionary for the ERD Teaching Professor example given here.
Use the Memorabilia Online Store Data Dictionary format as a guide.
The blank template should be used to identify the data member names by entering the name of each of the six entities in the ERD. Each row should have an entity with description, type, information, value, etc.
For this example, business rules are entity relationships. Please note that foreign keys (FK) form the association between two entities. A primary key (PK) is identified as the first attribute in an entity, and the foreign key is in bold as the last attribute within an entity.
ERD Teaching Professor Example
A student enrolled can take one or many classes
A class can have zero, one, or many students
A professor teaches zero, one, or many classes and a class is taught by one professor
A course may generate zero, one, or many classes and a class comes from one course
A class is held in one room but a room has many classes
