[SEN-220] Database Management Systems - BSCS 4A Fall 2012

BSCS 4A, Fall 2012 Bahria University Islamabad

Database Management Systems

 

Course Name:              Database Management Systems

Course Title:                SEN-220

Pre-requisite:                 SEN-141

Credit Hours:                4 (3 Class +1 Lab)

Semester:                      4^th

Instructor:                     Ms. Aliya Aziz

Institute:                        Bahria University, Islamabad

Helping Website:           bilawalsheikh333.blogspot.com

No.#	Available Data	Available Format Details	Click to Download
1	Course Contents	docx, pdf	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	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	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	docx docx docx docx docx docx docx
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	Zip File Zip File pptx docx,pdf docx,pdf docx,pdf docx pptx pptx pptx docx docx docx,pdf docx docx  --- docx docx xlsx Zip File docx docx 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	RAR File latter exe 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	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	docx pptx 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	pdf

Write Your Queries & Comments: (or Mail @ bilawal.sheikh333@gmail.com)