Support the need for the use of relational databases and data warehousing . From a management standpoint , it may be important to show the efficiencies that can be gained for executive oversight .
Create a database schema that supports the company ’ s business and processes . Explain and support the database schema with relevant arguments that support the rationale for the structure . Note : The minimum requirement for the schema should entail the tables , fields , relationships , views , and indexes .
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 through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia . Note : The graphically depicted solution is not included in the required page length but must be included in the design document appendix . Explain your rationale behind the design of the E-R Diagram .
Identify and create a Data Flow Diagram ( DFD ) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia . Note : The graphically depicted solution is not included in the required page length but must be included in the design document appendix . Explain the rationale behind the design of your DFD .
Illustrate the flow of data including both inputs and outputs for the use of a data warehouse . The diagram should map data between source systems , operational systems , data warehouses and specified data marts . Note : The graphically depicted solution is not included in the required page length .
Your assignment must follow these formatting requirements :
Be typed , double spaced , using Times New Roman font ( size 12 ), with one-inch margins on all sides ; citations and references must follow APA or school-specific format . Check with your professor for any additional instructions .
Include a cover page containing the title of the assignment , the student ’ s name , the professor ’ s name , the course title , and the date . The cover page and the reference page are not included in the required assignment page length .