DATA WAREHOUSING TERM PROJECT Your term project report must contain two major components: 1. (40 points) A project report describing mainly the database design including: Full description of the ob

Are you pressed for time and haven’t started working on your assignment yet? Would you like to buy an assignment? Use our custom writing services for better grades. Even if your deadline is approaching fast, our writers can handle your task right when you need it.


Order a Similar Paper Order a Different Paper

DATA WAREHOUSING TERM PROJECT

Your term project report must contain two major components:

1. (40 points) A project report describing mainly the database design including:

    1. Full description of the objectives of your database system including the scope of the database;
    2. User requirements that the system will be able to address;
    3. Business rules;
    4. Entity-Relationship Diagram (ERD) of the system. The ERD should be in Crow’s Foot Model. It must include all the appropriate entities, keys, connectivity, and relationship participation, cardinalities are optional; and
    5. The data dictionary of the system.

2. (60 points) A database system in your preferred DBMS system. The system should provide the following functions:

  1. Data Entry and Update (20 points): SQL Create Table statements that can create the tables in a relational database. Take screenshots of the statements and their results. Insert the screenshots into your final report.
  2. Data Retrieval and Simple Reports (40 points): 5 sample queries in plain English and their SQL SELECT statements. Enable users to submit 5 queries to retrieve information and the system can produce 5 reports for managers or other users to understand the business operations. Take screenshots of the statements and their results. Insert the screenshots into your final report.

Submission

A drop box will be created for the project proposal and final report on Canvas. Please submit them by the deadlines as specified in the syllabus. The design phase report and the final report should be in a word document.

Writerbay.net

Most students find it hard to finish papers at some point in their studies. If it ever happens to you, don’t get desperate—we have a service for every writing emergency! Whether you’re stuck with a problem, equation, or a piece of creative writing, we will definitely come to your rescue. Fill in the order form with the details of your paper. Write your personal instructions so we can meet your expectations.


Order a Similar Paper Order a Different Paper