I need help with a MySQL question. All explanations and answers will be used to help me learn.
Read through the whole project before beginning. Based on the information provided below, you will be creating Database Design Language and Entity Relationship Diagram.
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!!
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.