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...

1 answer below »

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.

Answered 1 days AfterJan 14, 2021

Answer To: The current database that your company is using keeps track of all of the customers and suppliers as...

Deepti answered on Jan 16 2021
124 Votes
3 Level ANSI SPARC Architecture
This architecture describes the structure of a particular database
system. It separates the physical database from the user applications. The database is broken down into three levels as external, conceptual and internal schema. Request and response between these levels is transformed trough mapping. In mapping external and conceptual levels, request and response is transformed to conceptual level and in conceptual land internal mapping, the request is transformed to internal level. The levels can be better understood as
· External Schema-This is the view schema of the database. It contains several schemas called subschema. Each subschema describes a portion of database in which a particular group of users is interested and the remaining database is hidden from them. End user interacts with the database at this level.
· Conceptual Schema- This schema describes the database design at conceptual or logical level. It describes the...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here