Data Base Management Systems n Course Objectives and

Data Base Management Systems n Course Objectives and Course Outcomes n Course Outline n Assessment Strategy

Course Objectives and Course Outcomes Course Objectives: 1. To define and summarize the basic concepts of database management system. 2. To understand basic operations with DBMS. 3. To apply various data models to describe the structure of the database. 4. To develop database design using normalization 5. To understand optimization. concurrency control mechanism and query Course Outcomes 1. Explain basic concepts of database management system. 2. Perform basic operation with DBMS. 3. Design and develop database application using ER diagram and normalization. 4. Handle various concurrency and recovery issues. 5. Optimize the performance of database

Course Outline n Purpose of Database Systems n Database Languages n Relational Databases n Database Design n Data Models n Database Internals n Database Users and Administrators n Overall Structure n History of Database Systems

Database Concepts n Database is a collection of inter-related data n Database Management System (DBMS) is a set of programs to use and / or modify this data n A computer based systematic record keeping system

Database Management System (DBMS) n DBMS contains information about a particular enterprise l Collection of interrelated data l Set of programs to access the data l An environment that is both convenient and efficient to use n Database Applications: l Banking: all transactions l Airlines: reservations, schedules l Universities: registration, grades l Sales: customers, products, purchases l Online retailers: order tracking, customized recommendations l Manufacturing: production, inventory, orders, supply chain l Human resources: employee records, salaries, tax deductions n Databases touch all aspects of our lives

Assessment Strategy- Theory Assignment Problem statement UPS prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, UPS relies on a company-wide information system. Shipped items are the heart of the UPS product tracking information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the UPS system at a single retail center. Retail centers are characterized by their type, unique. ID, and address. Shipped items make their way to their destination via one or more standard UPS transportation events (i. e. , flights, truck deliveries). These transportation events are characterized by a unique schedule. Number, a type (e. g, flight, truck), and a delivery. Route. Please create an Entity Relationship diagram that captures this information about the UPS system. Be certain to indicate identifiers and cardinality constraints.

Assessment Rubrics- Theory Assignment Criteria Excellent (2 M) Good(1. 5 M) Poor (1 M) Identification of Entities All entities identified Partial entities identified At least two entity identified Identification relations All relations identified Partial relations identified One relation identified Identification of key attribute for all entities All key attributes identified Some key One key attributes identified Identification of all other relevant attributes For all entities all relevant attributes identified For all entities few Few relevant attributes identified ER diagram with all attributes including primary keys Correct diagram with all correct notations including primary key Correct diagram but key attributes representation missing Total 10 7. 5 Incorrect ER diagram 5