Exam 1 review
This presentation is the property of its rightful owner.
Sponsored Links
1 / 10

Database Design & Management PowerPoint PPT Presentation


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

Exam #1 Review. Database Design & Management. Need to Know. Major topics Keys Relations Functional dependency Normalization Subtypes and Supertypes Weak and Strong entities E-R modeling using Crow’s Foot notation Database design Cover chapters 1, 2, 4 and 5. Practice.

Download Presentation

Database Design & Management

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


Exam 1 review

Exam #1 Review

Database Design & Management


Need to know

Need to Know

  • Major topics

    • Keys

    • Relations

    • Functional dependency

    • Normalization

    • Subtypes and Supertypes

    • Weak and Strong entities

    • E-R modeling using Crow’s Foot notation

    • Database design

  • Cover chapters 1, 2, 4 and 5


Practice

Practice

  • Individually, do the following

    • For each of the following exercises, use EMPLOYEE as one of your entities

      • 1) Create and diagram a 1-1 relationship

      • 2) Create and diagram a 1 to many relationship

      • 3) Create and diagram a many to many relationship


Practice1

Practice

Given the following relation, identify any candidate keys

Cars(type, color, numberOfDoors, manufacturedBy, VIN, countryOfOrigin )

Given the following relation, identify all functional dependencies

Artwork(artistName, titleOfArtwork, typeOfArt, whereCreated, artistCompleteAddress,

artistEmail, artworkID, suggestedRetailCost, artistID)

Then normalize the Artwork relation


Practice2

Practice

Normalize this table

Project ( Project_Number, Proj_Desc, Proj_Duration, Requesting_Dept,

Dept_Phone_Number)


Practice3

Practice

  • Individually

    • Use the entity Person

      • 1) Create a diagram using exclusive subtypes with a discriminator

        • Be sure and include the discriminator in your diagram

        • Include 2 exclusive subtypes

      • 2) Create a diagram using inclusive subtypes

        • Include 4 inclusive subtypes


Practice4

Practice

  • Individually

    • Your are given the following entities

      • PROJECT

      • DEPARTMENT

      • ASSIGNMENT

    • Using your knowledge of how projects work, create an E-R diagram with the above 3 entities

      • List any assumptions you make

    • Include identifiers

    • Cardinalities

    • Basic attributes


Practice5

Practice

  • Consider the traffic violation shown on the next slide

    • The rounded corners on this form provide graphical hints about the boundaries of the entities represented

  • Create a data model with 5 entities

    • Specify identifiers for each

    • Specify attributes for each

      • Include data type

      • Null status

  • State the type of relationship between entities

    • Include cardinalities


Exam 1 february 24 th

Exam 1, February 24th

  • Exam #1

    • If you do not attend class, I will place a make-up exam in the test center by 9:30 Tuesday morning

      • NOTE: I will subtract 20 points from your test score (one letter grade)

      • This is your responsibility! I will not send emails or phone you or visit your favorite haunts to let you know that you need to take the exam…

      • You will have until 12:00 p.m. (noon) on Wednesday, January 26th to complete the exam in the test center

        • I will pick up any completed exams at noon on Wednesday so the exam can be graded by the beginning of class on Wednesday

      • If you do not complete the exam, you will earn 0 points for this exam score


  • Login