CE263: Database Management System
Course Outcome
CO-1 :Apply the concepts of engineering i.e collecting data, organize the data in the systematic form, and arrange the data in a computational way and applying mathematics formation.
CO-2 :Analyse how data are stored and maintained using data models. Ready to assimilate the concept of data abstraction and design queries using SQL. Identify how data is represented in the relational model and create relations using SQL language .
CO-3: Identify and evaluate the constructs in the E-R model and issues involved in developing an E-R diagram. Convert an E-R diagram into a relational database schema. Declare and enforce integrity constraints on database using a state-of-art RDBMS.
CO-4:Produce aggregate operators to write SQL queries which are not expressible in relational algebra. “More mathematical” notation may apply and also used in research and other venues. Combining these concepts allows production of sophisticated queries .
CO-5: Decompose un-normalized tables into normalized compliant tables. Design and implement a normalize database schema for a given problem-domain. Produce strategies to minimise risks of security breaches in a range of network environments and data storage systems. Compute retrieval time and concluding with suitable indexing technique .
CO-6: Compare transactions and their properties with (ACID) and without ACID. Apply locking protocol to ensure isolation. Develop logging technique to ensure atomicity and durability. Design a logical view which can be used for analytical tasks. Develop practical experience of the design and implement scalable, secure databases .
Teaching and Examination Scheme
Resource Person