IT234__Unti2_Assn1.docx IT234 Logical Database Model Purdue Global University IT234 Da

Document Content and Description Below

IT234__Unti2_Assn1.docx IT234 Logical Database Model Purdue Global University IT234 Database Concepts Logical Database Model The entities that I have in my Logical Model are movie, genre, direct... or, and Actor. In the movie entity, the attributes are title and rating. The title data type is going to be varchar and the rating will be int. Varchar represents characters and int represents numbers. In the genre entity, the attribute is genre, and the genre data type is varchar. In the director entity, the attributes are f_name and l_name, the data type will be varchar for both. In the actor entity, the attributes are f_name and l_name, the data type will be varchar for both. We have the primary and foreign keys. The primary key is the unique identifier for each table. The foreign key links the tables together. The primary key in the movie table will be movie_id. The primary key in the genre table will be genre_id. The primary key in the director table will be director_id. The primary key for the actor table will be actor_id. All the primary and foreign keys data types will be int because they are numbers. We also have foreign keys, which are the. The foreign keys for the movie table are director_id, genre_id, and actor_id. The foreign keys for the genre, director, and actor table is movie_id. The movie table will have the title of the movie and the rating so that it can be broke down into multiple movies with their ratings. The genre table will only tell the genre of each movie and is only connected. . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . .. .. . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [Show More]

Last updated: 1 year ago

Preview 1 out of 2 pages