Preview

Describing & Storing Data from Dbms

Good Essays
Open Document
Open Document
1240 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Describing & Storing Data from Dbms
Assignment

of

DBMS

Topic: Describing & Storing Data In DBMS

(Traditional Models)

Introduction

A computer database relies upon software to organize the storage of data. This software is known as a database management system (DBMS). Database management systems are categorized according to the database model that they support. The model tends to determine the query languages that are available to access the database. A great deal of the internal engineering of a DBMS, however, is independent of the data model, and is concerned with managing factors such as performance, concurrency, integrity, and recovery from hardware failures. In these areas there are large differences between products.
A Relational Database Management System (RDBMS) implements the features of the relational model outlined above. In this context, Date's "Information Principle" states: "the entire information content of the database is represented in one and only one way. Namely as explicit values in column positions (attributes) and rows in relations (tuples). Therefore, there are no explicit pointers between related tables."

Definition of Describing & Storing Data in DBMS

The user of a DBMS is ultimately concerned with some real-world enterprise, and the data to be stored describes various aspects of this enterprise. For example, there are students, faculty, and courses in a university, and the data in the university database describes these entities and their relationships.

There are three types of describing & storing data in DBMS:

Data Models

Level of Abstraction

Data Independency

Data Models

A database model or database schema is the structure or format of a database, described in a formal language supported by the database management system. Schemas are generally stored in a data dictionary. Although a schema is defined in text database language,

You May Also Find These Documents Helpful

  • Good Essays

    Week 1 SOW 1

    • 452 Words
    • 2 Pages

    Building the Physical Database: The data model will be translated into the Relational Database Management system of choice. All Tables and Columns with specific data types will be created and will include Relational and other constraints.…

    • 452 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Nt1320 Unit 7

    • 2041 Words
    • 9 Pages

    Answer: A database is a model of how the users view their business world. This means that the users are the final judges as to what data the database should contain and how the records in that database should be related to one another. The easiest time to change the database structure is during the data modeling stage. So the user should be actively involved in the modeling process. The user review of a data model is crucial. When a database is developed, the user must carefully review the data model.…

    • 2041 Words
    • 9 Pages
    Good Essays
  • Good Essays

    Bio Lab

    • 629 Words
    • 3 Pages

    The substances that I found to be bases are window cleaner, hand soap, baking soda, baking powder, bleach, Lysol, and antacid. These substances were found to be bases because after testing them by dipping pH paper into a well filled with about three drops of the substance, the color of the paper turned to a color correlating with the color of an eight or higher on the pH scale.…

    • 629 Words
    • 3 Pages
    Good Essays
  • Best Essays

    Rob, P., & Coronel, C. (2002). Database systems: design, implementation, and management (5th ed.). Boston, MA: Course Technology.…

    • 1383 Words
    • 5 Pages
    Best Essays
  • Powerful Essays

    References: Rob, Peter and Coronel, Carlos. (2005). Database Systems: Design, Implementation, and Management. United States: Thomson Course Technology.…

    • 2376 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Dbm 381 Week 1paper

    • 885 Words
    • 4 Pages

    A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships between the entities (Pratt & Adamski, 2012, Chapter 1). How data is received, stored, processed, and made available to others has an effect on the success or failure of an organization. The use of different architecture is a most to fit the needs of the organization, however the value of the data still remains in been able to access and extract information from the database system, and the only way this can be reached is by organizing, storing, and analyzing it effectively. For many organizations these systems have become an essential part of their structural and operational success.…

    • 885 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Athabasca Assignment

    • 837 Words
    • 4 Pages

    Relational databases are not new technology. Commercially, they gained importance in the early 1980s with the introduction of Oracle’s relational database, and since then they have been an essential tool for most businesses. Databases are critical tools that help to support various business functions in an organization. These information systems help a business to build and maintain competitive advantage. Databases not only support the operational levels of business—they are also used to support the activities of managers.…

    • 837 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    “The database architecture is the set of specifications, rule, and processes that dictate how data is stored in a database and how data is accessed by components of the system (wingenious.com).” Database architecture type S can be fragmented into three general categories, each of which has numerous subcategories: One Tier, Two Tier which is at the client/server level, and the N Tier which is at the client/server level as well.…

    • 624 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    References: Pratt, P.J, & Adamski J.J, (2011). Concepts of Database Management. Ohio, OH: CENGAGE Learning.…

    • 688 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Dbm380 Course Syllabus

    • 2296 Words
    • 10 Pages

    Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • • University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum.…

    • 2296 Words
    • 10 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Week 3

    • 754 Words
    • 4 Pages

    6. The type of logical database model that treats data as if they were stored in two-dimensional tables is the (Points : 1)…

    • 754 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    Database Environment

    • 1121 Words
    • 5 Pages

    A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. The query can be in the form of a question or just a keyword and once these queries run against the database, it will find a matching record (Reynolds, 2004) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
  • Better Essays

    In this paper I am going to discuss about the database and software used in my construction company. Oracle database is a multi platform database, meaning it can run efficiently on any operating system and this makes Oracle flexible and more secure when compared to its competitors. Our Oracle database is running on a Sun server, using the Sun Solaris enterprise operating system. Oracle databases are an enterprise database system, only medium and large companies would need an enterprise database. Oracle Corporation uses RDBMS rational database management systems to maintain all data within the organization. Various data items can be organized according to their relationships with each other, such as the relationship of Employee name and Employee ID, rational databases give Oracle a great deal of flexibility when describing the relationship between data elements. Oracle follows Dr.Cobbs 12 rules on how a true RDBMS should be evaluated. The following are Cobb's 12 rules.…

    • 807 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    A database is a digital storage area that helps people keep track of things. A database can also be considered a digital list because in the real world work environment keeping track of lists is very valuable to an organization but in other cases a simple list is not agile and versatile enough to avoid data inconsistencies and other problems that may arise. Databases are valuable because they are not only objects that remain in list form; but also a tool that can be split into table data that may then help to solve organizational problems that lead to more efficient business operation. The best way to organize valuable information within an organization is rational database tables because they are designed to solve all of the problems and limitations that comes with simple lists.…

    • 414 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Companies that use database management systems use the database approach to as opposed to the traditional approach, where customer data is maintained in separate files with each file relating to the process that is specific to the organization such as billing, shipping. The database approach is very advantageous to the organization because each application uses a collection of data that is related in the database.…

    • 592 Words
    • 3 Pages
    Good Essays