The project should include the following items
This presentation is the property of its rightful owner.
Sponsored Links
1 / 21

The project should include the following items PowerPoint PPT Presentation


  • 81 Views
  • Uploaded on
  • Presentation posted in: General

The project should include the following items. Graphical process model containing 3 to 10 activities/process steps. An Entity/Object Pool with 3 to 5 entities. An Entity Relationship Matrix for the entities identified in step 2.

Download Presentation

The project should include the following items

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


The project should include the following items

The project should include the following items

  • Graphical process model containing 3 to 10 activities/process steps.

  • An Entity/Object Pool with 3 to 5 entities.

  • An Entity Relationship Matrix for the entities identified in step 2.

  • A fully refined or attributed Logical Data Model normalized to third normal form.

  • A data dictionary for the logical model created in step 4.

  • An Access 2007 Database created by transforming the logical model in step 4 into a physical design. Each table in the database should contains at least 4 records.

  • At least two Forms for the database created in step 6. The forms at a minimum should enable record addition, deletion, modification.

  • At least two Queries for the database created in step 6.

  • At least two Reports for the database created in step 6.


1 graphical process model containing 3 to 10 activities process steps

1. Graphical process model containing 3 to 10 activities/process steps.

Manage Video Rental Business

Customer data collection form

1.0

Input Customer Information

3.0

Track Customer Rentals

Customer address and preference information

Customer

history and status

Emails

5.0

Advertise and Track Specials to New and Repeat Customers

Returned movies

Postal

mailing

2.0

Manage Video Inventory

Inventory with shelf location

New movies

4.0

Order New Movies

Movie order form

Studio movie release info


2 an entity object pool with 3 to 5 entities

2. An Entity/Object Pool with 3 to 5 entities.

  • Movie

  • Western

  • Action and Adventure

  • Comedy

  • Documentary

  • Movie Studio

  • Customer

  • Movie Rating


3 an entity relationship matrix for the entities identified in step 2

3. An Entity Relationship Matrix for the entities identified in step 2.


Fully attributed refined model example

Fully Attributed/Refined Model Example

MOVIE

RENTAL

MOVIE

CUSTOMER

Is Rented By

Movie # (Fk1)

Copy #

Customer # (Fk2)

Rent Date

Return Date

Late Status

Movie #

Title

Length

Movie Type

MPAA Rating

Customer #

Last Name

First Name

Cust Address

Cust Phone #

Rents

Is Distributed by

(TYPE)

WESTERN

Movie #

ASPCA Rating

MOVIE

DISTRIBUTOR

MOVIESTUDIO

Distributor Name

Movie # (Fk1)

Studio Name(Fk2)

Release Date

Contact Name

Contact Phone #

Studio Name

Address

Makes


5 0 a data dictionary for the logical model created in step 4

5.0 A data dictionary for the logical model created in step 4.

  • Movie-An item that is available to rent, a motion picture or television production.

    • Movie #-Unique identifier of the item available for rent.

    • Title-The name of the item available for rent.

    • Length-The running time in minutes of the item available for rent.

    • Movie Type-The genre or classification associated with the items available for rent. Valid values are: Action and Adventure, Animation , Christmas , Comedy , Comic Book-Based , Documentary, Drama, Family, Horror, Martial Arts, Musical, Science Fiction and Fantasy , Silent Movie, Sports, War Movie, and Western .

    • MPAA Rating-Motion Picture Association of America evaluation. Valid values are: G, PG, PG-13 R, and NC-17.

  • Western-A genre or type of Movie/Television production.

    • ASPCA Rating-American Society for the Prevention of Cruelty to Animals evaluation.

  • Movie Rental-An instance of a Movie being rented by a customer.

    • Movie # (Fk1)- Unique identifier of the item available for rent.

    • Copy #-The sequence number of the item available for rent. Used to differentiate multiple copies of a Movie.

    • Customer # (Fk2)-Unique identifier of an individual authorized to rent a Movie.

    • Rent Date-The date a Movie is rented by a Customer.

    • Return Date-The date a rented Movie is to be returned to the store for restocking.

    • Late Status-A status code identifying if the rental item has not been returned by the Return Date.


5 0 a data dictionary for the logical model created in step 4 con t

5.0 A data dictionary for the logical model created in step 4. (con’t)

  • Customer-the patron who rents Movies.

    • Customer #-Unique identifier of a customer.

    • Last Name-the Customer’s surname.

    • First Name-the Customer’s given name.

    • Customer Address-the location (postal) where a Customer may be communicated with.

    • Cust Phone #-the area code and telephone number of the Customer. If Address is outside of the USA, then a country code is required.

  • Movie Studio-a company that makes and produces motion pictures/television shows.

    • Studio Name-Unique identifier of a Movie Studio.

    • Address-the location (postal) where a Movie Studio may be communicated with.


5 0 a data dictionary for the logical model created in step 4 con t1

5.0 A data dictionary for the logical model created in step 4. (con’t)

  • Movie Distributor

    • Distributor Name- Unique identifier of the company that distributes movies for the Studios.

    • Movie # (Fk1)-Unique identifier of the item available for rent.

    • Release Date-The date that the rental item is available for rent.

    • Studio Name(Fk2)-Unique identifier of a Movie Studio.

    • Contact Name-the identification of a person at a Movie Studio to whom communication should be directed.

    • Contact Phone #-the area code and telephone number of the Movie Studio Contact. If Address is outside of the USA, then a country code is required.


The project should include the following items

6.0 An Access 2007 Database created by transforming the logical model in step 4 into a physical design

  • See Access File: Manage Video Rental v1.accdb


First normal form 1nf

First Normal Form - (1NF)

  • Every key and non-key attribute of an entity must be single valued

  • No entity instance can have multiple values for a given attribute

    • i.e., The No Repeat Rule

  • A violating entity is corrected by removing repeating or multivalued attributes to another, dependent (child) entity


  • First normal form example

    First Normal Form - Example

    RESTAURANT

    REST NAME

    ADDRESS

    PHONE #

    EMPLOYEE NAME

    REST NAME ADDRESS PHONE # EMPLOYEE NAME

    BURGER KING

    123 NORTH ST

    123-2345

    JOHN, SUE, LISA

    TACO HOUSE

    345 126TH PLACE

    765-8907

    MARY, BILL

    FISH COMPANY

    77 SUNSET AVE

    395-5682

    ED, SAM, JOSE, RICK

    RESTAURANT

    EMPLOYEE

    REST NAME

    EMPLOYEE NAMEREST NAME

    ADDRESS

    employs

    PHONE #

    POSITION


    Second normal form 2nf

    Second Normal Form - (2NF)

    • An entity that is in first normal form and each non-key attribute is dependent on the entire primary key

    • No non-key attribute instance can be determined by knowing just part of an entity instances key

    • A violating entity is corrected by removing to a parent entity any attributes that depend on only a subset of the primary key


    Second normal form example

    SUPPLIER

    RESTAURANT ORDER

    REST NAME

    SUPPLIER NAME

    ORDER ITEM

    PHONE #

    SUPPLIER NAME (FK1)

    Second Normal Form - Example

    RESTAURANT ORDER

    REST NAME

    SUPPLIER NAME

    ORDER ITEM

    SUPPLIER PHONE #

    REST NAME SUPPLIER NAME ORDER ITEM SUPPLIER PHONE #

    BURGER KING

    SAM'S PRODUCE

    BEEF

    123-2345

    TACO HOUSE

    SALSA INC.

    PEPPERS

    765-8907

    FISH COMPANY

    SAM'S PRODUCE

    SNAPPER

    123-2345

    fills


    Third normal form 3nf

    Third Normal Form - (3NF)

    • An entity that is in second normal form and each non-key attribute is only dependent on the entire primary key and nothing other than the key

    • No non-key attribute instance can be determined by knowing the value of another non-key attribute for the same instance

    • A violating entity is corrected by removing to a parent entity any attributes exhibiting transitive dependencies (non-key attributes that not only depend on the whole key but also on other non-key attributes)


    Sample information model

    Sample Information Model


    Categorization example

    Categorization Example

    WESTERN

    SUSPENSE

    COMEDY

    MALE

    FEMALE

    (MOVIETYPE)

    (SEX)

    MOVIE

    PERSON

    INCOMPLETE CATEGORIZATION

    (there are other movie types such as Documentary)

    COMPLETE CATEGORIZATION


    Planning model example

    Planning Model Example

    MOVIE

    CUSTOMER

    Is Rented By

    / Rents

    Is Produced In/

    Produces

    (TYPE)

    STUDIO

    WESTERN


    Key based model example

    Key-Based Model Example

    MOVIE

    RENTAL

    MOVIE

    CUSTOMER

    CUSTOMER #

    MOVIE #

    MOVIE # (FK1)

    CUSTOMER # (FK2)

    DATE

    Rents

    Is Rented By

    Is Produced by

    MOVIE

    (TYPE)

    PRODUCTION

    STUDIO

    STUDIO ID (FK2)

    MOVIE # (FK1)

    STUDIO ID

    WESTERN

    Funds

    MOVIE #


    Non specific connection relationships

    Non-Specific ConnectionRelationships

    • A relationship where one instance of an entity may relate to 0, 1, M instances of a second entity; and one instance of the second entity may relate to 0, 1, M instances of the first entity

    • For Example:

      • A Customer Rents at 0,1,M Movies, and Each Movie is Rented by 0, 1, M Customers

    MOVIE

    CUSTOMER

    Movie Number

    Cust Number

    rents/is rented by

    Name

    Name

    Rating

    Address

    Rental Rate

    Status Code


    Specific connection relationships

    Specific Connection Relationships

    • A Parent - Child relationship that resolves a non-specific relationship to capture additional detail

    • A relationship where one instance of an entity (Parent) may relate to 0, 1, M instances of the second entity (Child), and the Child entity is related to one and only one instance of the Parent entity

    • For Example:

    • A CUSTOMER Rents a specific copy of a MOVIE

    Movie Rental Record

    Customer

    Movie Number

    Movie Copy Id

    Rental Date

    Cust Number (FK)

    Cust Number

    rents according to

    Name

    Address

    Status Code


    Movie genres

    Movie Genres

    • Action and Adventure

    • Animation

    • Christmas

    • Comedy

    • Comic Book-Based

    • Documentary

    • Drama

    • Family

    • Horror

    • Martial Arts

    • Musicals

    • Science Fiction and Fantasy

    • Silent Movies

    • Sports

    • War Movies

    • Westerns


  • Login