Preview

Brief Introduction to Database Concepts

Powerful Essays
Open Document
Open Document
4703 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Brief Introduction to Database Concepts
Brief Introduction to Database Concepts
Andrea Rodr´ ıguez Summer School - Castell´n 2004 o

Department of Computer Science University of Concepci´n, Chile o http://www.inf.udec.cl/∼andrea andrea@udec.cl

1

Introduction

Information and data are different. Information is understood by a person. Data are values stored on a passive medium like a computer disk. The purpose of a database management system (DBMS) is to bridge the gap between information and data - the data stored in memory or on disk must be converted to usable information. The basic processes that are supported by a DBMS are: • Specification of data types, structures and constraints to be considered in an application. • Storing the data itself into persistent storage. • Manipulation of the database. • Querying the database to retrieve desired data • Updating the content of the database A database is a model of a real world system. The contents (sometimes called the extension) of a database represent the state of what is being modeled. Changes in the database represent events occurring in the environment that change the state of what is being modeled. It is appropriate to structure a database to mirror what it is intended to model. Databases can be analyzed at different levels: • Conceptual Modeling • Logical Modeling • Physical Modeling

2

Conceptual Modeling

Conceptual-level concepts permit us to model the application world in terms that are independent of any particular data (logical) model. Conceptual models provide a framework for developing a

1

database schema from the top to the bottom in the process of a database design. This Section examines the entity-relationship model and the object-oriented model as representatives of conceptual modeling. The entity-relationship model is widely used and the object-oriented model is gaining more acceptance for non-traditional databases.

2.1

The Entity-Relationship Model

The entity-relationship model is a tool for analyzing the semantic features of an


References: [1] A. Cumming. A Gentle Introduction to SQL: An interactive tutorial. School of Computing of Napier University, Edinburg, UK, URL: http://sqlzoo.net/, 2003. [2] S. Kalajdziski. UML Tutorial. URL: http://odl-skopje.etf.ukim.edu.mk/uml-help/, 2004 (access). [3] ODL. EyeDB: The Object Definition Language. Sysra Informatique, http://www.infobiogen.fr/services/eyedb/pub/manual/node5.html, 1999. URL: [4] ODMG. Object Database Management Group: The Standard for Storing Objects. ODMG, URL: http://www.odmg.org/, 2000. [5] OQL. OQL - Object Query Language. UCSD: Department of Computer Science and Engineering, URL: http://www.cs.ucsd.edu/classes/wi00/cse132a/oql.htm, 2000. [6] Information Technilogy Services. Introduction to Data Modeling. University of Texas at Austin, URL: http://www.utexas.edu/its/windows/database/datamodeling/dm/erintro.html, 2004 (access). 16
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    Week 1 SOW 1
    • 452 Words
    • 2 Pages

    Week 1 SOW 1

    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
    Read More
  • Good Essays

    CMGT 400 Week 1 DQs
    • 676 Words
    • 3 Pages

    CMGT 400 Week 1 DQs

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Service Request Dba/380 Huffman Trucking
    • 553 Words
    • 3 Pages

    Service Request Dba/380 Huffman Trucking

    The Entity Relationship Diagram, also known as (ERD) demonstrates the relationship between data in the new database. ERD shows the logical path that the data follows. The data model gives one understanding and the visual representation to observe the different phases of the database and determine the path the information is pulled or stored from. Learning Team D demonstrate linking the different tables in the Fleet Truck Maintenance database. The creation of the logical path predicts the flow of the data entered and the tables relationship to other tables in the database.…

    • 553 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Best Essays

    Week 8 Case Study: Database Development
    • 1383 Words
    • 5 Pages

    Week 8 Case Study: Database Development

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

    • 1383 Words
    • 5 Pages
    Best Essays
    Read More
  • Good Essays

    Database Environment Week 2
    • 799 Words
    • 3 Pages

    Database Environment Week 2

    References: Coronel, C. (2013). Database Systems: Design, Implementation, and Management, Tenth Edition. Mason, Ohio, United States: Cengage Learning.…

    • 799 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    DBM 380 Syllabus
    • 623 Words
    • 4 Pages

    DBM 380 Syllabus

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

    • 623 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Motifs In Romeo And Juliet
    • 983 Words
    • 4 Pages

    Motifs In Romeo And Juliet

    Throughout the novel, The Tragedy of Romeo and Juliet, several motifs are used as a way to bring a deeper meaning to quotes that may see you uninteresting from the surface. One very prominent motif in this novel is dreams and premonitions. These motifs are used throughout the novel as ways to introduce foreshadowing and insight into what characters may expect to happen. Most of the occurrences where dreams and premonitions appear are when characters are looking forward to an event or occurrence. In turn, this creates a lot of foreshadowing towards dramatic events that happen all throughout the novel. Several characters experience premonitions before certain events or occurrences that may foreshadow upcoming events. The major purpose…

    • 983 Words
    • 4 Pages
    Good Essays
    Read More
  • Powerful Essays

    Database Design & Development
    • 2935 Words
    • 12 Pages

    Database Design & Development

    I have prepared this assignment to demonstrate an understanding of applying data modeling and analysis techniques to the design and development of database solutions. I am as a sub-contracted to design the database system supporting the Veterinary Doctor for the Petcare. Entity relationship Model: a data model originally had three primary constructs: entity, relationship and attributes.…

    • 2935 Words
    • 12 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Object-Oriented Database Management Systems
    • 3425 Words
    • 14 Pages

    Object-Oriented Database Management Systems

    The construction of Object-Oriented Database Management Systems started in the middle 80 's, at a prototype building level, and at the beginning of the 90 's the first commercial systems appeared. The interest for the development of such systems stems from the need to cover the modeling deficiencies of their predecessors, that is the relational database management systems. They were intended to be used by applications that have to handle big and complex data such as Computer Aided Engineering, Computer Aided Design, and Office Information Systems. <br><br>The area of the OODBMSs is characterized by three things. First, it lacks a common data model. There is no common data model although many proposals can be found in the literature. This is a more general problem of all the object-oriented systems not only the database management systems. Since the data model determines the database language of the system, which in turn determines the implementation of the system, we can understand that the differences between the various systems with different data models can be big and substantial. Second is the common theoretical framework. Although there is no standard object-oriented model, most object-oriented database systems that are operational or under development today share a set of fundamental object-oriented concepts. Therefore the implementation issues in OODBMSs that arise due to these concepts are universal. The third characteristic is that of experimental activity. Plenty of prototypes have been implemented and some of them became commercial products. There is really a need for applications to handle very complex data and that is why the interest of people in building such systems is so strong.<br><br>Although there is no consensus on what an OODBMS is and which are the features that differentiate it from other systems, there has been a lot of effort for an agreement on defining the formal characteristics that can stand as the set of specification requirements for…

    • 3425 Words
    • 14 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Hotel Assignment
    • 732 Words
    • 3 Pages

    Hotel Assignment

    For this assignment, draw a detailed ER diagram using UML notation. Write all attributes in the ERD using the format -> attribute: type. Make reasonable assumptions about data types. For the Registration table, explain all constraints that are necessary on the table.…

    • 732 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    System Analysis and Design
    • 13666 Words
    • 55 Pages

    System Analysis and Design

    Relate data modeling to process and logic modeling as different ways of describing an information system.…

    • 13666 Words
    • 55 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Logical and Physical Data Models
    • 4439 Words
    • 18 Pages

    Logical and Physical Data Models

    A physical data model (or database design) is a representation of a data design which takes into account the facilities and constraints of a given database management system. In the lifecycle of a project it typically derives from a logical data model, though it may be reverse-engineered from a given database implementation. A complete physical data model will include all the database artifacts required to create relationships between tables or to achieve performance goals, such as indexes, constraint definitions, linking tables, partitioned tables or clusters. Analysts can usually use a physical data model to calculate storage estimates; it may include specific storage allocation details for a given database system.…

    • 4439 Words
    • 18 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Bookshop Automation
    • 4844 Words
    • 20 Pages

    Bookshop Automation

    Start your journey the easy way n.d : Retrieved 4th February 2007 from http://www.liverpooljohnlennonairport.com/TravelServices/CarParking.php Ramakrishnan, R. and Gehrke, J. 2003. The Relational Model In Database Management Systems, 3rd Edition…

    • 4844 Words
    • 20 Pages
    Powerful Essays
    Read More
  • Good Essays

    dthfhf
    • 939 Words
    • 4 Pages

    dthfhf

    When database capabilities are combined with object-oriented programming language capabilities, the result is an object-oriented database management system (OODBMS). OODBMS allow object-oriented programmers to develop the product, store them as objects, and replicate or modify existing objects to make new objects within the OODBMS. Because the database is integrated with the programming language, the programmer can maintain consistency within one environment, in that both the OODBMS and the programming language will use the same model of representation. Relational DBMS projects, by way of contrast, maintain a clearer division between the database model and the application.…

    • 939 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    Database Management Systems
    • 702 Words
    • 3 Pages

    Database Management Systems

    * Define relational database architecture. Consider Microsoft® Access®, Microsoft SQL Server®, Oracle®, IBM DB2®, and so on. Format your paper consistent with APA guidelines, and use at least three unique references beyond University of Phoenix course materials. The rubric I will use to grade your paper is posted in Course Materials. A reminder that grammar, punctuation and spelling errors do not present a professional presence and will impact your grades.…

    • 702 Words
    • 3 Pages
    Good Essays
    Read More

Related Topics