SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 12 Dec 2017 My Price 10.00

Data Dictionary based on the ERD Teaching Professor

The assignment for the SLP is to 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 (See Table 1)

Table1.png

 

Table 2 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.

 

Table2.png

 

SLP Assignment Expectations:

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

ERD Teaching Professor Example.png

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 12 Dec 2017 12:12 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)