Database Presentation Day 2

Database Presentation Day 2 - The Relational Model...

Info iconThis preview shows pages 1–14. Sign up to view the full content.

View Full Document Right Arrow Icon
vjk - Database Technologies The Relational Model relational database was invented by E. F. Codd at IBM in 1970.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
vjk - Database Technologies It allowed files to be related by means of a common field. In order to relate any two files, they simply need to have a common field, which makes the model extremely flexible Poet Poem
Background image of page 2
vjk - Database Technologies The Relational Model The relational database focuses on the logical representation of the data and its relationship rather than physical storage details Tables play a prominent role in the relational model
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
vjk - Database Technologies Some Basic Terms Entities- An entity is something about which you want to store data Example: Person, Place, concept or event
Background image of page 4
vjk - Database Technologies Entity Set Entity Set- An Entity Set is a named collection of entities that share common characteristics. The name of the entity set reflects its contents Example: STUDENT, FACULTY, etc.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
vjk - Database Technologies Attributes Attributes-Each entity has certain characteristics known as attributes Example: STUDENT entity includes the attributes student registration number, name, grade, dob, etc.
Background image of page 6
vjk - Database Technologies Table A table is perceived as a two-dimensional structure composed of rows and columns. A table contains a group of related entities i.e., an entity set A table is also called a relation because the relation model’s creator E F Codd, used the term relation as a synonym for table
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
vjk - Database Technologies
Background image of page 8
vjk - Database Technologies Characteristics of a Table 1. A table is a two-dimensional structure composed of rows and columns 2. Each table row (tuple) represents a single occurrence within the entity set 3. Each table column represents an attribute, and each column has a distinct name
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
vjk - Database Technologies Continued… 1. Each row/column intersection represents a single data value 2. Each table must have an attribute or a combination of attributes that uniquely identifies each row 3. All values in a column must conform to the same data format
Background image of page 10
vjk - Database Technologies Continued… 7. Each column has a specific range of values known as the attribute domain 8. The order of the rows and columns is immaterial to the DBMS
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
vjk - Database Technologies The Keys relational systems require keys that can uniquely identify the rows of a table A key consists of one or more attributes that determines other attributes
Background image of page 12
Different types of Keys 1.Primary 2.Foreign 3.Candidate 4.Alternate
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 14
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 38

Database Presentation Day 2 - The Relational Model...

This preview shows document pages 1 - 14. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online