relational database, Data Flow Diagram, ER Diagram
Budget: $30 – $250 USD
Topic: Data Warehousing System
Question 1
• Design the need for the use of relational databases, and identify and create a Data Flow Diagram (DFD) relating the tables of the database schema
• Create a database that supports the selected topics. Explain and support the database schema with relevant arguments that support the rationale for the structure
• Identify and create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be achieved. Normalize the database tables to third normal form (3NF)
• Identify and create an Entity-Relationship (E-R) Diagram relating the tables of the database schema. Explain the rationale behind the design of your E-R Diagram
Question 1
• Design the need for the use of relational databases, and identify and create a Data Flow Diagram (DFD) relating the tables of the database schema
• Create a database that supports the selected topics. Explain and support the database schema with relevant arguments that support the rationale for the structure
• Identify and create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be achieved. Normalize the database tables to third normal form (3NF)
• Identify and create an Entity-Relationship (E-R) Diagram relating the tables of the database schema. Explain the rationale behind the design of your E-R Diagram