Phone: + 1 507 4052 660
Email: support@collegecustomtutors

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

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

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 shell
  • Use MS Word
  • Title Page  
    • Course number and name
    • Project name
    • Student name
    • Date 
  • Table of Contents  
    • Use autogenerated TOC
    • Separate page
    • Maximum of 3 levels deep
    • Update fields of TOC so it is up-to-date before submitting project 
  • Section  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 Outline
    • The Database Models, Languages, and Architecture
    • Database System Development Life Cycle
    • Database Management Systems
    • Advanced SQL
    • Web 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 model
    • A description of data independence
    • The difference in responsibility between:  
      • Data administrator
      • Database administrator 
  • Database System Development Life Cycle (Week 2: IP)  
    • A completed enhanced entity-relationship diagram
    • A description about the relationship setup and multiplicity 
  • Database Management Systems (Week 3: IP)  
    • The normalization of a given logical data model to Boyce-Codd Normal Form
    • A logical data model for the Enhanced ERD from IP2 
  • Advanced SQL (Week 4: IP)  
    • A physical data model for your Enhanced ERD in a DBMS of your choice, including:  
      • The DDL to create the tables
      • The DDL to create the primary and foreign keys
      • DML to manage data for the tables
      • 3 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 designed
    • A 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.”

Name the document CS352_<First and Last Name>_IP1.doc.

Unlock Better Papers
Pages (550 words)
Approximate price: -

Why choose us?

Because we are the best Our main aim is to maximize the quality of your customer experience. We understand the intensity of the importance of your academics that is why we intend to deliver the best grades as a reward for trusting us with your valuable work. Here are reasons why you made the best decision by choosing us:

Masters of our art.

Our writers are experienced and high educated. Our team of writers is associated with the most prestigious universities. They will craft your essays according to any guidelines or requirements you want us to follow for your paper.

You are our VIP

We treat every customer as the most important part of our company, your satisfaction is what drives us.

Best pricing

The best quality for affordable prices! Contact us today to get a discount on your first purchase. We’ve got the best prices in this industry.


Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:

How it works?

Place your order

You can order an essay with us by filling out our quick and easy order form.

Proceed with the payment

After receiving payment confirmation via PayPal or credit card – we begin working on your detailed outline, which is based on the requirements given by yourself upon ordering. All work goes through three levels of quality assurance before being sent back to you for review.

Receive the final file

Once approved, your order is complete and will be emailed directly to the email address provided before payment was made!


How does our services benefit you?

So much stress and so little time? Take care of yourself: let us help you with your tasks. We offer all kinds of writing services.

We guarantee: no plagiarism, high quality and on time delivery.

We value your grades and we will do everything to help you achieve the highest scores possible! With us you can be sure that your work is in good hands. Our writers are professionals who know what they’re doing so there’s nothing for you to

We have a money back guarantee,

So you can be sure that if something goes wrong we will fix it for you. If your paper fails to meet our requirements by any chance just ask for a refund and get all your money back! We are serious about being number one essay writing company online, and we will prove it to you!

We offer a full privacy guarantee

Your personal information is completely safe with us. Your details are never shared or distributed to third parties. You can be sure that no one has access to your private data because all of the files and documents about you are stored in our secured system.

We will deliver your paper on time

Do not worry about the deadline. We know how important it is for you to hand in your work before the due date and that is why we always prioritize our writers’ schedules around yours. Our writers are experienced professionals who can write any type of essay within a given timeframe!

We care about the quality of our work

Our goal is not just to keep customers happy but also help them succeed in their academic goals. That’s why we provide only 100% original, custom written content that is always delivered on time.

We have a live support service!

contact us now and get the best customer service experience possible, just talk to our friendly staff members via chat or phone at any given time of your day as we are always available for you around the clock without taking breaks! Take advantage of this opportunity right now and do not hesitate to contact us for more information about how we work.