FREE
AKTU Database Systems and Bioinformatics (BBI402) Syllabus PDF – B.Tech 2nd Year
Database Systems and Bioinformatics BBI402
All syllabus, notes, question bank & PYQ for this subject
Free
Download now
- English
- Semester 4
- 0 downloads
- 0 views
Official AKTU syllabus of Database Systems and Bioinformatics (BBI402) for B.Tech 2nd Year – 4 credits, L-T-P 3-1-0. Read the unit-wise course content, course outcomes, evaluation pattern and recommended books online, or download the PDF.
Syllabus — Database Systems and Bioinformatics
Download PDFBBI402 · 4 credits · L-T-P 3-1-0
Course Outcomes
At the end of course, the student will be able to understand
| CO 1 | Explain the basic concepts of database systems, architecture, and applications in computing. | K2 |
| CO 2 | Design conceptual models using the Entity-Relationship model and apply E-R to relational schema mapping. | K3 |
| CO 3 | Analyze relational model concepts, functional dependencies, and normalization techniques in database design. | K4 |
| CO 4 | Develop and execute SQL queries using various operations and constraints. | K2 |
| CP 5 | Understand the challenges and strategies of biological data integration in bioinformatics. | K3 |
Course Content
L-T-P: 3-1-0
| Unit | Topic | Proposed Lecture |
|---|---|---|
| I | INTRODUCTION: Database -System Applications- Purpose of Database Systems, View of Data, Database Languages, introduction to Relational Databases, Database Design, Data Storage and Querying, Transaction Management, Database Architecture, Database Users and Administrators, History of Database Systems. | 08 |
| II | DATABASE DESIGN AND THE E-R MODEL : Overview of the Design Process, The Entity- Relationship Model, Constraints, Removing Redundant Attributes in Entity Sets, Entity- Relationship Diagrams, Reduction to Relational Schemas, Entity- Relationship Design Issues, Extended E-R Features, Alternative Notations for Modeling Data, Other Aspects of Database Design. | 08 |
| III | RELATIONAL MODELAND ITS DESIGN TECHNIQUE: Introduction to the Relational model: Structure of Relational Databases, Database Schema, Keys, Schema Diagrams, Relational Query Languages, Relational Operations. Relational Database Design: Features of Good Relational Designs, Atomic Domains and First Normal Form, Decomposition Using Functional Dependencies, Functional- Dependency Theory, Algorithms for Decomposition, Decomposition Using Multivalued Dependencies, More Normal Forms, Database- Design Process, Modeling Temporal Data. | 08 |
| IV | STRUCTURED QUERY LANGUAGE: Overview of the SQL Query Language, SQL Data Definition, Basic Structure of SQL Queries, Additional Basic Operations, Set Operations, Null Values, Aggregate Functions, Nested Subqueries, Modification of the Database. | 08 |
| V | BIOLOGICAL DATA BASE MANAGEMENT: Introduction to Biological Data Integration - specifications. - Challenges Faced in the Integration of Biological Information: - Nature of Biological data,- Data sources in Life Sciences, - Challenges in information integration-. Data management in Bioinformatics, Dimensions -Describing the Space of Integration Solutions. | 08 |
Text Books
- Raghu Ramakrishnan, Johannes Gehrke, “Database Management System”,McGrawHill,3rdEdition2003
- Elmashri & Navathe, “Fundamentals of Database System”, Addison-Wesley Publishing,3rdEdition,2000
- DateC.J,“AnIntroductiontoDatabase”,Addison-WesleyPubCo,7th Edition, 2001
- Jeffrey D. Ullman, Jennifer Widom, “A First Course in Database System”, Prentice Hall, AWL 1st Edition, 2001
- PeterRob, Carlos Coronel, “Database Systems- Design, Implementation, and Management”,4th Edition,ThomsonLearning,2001.
- Zoe Lacroix, Terence Critchlow,” Bioinformatics: Managing Scientific Data”,Morgan Kaufmann Publishers (Elsevier Science), 2003
Ratings & Reviews
No reviews yet — share your experience with this item.