Summary 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, director, and Actor. In the movie entity, the attributes are
IT234 Unti2 A 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, director, 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_i
Document information
- Uploaded on
- February 18, 2021
- Number of pages
- 2
- Written in
- 2020/2021
- Type
- Summary
