Scribd Logo
Upload

Welcome to Scribd!

    • 13 views

    Syllabus - DBMS

    Uploaded by

    krishsatasiya44

    Copyright:

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

    Syllabus - DBMS

    Uploaded by

    krishsatasiya44
    13 views3 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Syllabus - DBMS

    Uploaded by

    krishsatasiya44

    Copyright:

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

    SILVER OAK UNIVERSITY

    College of Technology
    Bachelor of Technology
    Computer Engineering (Artificial Intelligence and Machine Learning)
    Course Name: Database Management Systems
    Course Code: 1010043223
    Semester: 3rd

    Prerequisite:
    1. Basic knowledge of Computer Programming

    Course Objectives:
    1. Database is an integral part of real-life application systems. The course will enable students to understand
    the different issues involved in the design and implementation of a database system. Students will learn
    the physical and logical database designs, database modeling, relational, hierarchical, and network
    models.
    2. Students will learn to use data manipulation language to query, update, and manage a database. Students
    will understand essential DBMS concepts such as: database security, integrity, concurrency, storage
    strategies etc. The students will get the hands-on practice of using SQL and PL/SQL concepts.

    Teaching Scheme:

    Teaching Scheme
    L T P Contact Hours Credit
    4 0 4 8 6

    Contents:

    Unit Topics Teaching % Weightage


    Hours
    1 Database system architecture: 3 5%
    Data Abstraction, Data Independence, Data Definition Language
    (DDL), DataManipulation Language (DML).
    2 Data models: 5 12%
    Entity-relationship model, network model,relational and object
    oriented data models, integrity Constraints, data manipulation
    operations.
    3 Relational query languages: 4 8%
    Relational algebra, Tuple and domain relational calculus, SQL3, DDL
    and DML constructs, Open source and Commercial DBMS -
    MYSQL, ORACLE, DB2, SQL server.
    4 Relational database design: 4 10%
    Domain and data dependency, Armstrong's axioms, Normal forms,
    Dependency preservation, Lossless design.
    5 Query processing and optimization: 5 10%
    Evaluation of relational algebra expressions, Query equivalence, Join
    strategies, Query optimization algorithms.
    6 Storage strategies: 4 7%
    Indices, B-trees, hashing
    7 Transaction processing: 4 15%
    Concurrency control, ACID property, Serializability of scheduling,
    Locking and timestamp based schedulers, Multi-version and
    optimistic Concurrency Control schemes, Database recovery.
    8 Database Security: 4 7%
    Authentication, Authorization and access control, DAC, MAC and
    RBAC models, Intrusion detection, SQLinjection.
    9 SQL Concepts: 7 18%
    Basics of SQL, DDL,DML,DCL, structure – creation, alteration,
    defining constraints – Primary key, foreign key, unique, not null,
    check, IN operator, aggregate functions, Built-in functions – numeric,
    date, string functions, set operations, sub-queries, correlated
    sub-queries, join, Exist, Any, All , view and its types., transaction
    control commands.
    10 PL/SQL Concepts: 3 8%
    Cursors, Stored Procedures, StoredFunction, Database Triggers

    Course Outcomes:

    Sr. No. CO Statement Unit

    CO-1 Recognize the various elements of Database Management Systems 1,2


    Given a problem statement, identify the entities and their relations and draw
    CO-2 3,4
    an E-R diagram and design database applying normalization
    Solve the given problem using Relational Algebra, Relational Calculus, SQL
    CO-3 5,7,9,10
    and PL/SQL
    Apply and relate the concepts of transaction, concurrency control, recovery
    CO-4 6,7,8
    and security in database
    Recognize the purpose of query processing, optimization and demonstrate the
    CO-5 8,9,10
    SQL query evaluation

    Teaching & Learning Methodology:

    The various methods or tools follows by the faculties to teach the above subject are:
    1. The course includes a laboratory, where students have an opportunity to build an appreciation for
    the concepts being taught in lectures.
    2. Lectures with live practical examples using Projector and Computer.
    3. Experiments shall be performed in the laboratory related to course contents.

    List of Experiments: Total Hours: 56

    Sr. No. Practical Name


    1 To study DDL-create and DML-insert commands.
    2 Create table and insert sample data in tables.
    3 Create a Table with Constraints.
    Ø Required data constraints/Null Constraints
    Ex: In the student database, every student must have an associated student name.
    Student_name should not be NULL.Ø Check Constraints
    Ex: Customer table having name and gender which can be M or F.Ø Primary Key Constraints
    Ex: Employee table having Emp_id which must be a Primary key.
    4 Perform queries involving predicates LIKE, BETWEEN, IN etc.
    5 To perform various data manipulation commands, aggregate functions and sorting concept on
    all created tables.
    6 To study Single-row functions.
    7 Displaying data from Multiple Tables (join)
    8 To apply the concept of Aggregating Data using Group functions.
    9 To solve queries using the concept of sub query. 10. To apply the concept of
    security and privileges.
    10 To study Transaction control commands.
    11 DDL Command: Alter table: add column, remove column, add constraint, remove constraint,
    Drop table
    12 Write Cursor. 14. Write Trigger.
    13 Design a database for Online Examination.
    14 Design a database for Online Attendance System.

    Books Recommended:
    1. List of Open “Database System Concepts”, 6th Edition by Abraham Silberschatz, Henry F. Korth, S.
    Sudarshan, McGraw-Hill.
    2. “Fundamentals of Database Systems”, 7th Edition by R. Elmasri and S. Navathe, Pearson.
    3. “An introduction to Database Systems”, C J Date, Pearson.
    4. “Modern Database Management”, Hoffer , Ramesh, Topi, Pearson.
    5. “Principles of Database and Knowledge – Base Systems”, Vol 1 by J. D. Ullman, Computer Science
    Press.
    6. “Understanding SQL”, Martin Gruber, BPB
    7. “SQL- PL/SQL”, Ivan bayross

    List of Open-Source Software/learning website:


    1. http://silveroakuni.ac.in/video-lecture
    2. https://nptel.ac.in/
    3. https://nptel.ac.in/courses/106/105/106105175/

    You might also like