Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Rdbmss enforce integrity rules automatically

10/11/2021 Client: muhammad11 Deadline: 2 Day

DB-Lecture3_ch03.ppt
Database Principles: Fundamentals of Design, Implementations and Management

CHAPTER 3

Relational Model Characteristics

Objectives

In this chapter, you will learn:
That the relational database model offers a logical view of data
About the relational model’s basic component: relations
That relations are logical constructs composed of rows (tuples) and columns (attributes)
That relations are implemented as tables in a relational DBMS
About relational database operators, the data dictionary, and the system catalog
How data redundancy is handled in the relational database model
Why indexing is important
*

A Logical View of Data

Relational model
Enables the programmer to view data logically rather than physically
Table
Has structural and data independence
Resembles a file conceptually
Relational database model easier to understand than its hierarchical and network database predecessors models
Table also called a relation because the relational model’s creator, Codd, used the term relation as a synonym for table
*

Tables and Their Characteristics

Logical view of relational database based on relation
Relation thought of as a table
Think of a table as a persistent relation:
A relation whose contents can be permanently saved for future use
Table: two-dimensional structure composed of rows and columns
Persistent representation of logical relation
Contains group of related entities = an entity set
*

Properties of a Relation

*

Example Relation / Table

*

Attributes and Domains

*

Each attribute is a named column within the relational table and draws its values from a domain.
The domain of values for an attribute should contain only atomic values and any one value should not be divisible into components.
No attributes with more than one value are allowed.
Degree and Cardinality

Degree and cardinality are two important properties of the relational model.
A relation with N columns and N rows is said to be of degree N and cardinality N.
The degree of a relation is the number of its attributes and the cardinality of a relation is the number of its tuples.
The product of a relation’s degree and cardinality is the number of attribute values it contains.
*

Relational Schema

A relational schema is a textual representation of the database tables, where each table is described by its name followed by the list of its attributes in parentheses.

Keys

A key consists of one or more attributes that determine other attributes
Primary key (PK) is an attribute (or a combination of attributes) that uniquely identifies any given entity (row)
A Key’s role is based on determination
If you know the value of attribute A, you can look up (determine) the value of attribute B
*

*

Keys (cont..)

Relational Database Keys (cont….)

Composite key
Composed of more than one attribute
Key attribute
Any attribute that is part of a key
Superkey
Any key that uniquely identifies each row
Candidate key
A superkey without redundancies and without unnecessary attributes
Ex: Stud_ID, Stud_lastname
*

Keys (cont..)

Nulls:
No data entry
Not permitted in primary key
Should be avoided in other attributes
Can represent
An unknown attribute value
A known, but missing, attribute value
A “not applicable” condition
Can create problems when functions such as COUNT, AVERAGE, and SUM are used
Can create logical problems when relational tables are linked
Controlled redundancy:
Makes the relational database work
Tables within the database share common attributes that enables the tables to be linked together
Multiple occurrences of values in a table are not redundant when they are required to make the relationship work
Redundancy exists only when there is unnecessary duplication of attribute values
*

Keys (cont..)

*

Keys (cont..)

*

Keys (cont..)

Foreign key (FK)
An attribute whose values match primary key values in the related table
Referential integrity
FK contains a value that refers to an existing valid tuple (row) in another relation
Secondary key
Key used strictly for data retrieval purposes
*

Integrity Rules

Many RDBMs enforce integrity rules automatically
It is safer to ensure that your application design conforms to entity and referential integrity rules
Rules are summarized in the next slide
Designers use flags to avoid nulls
Flags indicate absence of some value
For Ex, the code -99 could be used as the AGENT_CODE entry for the 4th row of the CUSTOMER Table to indicate that customer Paul Olowsky does not have yet an agent assigned to it
*

Integrity Rules

*

Integrity Rules

*

The Data Dictionary and System Catalog

Data dictionary
Provides detailed accounting of all tables found within the user/designer-created database
Contains (at least) all the attribute names and characteristics for each table in the system
Contains metadata: data about data
Sometimes described as “the database designer’s database” because it records the design decisions about tables and their structures
*

*

A Sample Data Dictionary

The Data Dictionary and System Catalog (cont..)

System catalog
Contains metadata
Detailed system data dictionary that describes all objects within the database
Terms “system catalog” and “data dictionary” are often used interchangeably
Can be queried just like any user/designer-created table
*

Relationships within the Relational Database

1:M relationship
Relational modeling ideal
Should be the norm in any relational database design
1:1 relationship
Should be rare in any relational database design
M:N relationships
Cannot be implemented as such in the relational model
M:N relationships can be changed into two 1:M relationships
*

The 1:M Relationship

Relational database norm
Found in any database environment
*

*

The 1:M Relationship (cont…)

The 1:1 Relationship

One entity related to only one other entity, and vice versa
Sometimes means that entity components were not defined properly
Could indicate that two entities actually belong in the same table
Certain conditions absolutely require their use
As rare as 1:1 relationships should be, certain conditions absolutely require their use
*

*

The 1:1 Relationship (cont…)

*

The 1:1 Relationship (cont…)

The M:N Relationship

Can be implemented by breaking it up to produce a set of 1:M relationships
Avoid problems inherent to M:N relationship by creating a composite entity or a bridge entity
The composite entity Includes -as foreign keys- at least the primary keys of the tables that are to to be linked
*

Implementation of a composite entity
Yields required M:M to 1:M conversion
Composite entity table must contain at least the primary keys of original tables
Linking table contains multiple occurrences of the foreign key values
Additional attributes may be assigned as needed
*

The M:M Relationship (cont..)

*

The M:M Relationship (cont…)

*

Figure 3.16 in the book

*

Figure 3.17 in your book

*

Data Redundancy Revisited

Data redundancy leads to data anomalies
Such anomalies can destroy the effectiveness of the database
Foreign keys
Control data redundancies by using common attributes shared by tables
Crucial to exercising data redundancy control
Sometimes, data redundancy is necessary
*

Data Redundancy Revisited (cont…)

*

Data Redundancy Revisited (cont..)

*

*

Data Redundancy Revisited (cont…)

Indexes

Orderly arrangement to logically access rows in a table
Index key
Index’s reference point
Points to data location identified by the key
Unique index
Index in which the index key can have only one pointer value (row) associated with it
Each index is associated with only one table
*

*

Indexes (cont..)

Similar to Figure 3.20 of your book and better explained

Codd’s Relational Database Rules

In 1985, Codd published a list of 12 rules to define a relational database system
The reason was the concern that many vendors were marketing products as “relational” even though those products did not meet minimum relational standards
*

Summary

Tables (relations) are basic building blocks of a relational database
Keys are central to the use of relational tables
Keys define functional dependencies
Superkey
Candidate key
Primary key
Secondary key
Foreign key
Each table row must have a primary key which uniquely identifies all attributes
Tables can be linked by common attributes. Thus, the primary key of one table can appear as the foreign key in another table to which it is linked
Good design begins by identifying appropriate entities and attributes and the relationships among the entities. Those relationships (1:1, 1:M, M:N) can be represented using ERDs.

*

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Professional Coursework Help
Chartered Accountant
Helping Hand
Assignment Guru
ECFX Market
Smart Accountants
Writer Writer Name Offer Chat
Professional Coursework Help

ONLINE

Professional Coursework Help

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$17 Chat With Writer
Chartered Accountant

ONLINE

Chartered Accountant

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$37 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$30 Chat With Writer
Assignment Guru

ONLINE

Assignment Guru

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$27 Chat With Writer
ECFX Market

ONLINE

ECFX Market

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$33 Chat With Writer
Smart Accountants

ONLINE

Smart Accountants

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$25 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Http www apus edu online library tutorials chicago htm - Art history essay - Airds high school bell times - Eileithyia goddess of truth - Cornish place names meanings - Field of view microscope 40x - Modern fires vs legacy fires - Foxbat aircraft for sale australia - Ohsas 18001 implementation checklist - Textual analysis essay assignment - COURT CASE CJT 202 ASSIGNMENT - Ethical and legal implications of disclosure and nondisclosure - Anglia interiors ltd huntingdon - Moodle login fed uni - Assignment - Tax return project solutions - Move one coin to make two rows of 5 - Marketing chateau margaux pdf - Blank training matrix template - Fdlgrades - Article review - Wilfred owen dulce et decorum est translation - Ohio scientific computer for sale - Dlsweb rmit edu au report - Two kinds of statistics - Mad catz ctrlr windows 10 - Creating a professional image - Meat preservation methods ppt - 571 mount barker road bridgewater - Sir joseph hotung net worth - We have scorched the snake not killed it metaphor - Elevator problems physics worksheet - Error 1920 service tenable nessus - Mcdonaldization examples in everyday life - International journal of software science and computational intelligence ijssci - Conch republic electronics mini case - George washington carver ducksters - Nonpf core competencies for fnp - Lab Activity: Relational Databases - Alta ski company inventory records - Nursing care plan book online free - Axe target market demographics - Alert and oriented x3 but confused - St maurice's high school - Ethics in financial responsibilities and to evaluate ethical considerations of executive compensation - Customer relationship management is about mcq - Arduous company statement cash flows - History quetiom - Economics & public policy 6e w myeconlab rev - Highgear watch battery replacement - Econ - Watch rome and juliet 2006 online free - Vce physics study design - Talking cookie jar kmart - Entity relationship diagram restaurant management system - Introduction to spss pdf - Thomas l floyd digital fundamentals 11th edition solutions - Chesham bois parish council - Describe a procedure to separate sand and salt - Bachelor of midwifery rmit - Features of a newspaper article - Essay writing(1500-2000words) - The bedford reader answer key - What type of seizure was this child probably experiencing - Who are the training package developers - 500 word essay APA style - Pic microcontroller instruction set with examples - One hundred years of solitude family tree - 93 waldegrave crescent vincentia - Essay - How to calculate mass in physics - Harvard business publishing simulation answers - Manufacturing execution systems training courses - Market segmentation multiple choice questions and answers - Relatively low role ambiguity has been associated with higher remarital satisfaction. - The value of having a LinkedIn profile 800 words essay due 10/24/2020 - 2006 hess corp nyse truck and racers - Starbucks customer satisfaction case study - Art yasmina reza monologue - Case study 2 - Week 6 HR - Electric potato science experiment - El yunque food web - Cateye double wireless sensor - What is the meaning of concerto - NS-14 -D - Ktm industries green cell foam - Doris is coming zz packer - Emergency cardiac drugs list - Conflict of interest management plan template - QNT561 Week 6 Signature assignment Consumer Database - Johnson and johnson diversity case study - Data communication hardware ppt - Job order costing exercise and solutions - Sj the blind side - Saved by grace fanny crosby chords - Cloud computing architecture ppt - Archer daniels midland and the friendly competitors case study - Cat 950m operators manual - Final Paper