KEMBAR78
Database Systems for Students | PDF | Databases | Data
Scribd
Upload
67 views18 pages

Database Systems for Students

This document provides information about a database systems lecture at Jahan University's BCS Faculty. It outlines the course objectives, which are to introduce basic database concepts and relational databases. It also covers topics like normalization, data integrity, ER/EER modeling, and SQL. The document describes classroom policies around attendance, assignments, and mobile phone use. It provides the grading breakdown and recommends textbooks. Finally, it previews the first chapter topics on data vs. information, metadata, database definitions, DBMS components, traditional file systems vs. databases, and actors involved in database systems.

Uploaded by

Baktash Ahmadi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
67 views18 pages

Database Systems for Students

This document provides information about a database systems lecture at Jahan University's BCS Faculty. It outlines the course objectives, which are to introduce basic database concepts and relational databases. It also covers topics like normalization, data integrity, ER/EER modeling, and SQL. The document describes classroom policies around attendance, assignments, and mobile phone use. It provides the grading breakdown and recommends textbooks. Finally, it previews the first chapter topics on data vs. information, metadata, database definitions, DBMS components, traditional file systems vs. databases, and actors involved in database systems.

Uploaded by

Baktash Ahmadi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 18

Jahan University

BCS Faculty

Subject: Database System


Lecture#
Lecturer:

1
Chapter No 1
DATABASES & DATABASE USERS

01/24/2022 2
Course Title
CSC271 – DATABASE SYSTEMS

01/24/2022 3
Course Objective
Introduces the basic concepts of database management and guides towards the concepts of its
application.
The course emphasizes on relational data base.
The course introduces normalization, data integrity and other topics like ER or EER model.
The course also introduces the basics of SQL
Working with SQL function & SQL Constraints

01/24/2022 4
Class Policy
A student must reach the class-room in time. Late comers may join the class but are not entitled
to be marked present.
Attendance shall be marked at the start of the class and students failing to secure 75%
attendance will not be allowed to sit in final exam.
The assignment submission deadline must be observed. In case of late submission, ten percent
may be deducted from each day.

01/24/2022 5
Class Policy (Con…)
Those who are absent on the announcement date of the assignment/test. Must get the
topic/chapter of test/assignment confirmed through their peers.
Mobile phones must be switched-off in the class-rooms

01/24/2022 6
Grading Policies
100%
100%
80% 60%
60%
40% 20%
5% 5% 10%
20%
0%

01/24/2022 7
Text Books to Recommended!!!!!

01/24/2022 8
Chapter No 1 Agenda
Data v. Information
Metadata
Database
Database Management System
Application Program
Actors Around Database Systems
Traditional file processing system
Database approach

01/24/2022 9
Data
Raw fact & not useful or meaningless

M. Karim Mujtabah 23 7 89.76


Sharifullah Ahmad Shah 25 6 56.676
Ahmad Wali Shams 34 5 90.567
Jamsheed Rahimullah 45 4 98.567
MS. Khan Nasir Khan 26 8 85.987

01/24/2022 10
Metadata
Field Name Data Type Length Description Constraint
Roll No Integer 3 Roll number of the student Value from 1 to 100

Name Alphabetic 50 Name of the student

Address Alphanumeric 100 Address of the student

Email Alphanumeric 25 Email of the student Must contain @ and dot (.)

Phone Alphanumeric 25 Phone of the student

01/24/2022 11
Information
Processed data

Jahan University Computer Science Faculty Student Percentage


NAME F/NAME AGE SEMESTER PERCENTAGE
M. Karim Mujtabah 23 7 89.76
Sharifullah Ahmad Shah 25 6 56.676
Ahmad Wali Shams 34 5 90.567
Jamsheed Rahimullah 45 4 98.567
MS. Khan Nasir Khan 26 8 85.987

01/24/2022 12
What is a Database?
Shared collection of logically related data

01/24/2022 13
Database Management System
DBMS
◦ Collection of programs

Application Program
◦ User interact with the DBMS

Database System
◦ Database + DBMS Software + Application Program

01/24/2022 14
Con…
Users

Database
System Application Programs

Query Processing
DBMS
Data Access

Metadata Data

01/24/2022 15
Actors Around Database Systems
DB Designers
DB Administrators
Application Programmers
End Users
◦ Naïve Users
◦ Sophisticated Users

01/24/2022 16
Actors Around Database Systems
End Users
◦ Use the DB
◦ Types of DB users
◦ Naïve Users
◦ Sophisticated Users

01/24/2022 17
Thank You For Your Patience
F REQ U E N T LY A S K ED Q U ES T I O N S

01/24/2022 18

You might also like