DBMS-304
Day: Topic:
Day 1 Introduction to DBMS
Day 2 Traditional File Based Systems
Day 3 Database Environment
Day 4 Centralized Database
Day 5 Distributed Databases
Day 6 Three level architecture.
Day 7 Data Models.
Day 8 Multi-User DBMS Architectures
Day 9 Data Administration & Database Administration
Day 10 ER model
Day 11 Relationship
Day 12 Cardinality Constraints
Day 13 ER Examples and Transforming ER into Relational
Day 14 Entity Relationships model
Day 15 Relational DBMS
Day 16 Generalization For EERD
Day 17 Quiz 1/Assingments
Day 18 Normalizations,
Day 19 3rd,Bycode normal form
Day 20 4th , 5th normal forms
Day 21 Anomalies,Types of anomalies (123)
Day 22 Functional depandences
Day 23 Presentation
Day 24 Database Schemas
Day 25 Relational Integrity In DBMS
Day 26 database Planning and designing
Day 27 Introduction to SQL
Day 28 Insearting,updating and deleting data
Day 29 Processing single table and multi processing
Day 30 Data Manipulation
Day 31 Project Case: Mountain view Community hospital
Day 32 Creating a Database
Day 33 Tables,index
Day 34 Database Application Life Cycle
Day 35 Views, Transactions
Day 36 Presentation
Day 37 Data Administration & Database Administration
Day 38 Quiz 2/Projects 1
Day 39 Structural Constrains
Day 40 Quiz 3/Project 2
Day 41 Presentation
Day 42 Database Design Methodology
Day 43 Database Security
Day 44 Parallel database
Day 45 Data fragmentation
Day 46 Client Server Architecture(1,2,3) Tier architecture
Day 47 SQL independence
Day 48 Presentation/Project 3
Course Objectives:
1. Discuss Database management systems, databases and its applications
2. Familiarize the students with a good formal foundation on the relational mo
3. Outline the various systematic database design approaches
4. Describe the concepts of transactions and transaction processing and the issues, techniques related to con
5. Explore the File organizations, indexing and hashing mechanisms.
Course Outcomes:
At the end of this Database Management Systems course, students will be able
1. Model Entity-Relationship diagrams for enterprise level databases
2. Formulate Queries using SQL and Relational Formal Query Languages
3. Apply different normal forms to design the Database.
4. Summarize concurrency control protocols and recovery algorithms.
DBMS-304
Sub-Topics
Data, Structured data and un Structured data,type of data,Information,
Data Processing, Data versus information, metadata c
Disadvantages,
Evoluation of Database system,Decades
Personal computer database,Client server database system
its advantage or disadvantage
Process(Replication,Duplication), categories of DDB
Homogeneous,Heterogeneous DDB and DDB advantage or disadvantage
Views,External,Conceptual,Internal
Hierarchical,Network,Relational Model
1-Tier Architecture,2-Tier Architecture,3-Tier Architecture
Entity Relationship model,Strong vs weak entity type,Attributes
degree of Relationship logical connection
Maximum, Minimum cardinality
Relationship(1 to1,1 to many,many to many).
RDBMS vs. DBMS,Features of relational database management systems
Difference, attributes and inheritance,User-defined and condition
Constraints
History,1st,2nd normal form
Inseart ,Delete,Upadate
Rules for functional depandeces,Multivalued Dependency , Trivial Functional
Dependency
Non-Trivial Functional Dependency
Transitive Dependency)
keys,schema diagrams
Database planning,Systems definition,Requirements collection and analysis,Database
design,DBMS selection,Application design
Prototyping,Implementation,Data conversion and loading
Testing,Operational maintenance
what is SQL,Rules,SQL process
Advantage and disadvantages
Select,Inseart,Update,delete
Planing,system defination,Requirment analysis,implementation…
Virtual views,modify view,materialized view,Selection Index
one to one,one to many,many to one,many to many,Participation Constraints
Requirement Analysis,Database Designing,Implementation
Why Database Security is Important?
Secrecy/Confidentiality,Integrity,Availablity and Security problems
Methods of securing the Database(Authorization,Encryption,Authentication,Logical)
Shared Memory System,Shared Disk System,Shared Nothing System and it advantage
or disadvantages
advantage and disadvantages, three methods of Fragmentation (Horizontal
fragmentation
Vertical fragmentation
Mixed or Hybrid fragmentation)
Course Objectives:
management systems, databases and its applications
s with a good formal foundation on the relational model.
various systematic database design approaches
n processing and the issues, techniques related to concurrency and recovery manager.
organizations, indexing and hashing mechanisms.
Course Outcomes:
e Management Systems course, students will be able to:
lationship diagrams for enterprise level databases
using SQL and Relational Formal Query Languages
erent normal forms to design the Database.
urrency control protocols and recovery algorithms.
Day: Topic:
Day 1 History of Computer
Day 2 Types of Computers
Day 3 Elements of computer
Day 4 Memory
Day 5
types of devices(input)
Day 6 Data-entry devices
Day 7
output devices
Day 8 Printer and its type(impact printer)
Day 9 Non-Impact Printer
Day 10 Types of display Screen
Application software and its limitations,System
Day 11
software(mac Window,Linux)
Day 12 Data Storage Units
Day 13 Storage devices
Day 14 RAID and Backup System
Day 15 Processing devices
Day 16 Terminals
Day 17 Computer-Based Information System (CBIS)
Day 18 Quiz/Assingment 1
Day 19 Presentation2
Day 20 Computer Organizing
Day 21 Computer Organizing
Day 22 Distributed computing
Day 23 Distributed Systems and Cloud Computing
Day 24 Quiz/Assingment 2/ How distributed computing works
Day 25 Communication media.
Day 26 Unguided media
Day 27 Data communication
Day 28 Digital and Analog Transmission,
Day 29 Asynchronous, and Synchronous Transmission
Day 30 Types of Computer Network
Day 31 Network Topology and its type(BUS,Star,Ring)
Day 32 Network Topology(Mesh,Tree).
Quiz/Assingment 3/ What is an API/Different Level Of
Day 33
Data Communication:
Day 34 History of internet,WWW
Day 35 ARPNET
Day 36 ARPNET
Day 37 ISP,Online service provider
Day 38 browsers,Function and features of browser
Day 39 Search engine
Day 40 E-Commerce ,business models
Day 41 types of E-Commerce(B2C, C2C, B2G)
Day 42 Information security and privacy
Day 43 Computer Virus and its type
Day 44 Frauds and scam
Day 45 Phishing & Pharming
Quiz/Assingment4 Cyber ethics/crime/Privacy issues/
Day 46 The Impact Of E-Commerce On Organizations/ E-
Commerce In Social Networking
Sub-Topics
Abacus,Napier’s Bone,Pascaline,Stepped Reckoner or Leibniz wheel
Analogue Computer
Digital Computer
Hybrid Computer
Hardware. Software. People. Procedures.Data.Connectivity.
Cache Memory,Primary Memory/Main Memory,Secondary Memory
Mouse,Keyboard,Scanner,Microphone,Joystick,Graphictablet
light pen,etc
Scanners,Bar-code Readers,MICR,OMR,OCR
Monitor,Printer,Headphones,Computer Speakers,Projector,GPS,Sound
Card,Video Card.
Impact printer(Dot impact printer,Daisy wheel printer,line printer)
Laser printers, Inkjet printers and Thermal printers
Monitor,LED,LCD
Word processing,Spreadsheet,Presentation,multimedia,webbrowser
Educational,Graphics,Freeware,Sharewear,Simulation,open source
closed source software(Skype,google Earth,)
Primary Storage Devices,Secondary Storage Devices,
Flash memory Devices. Optical Storage Devices,
Cloud and Virtual Storage.
RAID 0 (data striping),RAID 1 (data mirroring),RAID 5 (data striping and
parity),RAID 10 (data striping and mirroring)
Bluetooth adapter,CPU,GPU
Motherboard,Network card,RAM,Sound card,Video card
(Dump, Smart, Intelligent)
Elements ,Transaction Processing Systems.
Management Information System.
Decision Support Systems.
Office Automation Systems.
Register,CU,ALU,Main Memory Unit (Registers)
Instruction Cycle(MAR,MBR,PC,IR
Twisted Pair Cable,Co-axial cable,Fiber optic cable
Unbounded or Unguided or Wireless Communication Media.
Components(message,Sender,Reciver,Transmission medium,Protocol)
Types(Simplex,Half duplex,Full)
Channel
LAN,WAN,MAN,PAN,
History, What is UCCP,History of usenet
dial-up,DSL,Wireless Broadband,Wi-Fi Internet,ISDN,Ethernet
(Communication Services ,Entertainment Services,
Online Editing service,Google Services,Educational Services
,E-commerce,Information Retrieval Services)
Element of a Web Browser(User Interface,Browser Engine
Rendering engine,Networking,UI Backend,JavaScript Interpreter)
Day Topic
Day 1 overview
Day 2 Traditional File Based Systems
Day 3 Types of database
Day 4 DBMS Environment
Day 5 Three level architecture.
Day 6 Database Language
Day 7 Data Models
Day 8 Database Application Life Cycle
Day 9 Database administrator(DBA),Data Administrator(DA)
Day 10 Entity-Relationship Model
Day 11 Relationships in ER Model
Day 12 Existence Dependency
Day 13 Aggregation,Specialization&Generalization of
Day 14 ER models case Scenarios/Projects
keys,Relational database mangment system,Relational
Day 15
data integrity
Day 16 Intro to Normalization,Anomalies
Day 16 First normal Form,Functional depandence,2nd normal form
Day 17 Third normal form,Boyce-Codd Normal Form
Day 18 4th normal Form,Fifth Normal Form,Domain-Key Normal Form
Day 19
Day 20
Day 21
Day 22
Day 23
Day 24
Day 25
Day 26
Day 27
Day 28
Day 29
Day 30
Day 31
Day 32
Day 33
Day 34
Day 35
Day 36
Day 37
Day 38
Day 39
Day 40
Day 41
Day 42
Day 43
Day 44
Day 45
Sub-Topic
Data,Information,Types of data, Database,Characterstic(real world-entity),Relation-based tables
Isolation of data and application,Less redundancy,Consistency,Query Language,Users,Administrators,Designers,End
Users
Disadvantages,
Centralised database,Distributed database,object oriented database
Software,Hardware,Data,Procedure,Users.
Extternal,logical or conceptual,internal level
Data defination Language,Data Manipulation Language(Non-procedural DML,Procedural DML)
Data control language,Transaction Control Language.
Conceptual Data model,Physical data model.
Planning,requirments Analysis,Design,DBMS selection,Implementation,Maintenance
Function of The DBA
Advantages of E-R model,E-R diagram,Elements of ER model(Entities,
Attributes and its types,Identifier,Relationship
Degree of Relationship,Cardinality constraints.
Strong,weak entity,Assosiative Entity,
Supertype,Subtype
component of RDBMS(file manager,Database manager,Query processor,Data Dictionary,
DML pre-compiler,DDL Compiler.
Integrity (Entity Integrity,Domain integrity,Referntial integrity)
characterstics of normalization,Problem in entity/attributes,Problem associated with Data Redundancy
Update anomalies in 1NF,Transitive Dependency,
Multi-Valued Dependency
4 chapter
4pages
13th ch
(7page)
Days Topics
Day 1 Course Overview
Day 2 Traditional file system
Day 3 Database Enviornment
Day 4 Three level architecture.
Day 5 Data Models.
Multi User DBMS Architecture
Day 6
Day 7 Entity Relationship Model
Day 8 Relationship In ER model
Day 9 Specialization& Generalization and Aggregation in ER model.
Day 10 Case study
Day 11 Relational data model
Day 12 Introduction to Normalization,Anomalies
Day 13 First Normal form,2nd normal form
Transitive dependency,3rd normal form,
Day 14 Boyce-Codd normal form
Day 15 Multi-Valued Dependency, 4th normal,Fifth Normal Form
Client server Architecture
Day 16
Day 17 Three tier Architecture
Introduction to SQL
Day 18
Day 19 Rules of SQL Format,Data Types in SQL Server
Day 20 Categories of SQL Commands,Alter Table Statement
Day 21 Data Manipulation
ORDER BY Clause. Functions in SQL ,GROUP BY Clause
Day 22 HAVING Clause.Cartesian Product
Day 23 Inner Join,outer join,Semi Join,Self Join,Subquery
Hashing. Hash Functions. Hashed Access Characteristics. Mapping
Day 24 functions . Open addressing:
Processing Single table
Day 25
Day 26 Processing Multiple Tables
Day 27
Day 28 Tables, Index
Day 29 Views, Transactions
Day 30 Database Application Life Cycle
Day 31 database Planning and designing
Day 32 Database Security
Day 33 Distributed database System
Day 34 Distributed Database Mangment System
Day 35 Centralized Database
Day 36
Day 37
Day 38
Day 39
Day 40
Day 41
Day 42
Day 43
Day 44
Day 45
Day 46
Day 47
Day 48
Day 46
Day 47
Day 48
Subtopics
Data,Information,Database,Types of data,
Disadvantage.
Software,Hardware,Data,Procedure,Users.
Extternal,logical or conceptual,internal level
Conceptual(object based,Record base data model),Physical data Model.
Teleprocessing, File-Server,Client-Server
Advantage,ER diagram,Elements(Entities,Attributes)
Degree of Relationship,Cardinality Constraints
Relational data structure,Relational keys,Integrity constriants
steps in Normalization,Functional depandences,keys
1st and 2nd approches,Partial Functional dependency
File server Architecture,Limitation of file server,
Database server Architecture.,Advantage and Disadvantage of client Server
Architecture
Role of SQL in Db architecture,SQL environment
defining database in SQL(Creating Tabel,Removing.
Data Type(int,Biggint,Smallint,Tinyint,bit,Text,Money,Floating,Date….)
Inserting,Updating,deleting data,
Clauses of the Select Statement,Using Expression,Function,Wildcards
Comparison operator etc
Equi-Join,Natural join,Outer join,Subqueries,Correlated Subqueries
Virtual views,modify view,materialized view,Selection Index
Planing,system defination,Requirment analysis,implementation…
Database planning,Systems definition,Requirements collection and
analysis,Database design,DBMS selection,Application design
Prototyping,Implementation,Data conversion and loading
Testing,Operational maintenance
Authentication Rules,User defined Procedure,Encryption,Authentication
Schemes.
Option for DDB(Replication,Horizontal,Vertical partitioning,
combination of the above.
Location transparcy,replication,failure,Commit Protocol
Personal computer database,Client server database system
its advantage or disadvantage
OOAD IT-307
Day Topic
Day1
OOAD IT-307
Sub-Topic
