Detailed Syllabus Page 64 of 241 and Normalization Techniques created exams / Quiz CO3 Apply principles of entity-relationship modeling and normalization techniques to design efficient and well-structured databases that meet specified requirements.
Ap P Practical Assignment / Observation of Practical Skills CO4 Acquire expertise in crafting and executing SQL queries for the retrieval, updating, and manipulation of data, showcasing adept skills in database querying and data manipulation Ap p Practical Assignment / Observation of Practical Skills CO5 Comprehend and apply strategies for managing transactions and implementing mechanisms for controlling concurrency, ensuring the database's consistency and reliability in environments with multiple users.
Ap P Practical Assignment / Observation of Practical Skills CO6 Explore and analyze recent trends in database management systems, with a focus on unstructured databases, NoSQL technologies An P Practical Assignment / Observation of Practical Skills * - Remember (R), Understand (U), Apply (Ap), Analyse (An), Evaluate (E), Create (C) # - Factual Knowledge(F) Conceptual Knowledge (C) Procedural Knowledge (P) Metacognitive Knowledge (M) Module Unit Content Hrs (45+30) Mark I Database System- Concept 10 15 1 Introduction, Characteristics of the Database Approach 2 2 Actors on the Scene, Workers behind the Scene, Advantages of Using the DBMS Approach, File system vs Database 2 3 Data Models, Schemas, and Instances, Three-Schema Architecture and Data Independence 3 4 Database Languages and Interfaces 2 5 Structured, Semi Structured and Unstructured Database 1 II Database Design 14 20 6 ER Model- Basic concepts, entity set & attributes, notations 2 7 Relationships and constraints, cardinality, participation, notations, weak entities 2 8 Relational Model Concepts-Domains, Attributes, Tuples, and Relations, Values and NULLs in the Tuple 2 9 Relational Model Constraints and Relational Database Schemas 2 10 Relational Database Design- Atomic Domain and Normalization- INF, 2NF,3NF, BCNF 4 11 4NF,5NF 2 III Query Languages 11 20 12 SQL-, introduction to Structured Query Language (SQL) 1 13 Data Definition Language (DDL), Table definitions and operations 2 14 SQL DML (Data Manipulation Language) - SQL queries on 4