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.
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.
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.
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.
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.
After completion of the course student will be able to:
This subject is on page 11 of the original AKTU PDF.
