Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Database, DBMS, Relational Database, Advantages, Elmasri And Navathe, Data Model, SQL, NormaliZation, Relational Algebra, Intergrity, Constraints, Three Conceptual Levels, UML Model, Computer, Normal Forms, Functional Dependencies, Implementation, Dr Mohammad Yamin, Ms Zoe Brain, Lecture Slides, Australian National University, Australia.
Typology: Slides
1 / 42
This page cannot be seen from the preview
Don't miss anything!
Lecture 1: Course Overview
What is a database, a DBMS, a relational database? What are we going to learn in this course? What activities will part of the course? How will you be assessed?
“A database is a collection of related data.” [Elmasri and Navathe §1.1]
A database management system (DBMS) is a computer application for creating, maintaining and using databases.
A database management system (DBMS) is a computer application for creating, maintaining and using databases.
A DBMS has several advantages over “raw” computer files data is abstract , independent of computer and programming concerns
[Elmasri and Navathe §1.3]
A database management system (DBMS) is a computer application for creating, maintaining and using databases.
A DBMS has several advantages over “raw” computer files data is abstract , independent of computer and programming concerns different users can have customised views of the data supports many simultaneous users, transaction processing
[Elmasri and Navathe §1.3]
A database management system (DBMS) is a computer application for creating, maintaining and using databases.
A DBMS has several advantages over “raw” computer files data is abstract , independent of computer and programming concerns different users can have customised views of the data supports many simultaneous users, transaction processing database is self-describing [Elmasri and Navathe §1.3]
[Elmasri and Navathe, Chapter 5]
In a relational database, the data is organised as relations. relation is a mathematical idea, but it’s pretty much like a table, with rows and named columns.
[Elmasri and Navathe, Chapter 5]
In a relational database, the data is organised as relations. relation is a mathematical idea, but it’s pretty much like a table, with rows and named columns. The relational model is the most common data model.
[Elmasri and Navathe, Chapter 5]
In a relational database, the data is organised as relations. relation is a mathematical idea, but it’s pretty much like a table, with rows and named columns. The relational model is the most common data model. It is simple, yet mathematically solid. Ideas from maths and logic give us
[Elmasri and Navathe, Chapter 5]
In a relational database, the data is organised as relations. relation is a mathematical idea, but it’s pretty much like a table, with rows and named columns. The relational model is the most common data model. It is simple, yet mathematically solid. Ideas from maths and logic give us a powerful but easy language: SQL (Structured Query Language)
[Elmasri and Navathe, Chapter 5]
In a relational database, the data is organised as relations. relation is a mathematical idea, but it’s pretty much like a table, with rows and named columns. The relational model is the most common data model. It is simple, yet mathematically solid. Ideas from maths and logic give us a powerful but easy language: SQL (Structured Query Language) design and evaluation techniques (normalisation) theory for optimising query processing (relational algebra)
Be careful to distinguish between the various technical and ordinary usages of the words “relation” “relationship” “relational” “related” etc.
the normal, non-technical sense, eg “a database is a collection of related data”
Be careful to distinguish between the various technical and ordinary usages of the words “relation” “relationship” “relational” “related” etc.
the normal, non-technical sense, eg “a database is a collection of related data” the mathematical sense of relation: a subset of a cartesian product relationships as a modelling concept in the entity-relationship technique
the central topics of the course are
the relational data model
