IT2301: DATABASE MANAGEMENT SYSTEMS DBMS

1
PART 3
IT2301 DATABASE MANAGEMENT SYSTEMS (DBMS)
E-mail dbms_at_ict.cmb.ac.lk
Preparing for BIT 19/04/2001
2
IT2301 - OBJECTIVES
AFTER SUCCESSFULLY COMPLETING THIS MODULE
STUDENTS SHOULD BE ABLE TO

• Understand why database systems are desirable
• Understand concepts of database systems in
  general and relational systems in particular

3
IT2301 - OBJECTIVES cont.
AFTER SUCCESSFULLY COMPLETING THIS MODULE
STUDENTS SHOULD BE ABLE TO

• Acquire data modelling skills
• Perform relational database design
• Express knowledge of standard database language
  SQL

4
IT2301 - OBJECTIVES cont.
AFTER SUCCESSFULLY COMPLETING THIS MODULE
STUDENTS SHOULD BE ABLE TO

• Successfully develop personnel databases on their
  own
• Work as members of a team when building workgroup
  and enterprise databases
• Illustrate emerging technology and applications

5
BRIEF SYLLABUS

• TOPIC MIN. NO. OF
  HOURS
• 1. File Organisation Access Mechanisms 12
• 2. Introduction to DBMS 06
• 3. Data Model 04
• 4. Database Design Process 11
• 5. Data Normalisation process the normal forms
  03
• 6. Data Manipulation 24
• TOTAL FOR THE MODULE 60

6
Data Manipulation 24
STUDENTS ARE EXPECTED TO HAVE A TOTAL OF 10
ADDITIONAL HOURS OF PRACTICAL TUTORIALS TO
FURTHER STRENGTHEN THEIR KNOWLEDGE OF THIS SECTION
REFER WEB SITE FOR TOPIC OBJECTIVES
7
PLATFORM
Any standard PC (Pentium) with a standard
commercial relational DBMS (e.g. Microsoft
Access) that allows students to DEVELOP SMALL
APPLICATIONS involving menu design, screen
design, data validation in data entry screens,
report design
8
REFERENCES

• MAIN READING
• Database Management and Design by G.W. Hansen and
  J.V. Hansen, 2nd edition, Prentice-Hall of India,
  Eastern Economy Edition, 1999.
• Database System Concepts by A. Silberschatz, H.F.
  Korth and S. Sudarshan, 3rd edition, McGraw-Hill,
  International Edition, 1997.

9
REFERENCES

• SUPPLEMENTARY READING
• Principles of Database Management by James
  Martin.
• Database Management Systems by A.K. Majumdar ...
• An Introduction to Database Systems by C.J. Date.
  
• Fundamentals of Database Systems by R. Elmasri
  ...
• Modern Database Management by R.F. McFadden ...
• Database Processing Fundamentals, Design, ...

ANY BOOK WILL COVER ALL MAJOR PARTS OF THE
SYLLABUS