B23-CAP-303 Data Base Technologies
| Part A – Introduction | |||||
| Subject | BCA | ||||
| Semester | III | ||||
| Name of the Course | Data Base Technologies | ||||
| Course Code | B23-CAP-303 (Common with B23-CAI-303, B23-CDS- 303, B23-CTS-303) | ||||
| Course Type: (CC/MCC/MDC/CC- M/DSEC/VOC/DSE/PC/AEC/ VAC) | CC | ||||
| Level of the course (As per Annexure-I | 100-199 | ||||
| Pre-requisite for the course (if any) | Basic Knowledge of computer | ||||
| Course Learning Outcomes(CLO): | After completing this course, the learner will be able to:
1. understand the concepts of problem solving on computer 2. understand the basics of C programming along with various I/O functions 3. understand various operators and branching statements in C 4. understand loops, functions and arrays in C
5*. to design programs based on theoretical concepts of C. |
||||
| Credits | Theory | Practical | Total | ||
| 3 | 1 | 4 | |||
| Contact Hours | 3 | 2 | 5 | ||
| Max. Marks:100(70(T)+30(P))
Internal Assessment Marks:30(20(T)+10(P)) End Term Exam Marks: 70(50(T)+20(P)) |
Time: 3 Hrs.(T), 3Hrs.(P) | ||||
| Part B- Contents of the Course | |||||
| Instructions for Paper- Setter | |||||
| Unit | Topics | Contact Hours | |||
| I | Basic Concepts – Data, Information, Records, Files, Schema and Instance etc. Limitations of File Based Approach, | 10 | |||
| Characteristics of Database Approach, Database Management System (DBMS), Components of DBMS Environment, DBMS Functions and Components, Database Interfaces, Advantages and Disadvantages of DBMS.
Database Users: Data and Database Administrator, Role and Responsibilities of Database Administrator, Database Designers, Application Developers etc. Database System Architecture – 1-Tier, 2-Tier & Three Levels of Architecture, External, Conceptual and Internal Levels, Schemas, Mappings and Instances, Data Independence – Logical and Physical Data Independence. |
||
| II | Data Models: Hierarchical, Network and Relational Data Models.
Entity-Relationship Model: Entity, Entity Sets, Entity Type, Attributes: Type of Attributes, Keys, Integrity Constraints, Designing of ER Diagram, Symbolic Notations for Designing ER Diagram, |
10 |
| III | SQL: Meaning, Purpose and Need of SQL, Data Types, SQL Components: DDL, DML, DCL and DQL, Basic Queries,
Join Operations and Sub-queries, Views, Specifying Indexes. Constraints and its Implementation in SQL. Relational Algebra: Basic Operations: Select, Project, Join, Union, Intersection, Difference, and Cartesian Product etc. Relational Calculus: Tuple Relational and Domain Relational Calculus. Relational Algebra Vs. Relational Calculus. |
10 |
| IV | Relational Model: Functional Dependency, Characteristics, Inference Rules for Functional Dependency, Types of Functional Dependency,
Normalization: Benefits and Need of Normalization, Normal Forms Based on Primary Keys- (1NF, 2NF, 3NF, BCNF), Multi-valued Dependencies, 4 NF, Join dependencies, 5 NF, Domain Key Normal Form. |
10 |
| V* | The following activities be carried out/ discussed in the lab during the period of the semester.
Programming Lab: · Performing various SQL statement. Creating various tables and performing all possible queries based on syllabus. · Understanding relational model concepts · Understanding normalization · Understanding various concepts of databases. |
25 |
| Suggested Evaluation Methods | ||
| Internal Assessment:
➢ Theory · Class Participation: 5 · Seminar/presentation/assignment/quiz/class test etc.: 5 · Mid-Term Exam: 10 |
End Term Examination:
A three hour exam for both theory and practicum. |
|
| ➢ Practicum
· Class Participation: 5 · Seminar/Demonstration/Viva-voce/Lab records etc.: 5 · Mid-Term Exam: NA |
|
| Part C-Learning Resources | |
| Recommended Books/e-resources/LMS:
· Elmasri & Navathe, Fundamentals of Database Systems, Pearson Education. · A Silberschatz, H Korth, S Sudarshan, Database System and Concepts, McGraw-Hill. · Thomas Connolly Carolyn Begg, Database Systems, Pearson Education. · C. J. Date, An Introduction to Database Systems, Addison Wesley. |
|
