Question GENERAL OUTLINE OF THE PROJECT

GENERAL OUTLINE OF THE PROJECT

So far in the semester we’ve focused on rather abstract aspects of databases such as data modeling, functional dependencies, and normalization. This project allows us to shift gears and explore more managerial aspects of databases. One of the best ways to learn something is to try to put this new knowledge into practice. Building database tables, queries, forms, and reports is relatively easy. However, developing and maintaining standards, ensuring that the database is properly documented and keeping to a firm deadline is pretty difficult (as you will discover).

YOUR TEAM

The team size is ideally three or four members. Teams of two are discouraged due to the amount of work to be done and the short time period allowed. I suggest that you divide the extensive work required equitably among the team members while at the same time relying on the special strengths of each team member to allow the project to be completed within the strict time limits. Please note that this project requires extensive use of computers and that the computer lab becomes increasingly crowded as the semester progresses.

DELIVERABLES

The deliverables have been broken up into a project proposal and three main sections:

Project Proposal (Due February 18)

1. Conceptual Design (Due March 11)
2. Physical Design (Due April 8)
3. Final Project (Due May 1)

   Each team should submit one copy of deliverable through the Assignment link on Blackboard. Handwritten material will not be accepted. Remember, professionalism and appearance rarely cover mistakes; however, they do make mistakes seem more tolerable. In addition, a peer evaluation sheet will be completed by each person at the time each deliverable is due. This evaluation will cover your team members’ contribution on the previous phase of the project and have a DIRECT bearing on your individual scores for the final project. I will use all three evaluations from your three milestones to determine your overall contribution to the project.

GRADES

The grade distribution for the project will be approximately:

Deliverable 1 – Conceptual Design 25%

Deliverable 2 – Physical Design 25%

Deliverable 3 – Final Project & Presentation 50%

GENERAL GUIDELINES FOR DATABASE CURRICULUM INTEGRATION

While it may be possible or even desirable in some cases to propose and design a system with more limited database requirements, it is important in this case to be sure that your proposed system effectively applies and hones the knowledge you gain through your participation in this course. Therefore, all projects should comply with the following guidelines. Exceptions will be considered on a case-by-case basis, but any deviation from the standard will require significant effort redirected and applied within the project to another key learning objective of the course.

• The data model should contain at least 10 tables, and should be normalized to 3NF. Any deviation from 3NF must be justified to and approved by the instructor.
• Physical table definitions should include a range of data types, including but not limited to: integer, decimal, string (varchar), and date
• Databases will be implemented on the MS SQL Server 2012 or Teradata platform.
• The user interface should contain at least:
  • 2-3 screens for “data management” (inserting/maintaining/reviewing records)
  • 2-3 screens for reports & decision support
• Databases should be loaded with at least 1000 records (data loading/conversion – manual entry is highly discouraged).
• Queries should include basic insert, update, select, and (optionally) delete co

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.