The Database Models, Languages and Architecture

User Generated

Xbbygbal843

Writing

Advanced Database Systems

ctu online

Description

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

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Kindly look at the files below. The files contain complete work of your assignment. Let me know if you need any clarification.

Running Head: THE DATABASE MODELS, LANGUAGES, AND ARCHITECTURE

The Database Models, Languages, and Architecture
Name
Institutional Affiliation
Date

1

THE DATABASE MODELS, LANGUAGES, AND ARCHITECTURE

2

The Database Models, Languages, and Architecture

It is always a best practice to have a unified database for consistency. It is easy to perform
operations on a single database than database scattered in an area. It is also easier to secure a
single database than multiple databases. It is also easy to monitor the database and have control
over it.
3-Level ANSI-SPARC Architecture
The 3 levels of ANSI-SPARC architecture were mainly developed to create independence to
various levels of the system and separation of user view. The architecture consists of three levels
which are external, conceptual and internal levels.
The external level of the database consists of user views which can be modified to suit different
users. The level allows the exclusion of data which is not useful to a given user and the user is
not allowed to access it. This level provides the independence of user views customizations.
Various users can have different customized views accessing the same data without affecting
each other. It also helps in hiding the physical details of the database since users do have to deal
with the physical storage.
The conceptual level defines the type of data been stored in the database as a whole and its
relationship. However, this level does not show the way data stored physically. Since this is only
one conceptual schema in every database, data integrity is effected at this level (Šikšnys &
Pedersen, 2016).
The lowest level of the architecture is the internal level and it contains the actual data records,
indexes, data fields, and their representation. Each database has only one internal schema.

THE DATABASE MODELS, LANGUAGES, AND ARCHITECTURE

3

The separation of these levels is important since it allows database administrators to change
database structure without affecting views accessed by users. In addition, the internal structure is
not affected by changes committed to the physical storages aspects.
The file below represent the three levels of ANSI-SPARC architecture.

Figure 1: Author's diagram for ANSI-SPARC architecture

THE DATABASE MODELS, LANGUAGES, AND ARCHITECTURE

4

Data Independence
Data independence is part of data transparency and it has to be considered in DBMS since the
user applications store data there. Data independence refers to how well user application will
work after changes have been committed in the organizati...


Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags