Question: i have two tables the first one called names ( it contain names of people involoved in making movies ) the table attributes are nameid,

i have two tables the first one called names ( it contain names of people involoved in making movies ) the table attributes are nameid, name, profession1, profession2, profession3. so each name or person on the list might have no profession at all if alll three are null and up to 3 if three of them are not emplty . and then there knownfortitle1, knownfortitles2, Knownfortitle3, knownfortitle4 which are moviesid that theses people were invlolved in so each person might have been involved in zero if all of them are null and up to 4. now moving to titles table it contain info about the movies and the crew, so the attributes/columns are titleid, title, director1,director2,director3,director4. writer1,writer2,writer3,writer4 and writer5. princible category and a principle which for each movie might have 0 or multiple principle principle is basically a person from the names table. and principle and profession is the same for this person so basically all directors,writers and priciples are nameid that is belong to names in names table. as you can see thereir is so many to many relationship what i want is using theses two table create relational database in its 3rd normalisation 4.(provide erds and detailed attributes for each table with the realtionbetween tables )

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!