Scribd Logo
Upload

Welcome to Scribd!

    • 102 views

    B. Sc. (Information Technology) Semester - III

    Uploaded by

    Sony Tiwari
    This document provides information about the B.Sc. (Information Technology) Database Management Systems course offered in Semester III. The course is worth 2 credits and involves 5 periods per week, with each period being 50 minutes. Students will be evaluated based on a theory examination worth 75 marks and internal evaluation worth 25 marks. The course is divided into 5 units that cover topics such as database concepts, data models, relational database design, SQL, transaction management, and PL/SQL. Required textbooks for the course are also listed.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    B. Sc. (Information Technology) Semester - III

    Uploaded by

    Sony Tiwari
    102 views2 pages
    This document provides information about the B.Sc. (Information Technology) Database Management Systems course offered in Semester III. The course is worth 2 credits and involves 5 periods per week, with each period being 50 minutes. Students will be evaluated based on a theory examination worth 75 marks and internal evaluation worth 25 marks. The course is divided into 5 units that cover topics such as database concepts, data models, relational database design, SQL, transaction management, and PL/SQL. Required textbooks for the course are also listed.

    Original Description:

    Syllabus

    Original Title

    DBMS Syllabus

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides information about the B.Sc. (Information Technology) Database Management Systems course offered in Semester III. The course is worth 2 credits and involves 5 periods per week, with each period being 50 minutes. Students will be evaluated based on a theory examination worth 75 marks and internal evaluation worth 25 marks. The course is divided into 5 units that cover topics such as database concepts, data models, relational database design, SQL, transaction management, and PL/SQL. Required textbooks for the course are also listed.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    102 views2 pages

    B. Sc. (Information Technology) Semester - III

    Uploaded by

    Sony Tiwari
    This document provides information about the B.Sc. (Information Technology) Database Management Systems course offered in Semester III. The course is worth 2 credits and involves 5 periods per week, with each period being 50 minutes. Students will be evaluated based on a theory examination worth 75 marks and internal evaluation worth 25 marks. The course is divided into 5 units that cover topics such as database concepts, data models, relational database design, SQL, transaction management, and PL/SQL. Required textbooks for the course are also listed.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    B. Sc.

    (Information Technology) Semester – III


    Course Name: Database Management Systems Course Code: USIT304
    Periods per week (1 Period is 50 minutes) 5
    Credits 2
    Hours Marks
    Evaluation System Theory Examination 2½ 75
    Internal -- 25

    Unit Details Lectures


    I Introduction to Databases and Transactions
    What is database system, purpose of database system, view of data,
    relational databases, database architecture, transaction management
    Data Models
    The importance of data models, Basic building blocks, Business rules,
    12
    The evolution of data models, Degrees of data abstraction.
    Database Design, ER Diagram and Unified Modeling Language
    Database design and ER Model: overview, ER Model, Constraints, ER
    Diagrams, ERD Issues, weak entity sets, Codd’s rules, Relational
    Schemas, Introduction to UML
    II Relational database model:
    Logical view of data, keys, integrity rules, Relational Database design:
    features of good relational database design, atomic domain and
    Normalization (1NF, 2NF, 3NF, BCNF).
    Relational Algebra and Calculus
    12
    Relational algebra: introduction, Selection and projection, set
    operations, renaming, Joins, Division, syntax, semantics. Operators,
    grouping and ungrouping, relational comparison.
    Calculus: Tuple relational calculus, Domain relational Calculus,
    calculus vs algebra, computational capabilities
    III Constraints, Views and SQL
    Constraints, types of constrains, Integrity constraints, Views:
    Introduction to views, data independence, security, updates on views, 12
    comparison between tables and views SQL: data definition, aggregate
    function, Null Values, nested sub queries, Joined relations. Triggers.
    IV Transaction management and Concurrency
    Control Transaction management: ACID properties, serializability and
    concurrency control, Lock based concurrency control (2PL, 12
    Deadlocks), Time stamping methods, optimistic methods, database
    recovery management.
    V PL-SQL: Beginning with PL / SQL, Identifiers and Keywords,
    Operators, Expressions, Sequences, Control Structures, Cursors and
    Transaction, Collections and composite data types, Procedures and 12
    Functions, Exceptions Handling, Packages, With Clause and
    Hierarchical Retrieval, Triggers.

    10

    https://E-next.in
    Books and References:
    Sr. No. Title Author/s Publisher Edition Year
    1. Database System and A Silberschatz, McGraw- Fifth
    Concepts H Korth, S Hill Edition
    Sudarshan
    2. Database Systems Rob Coronel Cengage Twelfth
    Learning Edition

    3. Programming with PL/SQL H. Dand, R. Patil X –Team First 2011


    for Beginners and T. Sambare
    4. Introduction to Database C.J.Date Pearson First 2003
    System

    11

    https://E-next.in

    You might also like