Essay on Database System Concepts

Submitted By yoganand1627
Words: 2879
Pages: 12
Open Document
Chapter 4: Intermediate SQL

Database System Concepts, 6th Ed.
©Silberschatz, Korth and Sudarshan
See www.db­book.com for conditions on re­use

Chapter 4: Intermediate SQL
 Join Expressions
 Views
 Transactions
 Integrity Constraints
 SQL Data Types and Schemas
 Authorization

Database System Concepts ­ 6th Edition

4.2

©Silberschatz, Korth and Sudarshan

Joined Relations
 Join operations take two relations and return as a result

another relation.

 A join operation is a Cartesian product which requires that

tuples in the two relations match (under some condition).
It also specifies the attributes that are present in the result of the join

 The join operations are typically used as subquery

expressions in the from clause

Database System Concepts ­ 6th Edition

4.3

©Silberschatz, Korth and Sudarshan

Join operations – Example
 Relation course

 Relation prereq

 Observe that prereq information is missing for CS­315 and course information is missing for CS­437
Database System Concepts ­ 6th Edition

4.4

©Silberschatz, Korth and Sudarshan

Outer Join
 An extension of the join operation that avoids loss of

information.

 Computes the join and then adds tuples form one relation

that does not match tuples in the other relation to the result of the join.

 Uses null values.

Database System Concepts ­ 6th Edition

4.5

©Silberschatz, Korth and Sudarshan

Left Outer Join
 course natural left outer join prereq

Database System Concepts ­ 6th Edition

4.6

©Silberschatz, Korth and Sudarshan

Right Outer Join
 course natural right outer join prereq

Database System Concepts ­ 6th Edition

4.7

©Silberschatz, Korth and Sudarshan

Joined Relations
 Join operations take two relations and return as a result

another relation.

 These additional operations are typically used as subquery

expressions in the from clause

 Join condition – defines which tuples in the two relations

match, and what attributes are present in the result of the join.

 Join type – defines how tuples in each relation that do not

match any tuple in the other relation (based on the join condition) are treated.

Database System Concepts ­ 6th Edition

4.8

©Silberschatz, Korth and Sudarshan

Full Outer Join
 course natural full outer join prereq

Database System Concepts ­ 6th Edition

4.9

©Silberschatz, Korth and Sudarshan

Joined Relations – Examples
 course inner join prereq on

course.course_id = prereq.course_id

 What is the difference between the above, and a natural join?
 course left outer join prereq on course.course_id = prereq.course_id

Database System Concepts ­ 6th Edition

4.10

©Silberschatz, Korth and Sudarshan

Joined Relations – Examples
 course natural right outer join prereq

 course full outer join prereq using (course_id)

Database System Concepts ­ 6th Edition

4.11

©Silberschatz, Korth and Sudarshan

Views
 In some cases, it is not desirable for all users to see the

entire logical model (that is, all the actual relations stored in the database.)

 Consider a person who needs to know an instructors name

and department, but not the salary. This person should see a relation described, in SQL, by select ID, name, dept_name from instructor

 A view provides a mechanism to hide certain data from the

view of certain users.

 Any relation that is not of the conceptual model but is made

visible to a user as a “virtual relation” is called a view.

Database System Concepts ­ 6th Edition

4.12

©Silberschatz, Korth and Sudarshan

View Definition
 A view is defined using the create view statement which has

the form

create view v as < query expression > where <query expression> is any legal SQL expression. The view name is represented by v.
 Once a view is defined, the view name can be used to refer to

the virtual relation that the view generates.

 View definition is not the same as creating a new
Show More

Related Documents: Essay on Database System Concepts

Database System Concepts Essay

Development Database System Concepts ­ 6th Edition 9.1 ©Silberschatz, Korth and Sudarshan Chapter 9: Application Design and Development  Application Programs and User Interfaces  Web Fundamentals  Servlets and JSP  Application Architectures  Rapid Application Development  Application Performance  Application Security  Encryption and Its Applications Database System Concepts ­ 6th Edition 9.2 ©Silberschatz, Korth and Sudarshan Application Programs and User Interfaces  Most database users do not use a query language like SQL…

Words 4738 - Pages 19

Database System Concepts Essay example

Chapter 1: Introduction Database System Concepts, 6th Ed. ©Silberschatz, Korth and Sudarshan See www.db­book.com for conditions on re­use Database Management System (DBMS)  DBMS contains information about a particular enterprise  Collection of interrelated data  Set of programs to access the data  An environment that is both convenient and efficient to use  Database Applications:  Banking: transactions  Airlines: reservations, schedules  Universities: registration, grades…

Words 1215 - Pages 5

Finding Articles On Your Research: Using Library Databases

your research topic – using library databases When looking for articles on your research topic, the most effective tool to use is the library’s databases. These provide you with quality, scholarly articles, appropriate for academic study. Databases & Journal Finder— which one to use? There is sometimes confusion over when to use databases and when to use Journal Finder as both are tools for finding articles. Databases - you use databases when you want to find articles on a…

Words 946 - Pages 4

Assignment Berif Essays

Introduction In this assignment you will consider the nature of information and how an information system can gain a business a competitive advantage. You will plan, design and implement a database solution that meets a specific business scenario. Assignment brief Read the following case study carefully. It is based upon a local estate agency which currently uses a paper based system for processing sales. ------------------------------------------------- Clients wishing to put their…

Words 1498 - Pages 6

Essay about Review Questions Chapter 1 and 2

following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. a) Data: Known facts that can be recorded and that have implicit meaning. b) Database: Collection of related data. c) DBMS: Is a collection of programs that enables users to maintain a database. d) Database system: Is a compilation of the database and complete definition…

Words 3545 - Pages 15

Online Reservation System Essay examples

so far by the use of Internet websites and online reservation systems, gives competitive advantage to other with same establishment. However, the potential competitive advantage can be transformed into real advantage if only the websites have proper design. As a result, the advocator conducted research on the facts related to the system that might be helpful to its development. The following are the gathered related proposed system: Jeong et al. (2005) discuss the role of website quality in…

Words 3773 - Pages 16

Logical Design Part 1

page paper titled “Logical Design, Part 1” whereas I am a recently hired consultant for ACME Global Consulting to procure requirements for a large database. In this scenario, “Logical Design, Part 1”, I will develop a database management systems to convince a set of clients of the benefits of using the Entity–Relationship model (E-R) in developing a database. In addition, my management would like the following points addressed in my design: (1). List the advantages of a relational model specific…

Words 1449 - Pages 6

Fundamentals of Database Systems Key Assignment Essay examples

Key Assignment Project Fundamentals of Database Systems CS251-1202B-03 June 25, 2012 Table of Contents Project Outline 4 Description of the Database Design Life Cycle (Phase 1 IP) 4 Selected Database Description 4 Tablet and Capsule Antibiotics 4 Powder and Liquid Antibiotics 5 Skin and Coat 5 A Listing And Description Of The 7 Steps Of The SDLC/DBDSL and Their Tasks 6 System Requirements Analysis and Feasibility Study 6 System Analysis 7 Code Generation and Design 9 Implementation…

Words 3571 - Pages 15

Research Paper On Security Policy

security. Security policies should minimize risk while not imposing undue access restrictions on those who need access to resources. This paper includes the password policy, wireless use policy, information logging standard, user privilege policy, database credentials policy and acceptance encryption policy. This paper briefly explains about the scope and procedures of each and every policy. Introduction When defining policies and when living with them from day to day, the reasons for…

Words 2117 - Pages 9

Cs251 Fundamantals of Database Systems Ip 1 - 5 Essay

CS251-1301B-03 Fundamentals of Database Systems Phase 1 -5 Individual Project Robert March 24th, 2013 Table of Contents Project Outline 3 Description of the Database Design Life Cycle 4 The Entity Relationship Diagram 7 The Logical Model and Normalization 9 The Microsoft Access Database 11 The Microsoft Access Database Application 14 References: 18 Project Outline My idea for a project concept is for a granite fabrication and installation company called MasterStoneWorks…

Words 1684 - Pages 7