Lecture about database, Cheat Sheet of Computer Science

Download Lecture about database and more Cheat Sheet Computer Science in PDF only on Docsity!

Introduction to Databases

Autumn 2022 Egyptian Russian University IS201: Database Systems Dr. Nermeen Kamel

Introduction to Dtabases

This course is designed primarily to meet the needs of students who are interested in using database technology in sysem development. The course presents methods used for the storage, retrieval, and organization of data.

Job descriptions also exactly describe this course…

0.Why should you be here?

4

• (^) After successfully completing this course students should be able to - (^) explain the fundamental terms of - (^) databases in general - (^) the relational model - (^) theoretical and practical aspects of query

languages

• (^) conceptual and logical design of databases including

normalization

• further concepts like constraints, views, indexes,

transactions and object databases

Instructional Objectives

Egyptian Russian UniversityEgyptian Russian University IS201IS201 IS201:IS201: Database SystemsDatabase Systems (^55)

Contents this Course

1 Introduction 2 The Database Life Cycle (DBLC) 2 Data Modeling 1 3 Data Modeling 2 4 Relational Model 5 Logical Database Design 1 6 Logical Database Design 1I 7 SQL 1 8 SQL-DLL 9 Advanced SQL. 10 Normalization 11 Application Programming 1

Organization

► (^) Class web site: ⇒ https://lms.eru.edu.eg/moodle ► (^) Textbook: Database System Concepts, 7th edition, Silberschatz, Korth, and Sudarshan (required) Database Management Systems, 3rd ed., Ramakrishnan & Gehrke, (optional)

Attendance Regulations

► Don’t fall behind!

Attendance checks take place at the first 10 minutes of seminars, tutorials and labs. Students must attend at least 75% of the tutorials and practical labs. If absence exceeds the allowed percentage: 25% (either excused

• as the excuse does not mean that the content is delivered- or unexcused) in the same course, the student will not be allowed to sit for the exam of the relevant subject and will have to drop the course and retake the course when available.

Getting Help

Instructor office hours ⇒ Sunday 1-3 pm- Monday 9:11-1:3 pm –Tuesday 11-3. TA office hours ⇒ Refer to TA

Lecture Outline

Unit 1: Data Everywhere. Unit 2:Case Study (a data management problem). Unit 2: Overview of a Database Management System. Unit 3: Summary.

• (^) Amazon.com
  • (^) Half a billion products on sale
  • (^) Its website serves one billion pages a day on average, or 10000 pages a second. Peaks can be much higher.
  • (^) To serve those billions of web pages, it will retrieve trillions of database objects from its backend database.
  • (^) A proprietary NoSQL database as the backend.

Data Everywhere

Data Everywhere

Facebook

• (^) Scenario :
  • (^) You are a video rental owner.
  • (^) Customers rent DVD/BluRay copies of movies.
  • (^) There may be several copies of each movie.
  • (^) There are a large number of customers and a handful of salespersons.
• (^) Needs:
  • (^) Which DVDs were rented out?
  • (^) Are any videos overdue?
  • (^) When will a copy of a movie become available?

A data management problem

Advantages:

• (^) Easy to edit
• Simple to add a record
• Simple to delete a record

Solution 1: A simple file