Database Management Systems
10:44 PM
By
itian
Database Management Systems
Course Name: Database
Management Systems
Course Title: SEN-220
Pre-requisite: SEN-141
Credit
Hours: 4 (3 Class +1
Lab)
Semester: 4th
Instructor: Ms. Aliya Aziz
Institute: Bahria
University, Islamabad
Helping
Website: bcsnit.blogspot.com
No.#
|
Available
Data
|
Available
Format Details
|
Click to Download
|
1
|
Course Contents
|
docx,
pdf
|
|
2
|
Main
Topics
Till Mid Term Exam
Till Final Term Exam
|
pptx, pdf
pptx, pdf
|
---
---
|
3
|
Lecture Slides
Lecture 1-Introduction to Databases
Lecture 2-a) DBMS Architecture
Lecture 2-b) The Three Level Architecture
Lecture 3-Database Systems
Lecture 4-SQL Language - I
Lecture 5-a) SQL Language – II
Lecture 5-b) SQL (Creating Database)
Lecture 6-Entity Relationship Modeling
Lecture 7-Data Modeling Using Entity
Relationship
Lecture 8-Enhanced E-R Model & Business
Rules
Lecture 9-a) Logical Database Design &
Relational Model
Lecture 9-b) Project Requirements (Intro.
to Mini World)
Lecture 10-Referential Integrity &
Foreign Key
Lecture 11-Relational Model &
Relational Database Constraints
Lecture 12-a) Relational Algebra
Lecture 12-b) JOIN (Tutorial)
Lecture
13-GROUP By
Lecture 14-a) Relational Algebra Queries
Lecture 14-b) Mapping
Lecture 15-Normalization
Lecture 16-SQL Important Queries
|
pptx,pdf
pptx,pdf
pptx,pdf
pptx,pdf
pptx,pdf
pptx,pdf
pdf,
pptx,pdf
pptx,pdf
pptx,pdf
pptx,pdf
pptx,pdf
pptx,pdf
pptx,pdf
pptx,pdf
xlsx,
pptx,pdf
pptx,pdf
pptx,pdf
pptx,pdf
pptx,pdf
|
|
4
|
Lecture
Notes
01 - The Three Level
Architecture
02 - The Entity-Relationship
Model
03 - DBMS Important Link
Lecture 6
04 - What are Entity
Relationship Diagrams
05 - DBMS Helping Material for
Projects
06 - Semantic Gap
07 - Data Modeling Using The
Entity-Relationship Model
08 - SQL (Creating Database)
Lecture Notes All Updates |
docx,
pdf,
docx,
docx,
docx,
docx,
pdf,
docx,
Zip File
|
|
5
|
Assignments
Assignment No.#1
Demo (A No.#1)
Assignment No.#2
Demo (A No.#2)
Assignment No.#3
Demo (A No.#3)
Demo (A No.#4)
|
docx,pdf
docx,pdf
docx,pdf
docx,pdf
docx,pdf
docx,pdf
docx,pdf
|
|
6
|
DBMS
Lab
Lab Reports
Lab Work
Lab Lectures
DBMS Lab-1 (a) Introduction to DBMS Lab
DBMS Lab-1 (b) (MS Access)
DBMS Lab-2 (MS Access)
DBMS Lab-3 (MS Access)
DBMS Lab-4 (a) (Structured Query Language (SQL))
DBMS Lab-4 (b) (Installing MySQL 5.1)
DBMS Lab-4 (c) (MySQL - Would You Like Transaction)
DBMS Lab-4 (d) (SQL)
DBMS Lab-5 (Single Row Number Functions)
DBMS Lab-6 (SQL Modification Statements)
DBMS Lab-7 (Introduction to Oracle)
DBMS Lab-8 (Single Row Character Functions)
DBMS Lab-9
DBMS Lab-10 (Mid Term Exam)
DBMS Lab-11
DBMS Lab-12
DBMS Lab-13 (JOINS)Lab Lectures (FULL)
Lab Journal (Full)
Lab Tasks/Assignments/ Quizzes
Lab Project (CGPA Calculator)
Lab Helping Material
|
Zip File Zip File pptx docx, pdf docx, pdf docx, pdf docx pptx pptx pptx docx docx docx,pdf docx docx txt docx docx xlsx Zip File docx,pdf docx,pdf xlsx Zip File |
|
7
|
Soft wares
1-Dreamweaver CS3 Compact Setup
2-MySQL - 5.1.61- win 32
3-Wamp Server 2.2 (e-php5.3.13-httpd 2.2.22-mysql
5.5.24-32b)
|
RAR File
exe File
Zip
File
|
|
8
|
Books
1-Database Solutions (A Step by
Step Guide to Building Database, 2nd Ed. by Thomas Connolly)
2-Database System Concepts, 4th
Ed. by Silberschatz,
Korth
3-Database
Management System, 5th Ed. Solution, by Ramez Almesari
4-SQL (All in One) For Dummies,
2nd Ed., by Allen G.
Taylor
5-Fundamentals of Database
Systems, 3rd Edition by Ramez Elmasri and Shamkant B. Navathe
|
pdf
pdf
pdf
pdf
pdf
|
|
9
|
Helping Materials
E-Books Slides (pptx)
E-Books Lectures
(docx,pdf)
|
Zip
File
Zip
File
|
latter
latter |
10
|
Project
Project / Presentation Title (School Database Management System)
Project Proposal
Project Presentation
Project SQL Table
Project (Full)
Extra Full Project (DBMS
Project (1) - Gandhara Logistics)
Extra Full Project (DBMS
Project (2) - School Database System)
Extra Full Project (DBMS
Project (3) - Bus Reservation System)
Extra Full Project (DBMS Project
(4) - Construction Company)
Extra Full Project (DBMS
Project (5) - Library)
Extra Full Project (DBMS
Project (6) - Magazine)
|
docx,
pptx, pdf
txt
Zip File
Zip File
Zip File
pdf
Zip File
Zip File
Zip File
|
|
11
|
Result
Mid Term (Internals)
Final Term (Externals)
|
gif
txt
|
|
12
|
Database Management Systems –
Full Course Lecture Slides – BSCS 4A, Fall 2012 – Bahria University, Islamabad
|
pptx, pdf
|
Written by Admin
ChromeGT is a modern, powerful and professional Blogger template made for your Portfolio, Business or almost any other kind of website.
.jpg){kind=small}
0 comments :