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, profession profession profession so each name or person on the list might have no profession at all if alll three are null and up to if three of them are not emplty and then there knownfortitle knownfortitles Knownfortitle knownfortitle 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 now moving to titles table it contain info about the movies and the crew, so the attributescolumns are titleid, title, directordirectordirectordirector writerwriterwriterwriter and writer princible category and a principle which for each movie might have 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 rd normalisation 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
