25 Jun DESCRIBE HOW AND WHY THE COMPANY CAN BENEFIT FROM SPENDING TIME PLANNING AT THE BEGINNING OF THE PROJECT
The current database that your company is using keeps track of all of the customers and suppliers as well as products offered for sale, but the current environment has all of this data spread out across multiple different databases and it is difficult to see a complete picture of the environment. You have been tasked to consolidate the environment into a single database environment with the end goal of adding a data warehouse for the company. Your manager is excited with the project description, is anxious to have a new database built for the company, and more excited that at the end of the project he will also have a data warehouse to help make strategic decisions. To start, your manager would like to understand the benefits of following a formal design methodology, especially with respect to database design. Describe how and why the company can benefit from spending time planning at the beginning of the project, instead of just jumping in and developing the applications to meet the perceived needs. To ensure that you give the best response, you choose to describe the 3-level ANSI-SPARC architecture and want to make sure you discuss how the use of this will promote data independence to save time in the long run. You also want to take this opportunity to answer any potential questions about personnel needs with this new database environment. Describe the roles of a data administrator (DA) and a database administrator (DBA); describe the job functions of each and how the tasks they each perform differ. Would you recommend that your company has one person to perform both tasks, or should it hire two people? Your paper should contain the following information: Describe the 3-level architecture.Describe data independence.Talk about the differences between a DA and a DBA.Discuss the pros and cons of having a separate DA and DBA or the need for 1 person doing it all. You also should take this opportunity to create the template for your entire project, and create a Word document that you will add to for each remaining assignment. The document should follow this format: Advanced Database Systems Project document shellUse MS WordTitle PageCourse number and nameProject nameStudent nameDateTable of ContentsUse autogenerated TOCSeparate pageMaximum of 3 levels deepUpdate fields of TOC so it is up-to-date before submitting projectSection headings (create each heading on a new page with TBD as the content, except for the sections listed under ”New content” in each week’s assignment)Project OutlineThe Database Models, Languages, and ArchitectureDatabase System Development Life CycleDatabase Management SystemsAdvanced SQLWeb and Data Warehousing and Mining in the Business World Each week, you will add to this document and submit it for grading. As a preview, each section will contain the following: The Database Models, Languages, and Architecture (Week 1: IP)A description of the 3-level ANSI architecture modelA description of data independenceThe difference in responsibility between:Data administratorDatabase administratorDatabase System Development Life Cycle (Week 2: IP)A completed enhanced entity-relationship diagramA description about the relationship setup and multiplicityDatabase Management Systems (Week 3: IP)The normalization of a given logical data model to Boyce-Codd Normal FormA logical data model for the Enhanced ERD from IP2Advanced SQL (Week 4: IP)A physical data model for your Enhanced ERD in a DBMS of your choice, including:The DDL to create the tablesThe DDL to create the primary and foreign keysDML to manage data for the tables3 SELECT statements (one will be a JOIN)Web and Data Warehousing and Mining in the Business World (Week 5: IP)The design and DDL to create a star schema for a data warehouse for the database previously designedA description of the ETL process Add the discussion about the 3-layer ANSI architecture, data independence, and the different administrators to the section titled ”The Database Models, Languages, and Architecture.”
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.