Preview

Book

Powerful Essays
Open Document
Open Document
1742 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Book
Relational Database Concepts
IBM Information Management Cloud Computing Center of Competence IBM Canada Labs
1
© 2011 IBM Corporation

Agenda
• Overview • Information and Data Models • The relational model • Entity-Relationship diagrams • Types of relationships • Mapping entities to tables • Relational model concepts • Relational model constraints • Normalization

2

© 2011 IBM Corporation

Supporting reading material & videos
• Reading materials • Database Fundamentals eBook
• • • • Chapter 1: Databases and information models Chapter 2: The relational data model Chapter 3: The conceptual data model (optional) Chapter 4: Relational database design (optional)

• Videos • db2university.com course AA001EN
• Lesson 1: Relational database concepts

3

© 2011 IBM Corporation

Agenda
• Overview • Information and Data Models • The relational model • Entity-Relationship diagrams • Types of relationships • Mapping entities to tables • Relational model concepts • Relational model constraints • Normalization

4

© 2011 IBM Corporation

Data vs. Information

• Data:

Collection of letters, numbers or facts

• Information: Processed data that provides value

5

© 2011 IBM Corporation

Databases and DBMS
• Databases • A repository of data • DBMS (Database management system) • Software system that manages databases • The terms “Database”, “DBMS”, “data server”, “database server” often used interchangeably to refer to a DBMS • Why a DBMS? • Security • Can handle many users with good performance • Allows for concurrency while keeping data consistent • Protects from disaster
6
© 2011 IBM Corporation

Agenda
• Overview • Information and Data Models • The relational model • Entity-Relationship diagrams • Types of relationships • Mapping entities to tables • Relational model concepts • Relational model constraints • Normalization

7

© 2011 IBM Corporation

Information and Data Models
Relationship between an Information Model
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Ilab Instructions
    • 2258 Words
    • 10 Pages

    Ilab Instructions

    You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a database. You will create two conceptual models.…

    • 2258 Words
    • 10 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Bis245 Ilab
    • 2683 Words
    • 11 Pages

    Bis245 Ilab

    A. Lab # : BSBA BIS245A-1 B. Lab 1 of 7 : Introduction to MS Visio and MS Access C. Lab Overview--Scenario/Summary TCOs: 1. Given a business situation in which managers require information from a database, determine, analyze and classify that information so that reports can be designed to meet the requirements. 2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool. Scenario: You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a database. You will create two conceptual models. You will then open an existing Access database to explore database objects and to experiment with simple data manipulation using filters and sorts and to begin elementary work with relationships. Upon completing this lab, you will be able to 1. relying on detailed instructions, create a simple conceptual model for a two-table database using MS Visio; 2. use experience gained in creating the first model to construct a similar conceptual model without the instructions; and 3. download an existing Microsoft Access database file. Open the database; find and identify different database objects in this database.…

    • 2683 Words
    • 11 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Business Systems Analysis
    • 1170 Words
    • 5 Pages

    Business Systems Analysis

    The entity-relationship diagram is a tool for designing and analyzing databases, and in particular for applying a technique called entity-relationship (ER) modeling to the design process. It has proven to be very successful at rendering the relationships among the data fields, or variables, contained within a given database. Using the graphically very well arranged Entity Relationship Diagrams (ER Diagrams) you can easily create and maintain your database structures. In your models you will have all the entities, attributes, domains, primary keys, foreign keys, constraints, relationships, also notes and other physical and logical data, laid-out in a transparent order. While creating models you will have a perfect view of all database elements. You can simply set the values of all attributes, types of relationships and other criteria, as for example indexes, etc…

    • 1170 Words
    • 5 Pages
    Good Essays
    Read More
  • Powerful Essays

    Walk in Clinic
    • 2030 Words
    • 9 Pages

    Walk in Clinic

    These days walk in clinics and hospitals, are under strong pressures from several fronts these days. Many of these are because of a strong need for a more comprehensive range of health services, the increasing complexity of identifiable disease and treatment patterns and the fact that more people today than ever before are demanding high-quality medical care. This act was a great challenge to the modern clinics which are dependent for its day-to-day operation on an accurate, rapid and efficient information flow. The solution is to develop an integrated clinical database to help meet the information processing needs of the clinic in an optimal way.…

    • 2030 Words
    • 9 Pages
    Powerful 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

    Database
    • 2550 Words
    • 11 Pages

    Database

    § § § § § § § What are database applicaAons? Why conceptual modelling? What are the phases in the design of database applicaAons? What is enAty-­‐relaAonship (ER) modelling? What are enAty types and enAty sets, aRributes and value sets?…

    • 2550 Words
    • 11 Pages
    Powerful Essays
    Read More
  • Good Essays

    Enterprise View of Data
    • 979 Words
    • 4 Pages

    Enterprise View of Data

    Database design is a process to organize data into a form which matches the underlying data model of the database management system. There are three major types of database management systems: network, hierarchical, and relational. In the network database management systems, which include Honeywell's IDS and UNIVAC DMS-1100, data will be organized into different types of records and can be represented by a data-structure diagram1 (1). In the hierarchical database management systems, which include IBM's IMS, data will be organized into a form similar to but more restricted than the data-structure diagram. In the relational database management systems, (2) data will be organized into a set of tables (or "relations"). In general, to design a database is to decide how to organize data into specific forms (record types, tables) and how to access them. Up to now, there are very few tools available to aid the database design process. Usually, the database designer relies on his own intuition and experience. Thus, the resulting database may not satisfy company's objectives and may cause problems in company's operations.…

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

    MIS IT
    • 2947 Words
    • 9 Pages

    MIS IT

    A physical data model represents the actual structure of a database—tables and columns, or the messages sent between computer processes. Here the entity types usually represent tables, and the relationship type lines represent the foreign keys between tables. The data model’s structure will often be tuned to the particular needs of the processes that operate on the data to ensure adequate performance. It will typically include:…

    • 2947 Words
    • 9 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Chapter 7 8 9 10
    • 2568 Words
    • 8 Pages

    Chapter 7 8 9 10

    In logical data base design, the E-R diagram is converted to the sets of tables and relationships among the tables.…

    • 2568 Words
    • 8 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    The Enhance E-R Model
    • 3226 Words
    • 13 Pages

    The Enhance E-R Model

    The purpose of this chapter is to present some important extensions to the E-R model (described in Chapter 3) that are useful in capturing additional business meaning. In particular we describe two types of extensions to the E-R model. The enhanced entity-relationship (EER) model includes constructs for supertype/subtype relationships. The inclusion of new notation for business rules allows the designer to capture a broader range of constraints on the data model than were previously available.…

    • 3226 Words
    • 13 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    ACC 542 Week 3 Individual Assignment Data Table Analysis
    • 4521 Words
    • 87 Pages

    ACC 542 Week 3 Individual Assignment Data Table Analysis

    The Kudler Foods need to design an entity relationship diagram to illustrate what needs to be on the table. A few of the tables could be combined to make reading the tables much easier. Kudler foods could combine inventory/order relationship, for example; order/sale relationship table, inventory/sale relationship table, and sale/receive payment relationship table. By combining any one of these tables Kudler Foods could process orders faster, find information faster by having the data in order and labeled and overall making the company’s system more efficient. One table Kudler Foods does not have that the management should consider which would benefit the business is an “employee table”. This way; Kudler could have personal information, sales numbers, last date he/she was reviewed, and just able to keep up…

    • 4521 Words
    • 87 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Avr Reservation System
    • 1684 Words
    • 7 Pages

    Avr Reservation System

    We present the main entity types of this database. For each entity type, we provide some of the corresponding attributes. Use this information in order to: (a) Build an Enhanced E-R diagram; (b) Transform the Enhanced E-R diagram to a relational database. Identify the primary key(s) and the foreign key(s) for each relation. Draw the relational integrality constraints; (c) For each of the relations created, indicate its normal form. If the relation is not in the 3NF, decompose it into 3NF relations.…

    • 1684 Words
    • 7 Pages
    Good Essays
    Read More
  • Powerful Essays

    Student Admission System
    • 913 Words
    • 4 Pages

    Student Admission System

    3. Specific Requirements 3.1 3.2 3.3 3.4 3.5 3.6 Data Flow Diagram Entity-Relationship Diagram Database Design Flow Charts System Analysis Input Output Forms…

    • 913 Words
    • 4 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Entity-Relationship model vs. Semantic Object model
    • 224 Words
    • 1 Page

    Entity-Relationship model vs. Semantic Object model

    An Entity Relationship Model, also known as an Entity Relationship Diagram, a graphical representation of entities and their relationships to each other, typically used in computing in regard to the organization of data within databases or information systems. An entity is a piece of data; an object or concept about which data is stored. A relationship is how the data is shared between entities. The three types of relationships between entities are one-to-one, one-to-many, and many-to-many.…

    • 224 Words
    • 1 Page
    Satisfactory Essays
    Read More
  • Powerful Essays

    Semester Exam System Erd.Pdf
    • 937 Words
    • 4 Pages

    Semester Exam System Erd.Pdf

    For constructing a conceptual schema of this data base, the entity sets and the associated attributes are given below (as our specification of the E-R diagram)…………………………..…

    • 937 Words
    • 4 Pages
    Powerful Essays
    Read More

Related Topics