1 / 10

Essential Guide to Database Design and Management Exam Review

Prepare for your Database Design and Management Exam with this comprehensive review covering major topics such as keys, relationships, functional dependencies, normalization, subtypes, and supertypes. Dive into E-R modeling using Crow’s Foot notation and practice creating diagrams for different relationship types. Explore candidate keys from provided relations and identify functional dependencies. Hone your skills with normalization exercises and E-R diagram creation involving various entities. Ensure you're ready for Exam #1 on February 24th by mastering these key concepts.

milton
Download Presentation

Essential Guide to Database Design and Management Exam Review

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Exam #1 Review Database Design & Management

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

  3. 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

  4. 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

  5. Practice Normalize this table Project ( Project_Number, Proj_Desc, Proj_Duration, Requesting_Dept, Dept_Phone_Number)

  6. 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

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

  8. 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

  9. 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

More Related