{"id":13,"title":"Database Management","credit_hour":"4","lecture_hour":"60","outcome":"<!DOCTYPE html>\r\n<html>\r\n<head>\r\n<\/head>\r\n<body>\r\n<ul>\r\n<li>Proficiency in the design of database applications starting from the conceptual design to the implementation of database schemas and user interfaces.<\/li>\r\n<li>Solid foundation on database design concepts, data models (E\/R model, relational model), the database query language SQL, and components of a database management system.<\/li>\r\n<li>Basic understanding of data access structures, query processing and optimization techniques, and transaction management.<\/li>\r\n<\/ul>\r\n<\/body>\r\n<\/html>","description":"<!DOCTYPE html>\r\n<html>\r\n<head>\r\n<\/head>\r\n<body>\r\nAn introduction to database design and the use of database management systems. The course includes detailed coverage of the development process, database architectural principles, relational algebra and SQL using Oracle or SQL Server. Other key database topics covered are data modelling (E-R model, relational data model, integrity constraints, data model operations, normalization, object oriented data modelling), database security, administration and distributed systems.<\/p>\r\n<\/body>\r\n<\/html>","books":"<!DOCTYPE html>\r\n<html>\r\n<head>\r\n<\/head>\r\n<body>\r\n<ol>\r\n<li><a href=\"https:\/\/www.amazon.com\/Database-Management-Mcfadden-Prescott-Hardcover\/dp\/B004WTCLBQ\" target=\"_blank\">Modern Database Management<\/em> by Jeffrey A. Hoffer, Mary B. Prescott, Fred R. Mcfadden<\/a><\/li>\r\n<li><a href=\"https:\/\/www.amazon.com\/Database-Management-Systems-Raghu-Ramakrishnan\/dp\/0072465638\" target=\"_blank\">Database Management System (3rd Edition)<\/em> by R. Ramakrishnan and J. Gehrke<\/a><\/li>\r\n<li><a href=\"https:\/\/www.amazon.com\/Introduction-Database-Systems-8th\/dp\/0321197844\" target=\"_blank\">An Introduction to Database System<\/em> by C. J. Date<\/a><\/li>\r\n<li><a href=\"https:\/\/www.amazon.com\/Fundamentals-Database-Systems-Ramez-Elmasri\/dp\/0133970779\" target=\"_blank\">Fundamentals of Database Systems<\/em> by Ramez Elmasri, Shamkant B. Navathe<\/a><\/li>\r\n<\/ol>\r\n<\/body>\r\n<\/html>","created_at":"2016-08-03 20:21:41","updated_at":"2017-01-26 16:35:27"} Details | Department of Computer Science and Engineering, IUB

CEN 401 + Lab: Database Management

Offered Under: B.Sc. in Computer Engineering (CEN)

Description

An introduction to database design and the use of database management systems. The course includes detailed coverage of the development process, database architectural principles, relational algebra and SQL using Oracle or SQL Server. Other key database topics covered are data modelling (E-R model, relational data model, integrity constraints, data model operations, normalization, object oriented data modelling), database security, administration and distributed systems.

Prerequisites:

CEN 203 + Lab : Data Structure

Course Type	Major
Credit Hour	4
Lecture Hour	60

Expected Outcome(s):

Proficiency in the design of database applications starting from the conceptual design to the implementation of database schemas and user interfaces.
Solid foundation on database design concepts, data models (E/R model, relational model), the database query language SQL, and components of a database management system.
Basic understanding of data access structures, query processing and optimization techniques, and transaction management.

Suggested Books:

Grading Policy:

Biweekly Quiz, Biweekly Programming Assignment, One Midterm Exam, One Final Exam

Letter Grade	Marks	Grade Point
A	90 - 100	4.00
A-	85 - 89	3.70
B+	80 - 84	3.30
B	75 - 79	3.00
B-	70 - 74	2.70
C+	65 - 69	2.30
C	60 - 64	2.00
C-	55 - 59	1.70
D+	50 - 54	1.30
D	45 - 49	1.00
F	00 - 44	0.00