26 Jan Create a relational database model
9327Instructions
Each Student will select a situation or a problem from their company as a course project that can be solved using a database system. Using MS Access, or MS SQL Server Express. Each student will create a relational database model of the system.
The project should be divided into manageable steps (read more about each step in the next paragraph).
This is an individual project.
Deliverables of project steps should be zipped and submitted together through the “Course Project” link. Do not e-mail the instructor with any of your deliverables.
Due date for deliverables of all project steps is 11:00 pm pst of the last Saturday of the class.
Project Steps:
Step 1 – Project Proposal
Step 2 – Entities and Relational Model
Step 3 – Design and implementation
Step 1:
The project proposal should include a general background of the business, a description of the problem associated with the database project, and a description of any industry or company- specific terminology used within the project. The users and clients of the database system should be identified. The overall purpose and benefits of the resulting database system should be identified. The project stages and plan are considered part of the proposal.
The deliverable from Step 1 is a 2-page document describing the project plus samples of any source documents. A one-page catalog of the source documents may be appropriate as well.
Step 2:
At this time, the scope of the project should be analyzed, and the E-R diagram should fit on a single piece of paper. If the E-R diagram cannot be confined to a single piece of paper, the scope of the project needs to be narrowed and the goals of Step 1 need to be re-assessed. A minimum of 5 entities need to be included in the system. The student should normalize the data into 3NF, and then, using SQL, create the tables, define the relationships between the tables and populate the fields by entering in sample data.
The deliverable from Step 2 is a one-page E-R diagram and another page containing a snapshot of the normalized tables. You can use any drawing tools, such as the ones provided by MS Word or Excel to draw your diagrams.
Step 3:
You should provide an implementation of this data model into schema and show those schema tables loaded with sample data in the form of a database.
The deliverable from step 3 is the actual database you have created (the MS Access file if you used MS Access for the implementation of your model). The database should show sample of the SQL statements used to create the various relations.
When managers analyze their environment or develop plans they encounter unknowns. When unknowns are encountered one has two choices:
1) Make a good guess by estimating reasonable values of the unknowns
2) Find out
Real world managers do occasionally have to guess. Guessing is not all bad — it represents the operation of sophisticated heuristic algorithms on an enormously complicated neural network architecture computer (your Brain!). But, unless this neural network is TRAINED (we call this experience), the guess may not be a good one. If your experience is not comprehensive enough, the other approach, finding out, may be needed. In this class, you are strongly encouraged to employ the second approach and find out!
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.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. 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.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.