05 Jul Relational Database Management – Database System Plan Assignment
Question Description
This only has to be in the end 4 to 5 pages long not including any cover or reference page.
Task 1- You have been asked to develop a database system plan for a local company (or a company of your choosing) that wants to track its customers/clients, appointments, billing, and employees. The company requires that you complete the following: I will need this Task 1 in 1 day and then the other task i can have in 5 days
1. Justify the need for the proposed system.
2. Produce a formalized database design plan.
3. Switch over to the new database system within 6 months.
4. Produce a plan for administering and maintaining the database system.
5. Create the Word document template called “Database System Plan” that includes the following:
o Title page
o Course number and name
o Project name
o Student name
o Date
o Table of contents (TOC)
Use an autogenerated TOC.
It can be 3-levels deep at most.
Be sure to update the fields of the TOC so that it is up-to-date before submitting your project.
o Section headings
Create each heading on a new page with “TBD” as content (except for the sections listed under new content below).
During this phase you are required to complete a SQL tutorial which will help prepare you for upcoming tasks. Click here to view the Intro to MySQL tutorial.
This is a mini video course for MySQL, please click take this course for free. You will then be prompted to enter your email and password.
Each week, you will add a section to this database system plan and submit it for grading. Each section will contain the following:
Part 1 (objectives from Task 1–4)
o System Requirements Specification (New Content for Task 1): Include a feasibility analysis that details what specific steps need to be performed at this phase of the project, clarifies the scope of the project, provides an estimate for cost and time to develop the database, and justifies the need for the proposed database.
Conceptual Data Model (Task 2): Identify the entities and highest-level relationships using an embedded diagram (Use Visio software application where applicable). Describe the problem and data requirements in the narrative, as well as your rationale for the conceptual model. Justify your design by discussing how the design will solve the problem presented in the case scenario. Add this section to the Conceptual Data Model section of your database system plan.
o Entity Relationship Diagram (Task 3): Use Visio software application to create an entity relationship (ER) diagram that includes the primary keys for all entities, the relationships between different entities, the attributes (and data types) for each entity, and junction tables to support any many-to-many relationships. Be sure that the design meets a minimum of third normal form (3NF).Describe the steps that you took to ensure that your design was normalized to the desired level and any exceptions you had to make to prevent anomalies and a loss in data integrity. Add section to the Entity Relationship (ER) Diagram section of your database system plan
o SQL Statements (Task 4): Create the data definition language (DDL) and data manipulation language (DML) SQL statements that will be used to create the database schema.
Create the stored procedures to support retrieval of the data from the database.
Part 2 (objectives from Task 5)
o Database Administration (Task 5): Using data control language (DCL), control access to the data by adding a group of users who have been granted the ability to perform specific tasks.
Write the SQL queries that will support the efficient execution of transactions in the database.
Create an execution plan for each query, and provide a performance analysis of the results of each plan. In your analysis, discuss which queries you would change (including how and why).
Create a backup recovery model, and provide a rationale for your model.
All sources should be cited both in-text and in the References section by using APA format. Name the document yourname_IT610_IP1.doc. Submit the document for grading.
Please label each section with the Task number so I know the difference when i submit it.
I dont care what business is used just pick one off the internet is fine.
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 Wridemy
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.