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

    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

    Data Table Analysis: Kudler Fine Foods
    • 496 Words
    • 2 Pages

    Data Table Analysis: Kudler Fine Foods

    An entity relationship diagram (ERD) is a graphical documentation technique used in the designing of database within organizations to describe the entities and their direct relationships (Bagranoff, Simkin, & Strand, 2008). The ERD diagram consists of entities, attributes, and relationship. The entity represents a rectangular; the diamond is symbolized by describing the relationship of the entities, oval shape describes the attributes, and the lines connect all three to describe their relationship. Attached is an ERD of Kudler Fine Foods showing their existing data tables.…

    • 496 Words
    • 2 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Devry Acct 244 Lab1 Questions
    • 314 Words
    • 2 Pages

    Devry Acct 244 Lab1 Questions

    1. Entities in the conceptual model eventually are converted to tables in the database, and the attributes convert to the fields within the tables. Given this information, list the attributes (fields) found in the supplier table.…

    • 314 Words
    • 2 Pages
    Satisfactory 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
  • Good Essays

    Kudler Fine Foods Data Table Analysis
    • 851 Words
    • 4 Pages

    Kudler Fine Foods Data Table Analysis

    The following diagram (1-1) is entity relationship (E-R) diagram and it illustrates the existing data tables.…

    • 851 Words
    • 4 Pages
    Good Essays
    Read More
  • 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
  • Good Essays

    Unit 3 research
    • 383 Words
    • 2 Pages

    Unit 3 research

    An entity-relationship diagram is a specialized graphic that illustrates the relationships between entities in a database. ER diagrams often use symbols to represent three different types of information. Boxes are commonly used to represent entities. Diamonds are normally used to represent relationships and ovals are used to represent attributes…

    • 383 Words
    • 2 Pages
    Good Essays
    Read More
  • Powerful Essays

    IST223 Crib sheet
    • 3425 Words
    • 7 Pages

    IST223 Crib sheet

    rectangles, and relationships are shown by lines between the rectangles. Attributes are generally listed within the rectangle. The many side of many relationships is represented by a crows footentity-relationship (E-R) modelA set of constructs and conventions used to create data models. The things in the users world are represented by entities, and the associations among those things are represented by relationships. The results are usually documented in an entity-relationship (E-R) diagramID-dependent entityan entity whose identifier includes the identifier of another entityidentifierwhich are attributes that name, or identify, entity instancesidentifying relationshipIn such relationships, the parent is always required, but the child (the ID-dependent entity) may or may not be required, depending on application requirements. Identifying relationships are shown with solid lines in E-R diagrams.is-aRelationships among supertype/subtype entitiesmandatoryat least one entity instance must participate in the relationshipmaximum cardinalityThe maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.minimum cardinalityThe minimum cardinality is the minimum number of entity instances that must participate in a relationship instance.nonidentifying relationshiprelationship drawn with a dashed line (refer to Figure 5-7) is used between strong entities and is called a nonidentifying relationship because there are no ID-dependent entities in the relationship.null valueare a problem because they are ambiguous. They can mean that a value is inappropriate, unknown, or known, but not yet been entered into the databaseparentAn entity or row on the one side of a one-to-many relationshiprecursive relationshipoccurs when an entity type has a relationship to itself.relationship classAssociations among entity classesrelationship instanceassociations among entity instances.strong entityan entity that represents something that can exist…

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

    Cis 515week 3
    • 1024 Words
    • 4 Pages

    Cis 515week 3

    In order to properly indentify the university’s requirements and create an accurate proposal, the first step should be to create and Entity Relationship Model (ERM). The ERM will provide a visual representation of the data structure of the data stores and show the relationships between the data. The following diagram displays the ERM:…

    • 1024 Words
    • 4 Pages
    Good 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

    Cis 111
    • 790 Words
    • 4 Pages

    Cis 111

    “The benefits of using the relational model would result in an easy to use, flexible, high performance database at a low cost.” (Anita, 2010) Therefore, allowing them to participate in the entire design process of the logical construction. The relational model provides an easy and flexible way of manipulating data with a system that offers:…

    • 790 Words
    • 4 Pages
    Good 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

    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

Related Topics