Database Design Language and Entity Relationship Diagram

Read through the whole project before beginning. Based on the information provided below, you will be creating Database Design Language and Entity Relationship Diagram.

1. Database Design Language (DBDL)
   Use Word to create the DBDL. When creating the DBDL, list out all relations in 3NF. On each relation, create functional dependencies to make sure all relations are in 3NF!!
2. Entity Relationship Diagram (ERD)
   An ERD is the visually representation of the database structure. Draw the diagram for the scenario using LucidChart. When drawing the objects, be sure to use the correct shapes and syntax.

   Example: Entities are a rectangle box, the Entity name is a singular noun, primary keys are underline, etc. Each relationship must be show to be either 1:1 or 1:M. There will be no M:M relationships by creating all relations in 3NF.

List out all alternate keys, secondary keys, and foreign keys under the relation using the correct syntax.

Do not forget to put your name on the documents. Submit the files via Canvas. Be sure to submit as a PDF or Word Document. If you use Visio, you must export the file as a PDF. Do not submit .VSD files.

An online movie database keeps tracks of information on movies, actors, directors, the genre of movies, and the characters portrayed by each actor in the movie. The specific data requirements for the database is summarized as follows:

1. Each movie is identified by a unique number. Other information kept on each movie is the name of the movie, length of the movie, release date and parental rating.
2. An actor is identified by a unique number, first name, last name, date of birth and gender.
3. A director is identified by a unique number, first name, last name, date of birth and gender.
4. A character is identified by a unique number, first name, and last name.
5. A genre is identified by a unique number and the description of the genre.
6. A Movie has multiple actors (or none at all).
7. An Actor can play multiple roles in a movie.
8. A character must be associated with a movie and an actor.
9. A character can be in multiple movies. (i.e. Sequels)
10. A character can be portrayed by multiple actors in a movie. (i.e. Character in a movie has a younger and older version – two actors need to play the part).
11. A Movie can have multiple directors (or none at all).
12. A movie must have at least one genre (or could have many).