MCS 2nd Semester
- Teacher: Dr Junaid Baber
MCS 2nd Semester
- Teacher: Dr Muhammad Sajid
This is a 4 credit course on database systems. The contents of the course are as follows:
- Basic database concepts
- Database approach vs file based system
- Three level schema architecture
- relational data model
- attributes
- schemas
- tuples
- domains
- relation instances
- keys of relations
- integrity constraints
- relational algebra
- Selection
- Projection
- Cartesian product
- Types of joins
- inner join
- left join
- right join
- Normalization
- functional dependencies
- normal forms
- Entity relationship model
- entity sets
- attributes
- relationship
- entity-relationship diagrams
- Structured Query Language (SQL)
- Joins and sub-queries in SQL
- Grouping and aggregation in SQL
- Concurrency control
- Database backup and recovery
- Indexes
- NoSQL systems
- Teacher: Imran Ali