CMSC424: Database Design. Instructor: Amol Deshpande email@example.com. Today…. Relational Database Design. Relational Database Design . Where did we come up with the schema that we used ? E.g. why not store the actor names with movies ? Topics:
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.
Instructor: Amol Deshpande
Movie(title, year, length, inColor, studioName, producerC#, starName)
Movie(title, year, length, inColor, studioName, producerC#, starNames)
Split Studio(name, address, presC#) into:
Studio1 (name, presC#) Studio2(name, address)???
Decompose StarsIn(movieTitle, movieYear, starName) into:
StarsIn1(movieTitle, movieYear) StarsIn2(movieTitle, starName) ???