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 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.
Exam #1 Review
Database Design & Management
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
Normalize this table
Project ( Project_Number, Proj_Desc, Proj_Duration, Requesting_Dept,