We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
Course Outing
Note: Dear instructors, you are requested to fil in this form as and when topics are coverd in each
week. This form must be returned to the HoD prior to the start of final term examination alongwith
the attachements specified at the end of this form
Course CodalSC-202 | course Title|Database Systems ] shitt [Boring
Greit tours 3 | Semester [2014 Fal | mstructor Mr. Zaar ial
‘To introduce basic database design concepts.
The Data Base Systems Concepts by Silberschatz, Korth & Sudarshan, 4th Edition
Toxt Books
otorence Books JetTrey A. Hoffer, Mary 8, Prescoll, Fred R, MoFadden, "Modem Dalabase
‘Management’, 6th ed., 2002.
lass Policy 1. A student must reach the class-room in time. Late comers may join the class but
are not entitled to be marked present.
2. Attendance shall be marked at the start of the class and students failing to secure
175% attendance will not be allowed to sit in the Final Exam.
12, The assignment submission dead-line must be observed, In case of late
‘submission, ten percent (10%) may be deducted for each day.
‘4. Those who are absent on the announcement date of the assignmentitest, must get
the topic/chapter of the test/assignment confirmed through their peers.
'5. Mobile phones must be switched-off in the class-rooms,
Grading Poicy|internal Evaluation
[Mid-Term Exam 15 Marks
(Attendance [05 Marks
[Assignment HO Marks
(Quizzes/Tests HO Marks
[Presentations [10 Marks
‘Total Internal Marks [50 Marks
Final Term Examination
[Final Term Exam (50 Marks
Total Marks rou marks:
Monday, December 22. 2014 Page 7 of 1 Wook | Lecture Topics Covered Evaivation — Assignmot
No | Dates Instruments Issue/Due_—Test/Quiz
Used Dates
7 "An Introduction to the Data Base
History
Basic Concept & Definitions
2 Database System Va File System
Data Base Approach
3 (Components of Database
‘Advantages of Data Base
‘Architecture of Data Bases
a Datahasa Revalopmant Pranass
5 (Data Modeling with E-R Model
‘An Example Data Base Application
6 Enility Types & Sets
‘Attribute & Keys Concept
7 Degree of Relationships
‘Multiple Relationships
8 ‘The Logical Data Base Design
g The Ratational Model
Integrity Constraint
0 (Creation Relational Tables
‘Transforming ER Diagrams in to Relations
‘Monday, December 22, 2014
Page 8 of 51 11 Introduction to Normalization
'Basic Normal Forms
2 ‘Normalization Forms
‘Normatzation Summary
3 Physical Database Design
7 The SQL Environment
=) ‘SQL Commanas
DML,DDLDCL
parsing process
6 Revision
Instructor oad Department of Computer Science
Please specify topics not covered as per course outine, if any.
Reasons for not covering the above mentioned topics.
‘Annexures:
4. Copies of assigmnet # 1, 2, 3 etc alongwith identification of major assingment.
2. Coples of tests/quizzes conducted alongwith thelr weightage.
3. A copy of projects administered, if any.
4, List of presentation topics, if any.
Instructor
‘Monday, December 22,2014 Page 9 of 51