exam 1 review
Download
Skip this Video
Download Presentation
Database Design & Management

Loading in 2 Seconds...

play fullscreen
1 / 10

Database Design & Management - PowerPoint PPT Presentation


  • 81 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Database Design & Management' - milton


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
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
ad