Database Management

Purbanchal University BBA V Semester LH: 48 Course Title: Database Management Area of Study: Core Credit Hours: 3 Course Code: IT 355 Course Objectives: This course introduces the principles of database management systems (DBMS) and covers the design, implementation, and management of databases. It emphasizes the use of SQL for data manipulation and explores various types of database architectures. Course Contents: Unit 1: Introduction to Database Systems LH6 • Overview of database systems • Importance and applications of databases • Database System Vs. File System • Purpose and Advantages of Database Systems • Types of database systems : hierarchical, network, relational, and object-oriented • Components of a database system Unit 2: Database Design LH 8 • Database design concepts and terminology • Principles of Database Design • Functional Dependencies • Entity-Relationship (ER) modeling • Converting ER diagrams to relational schema • Normalization : 1NF, 2NF, 3NF, BCNF Unit 3: Structured Query Languages (SQL) LH 12 • Introduction to SQL and its syntax • Data Definition Language (DDL) commands • Data Manipulation Language(DML) commands • Basic SQL Queries : CREATE, SELECT, INSERT, UPDATE, DELETE, COUNT, GROUP BY, SUM, ORDERBY, DROP, ALTER, CHECK, UPDATE, MIN,MAX,HAVING • SQL Functions and Expressions • Sub queries and nested queries • Views and indexes • SQL Constraints and Keys Unit 4: Database Management and Administration LH 6 • Roles and responsibilities of a database administrator • Backup and recovery strategies • Database security and access control • Performance tuning and optimization techniques Unit 5: Database Security LH 6 • Database Security and Integrity • Authentication and Authorization • Security Models and Policies • Encryption Techniques Unit 6: Query Processing LH 4 • Introduction to Transaction, ACID property and concurrency control • Query Optimization Techniques • Step in query Processing Unit 7: IT Governance and Ethics LH 6 • Cloud database and database as a service (DBaaS) • Big data technologies and their impact on database • Database management in the context of IoT • Future trends in database systems Reference Books: 1. Rob, P., & Coronel, C. (2018), Database Systems: Design, implementation & management (13th ed.), Cengage Learning 2. Elmasri, R., & Navathe, S.B. (2016), Fundamentals of database systems (7th ed.), Pearson 3. Coronel, C., & Morris, S. (2015), Database design using UML and SQL (3rd ed.), Cengage Learning. 4. Sadalage, P. J., & Fowler, M. (2013), NoSQL distilled: A brief guide to the emerging world of polyglot persistence, Addison-Wesley 5. Immon, W.H., & Imhoff, C. (2005), Corporate information factory (2nd ed.), Wiley. 6. Gupta, A. (2017), Fundamentals of database management systems, Cambridge University Press
PURBANCHAL UNIVERSITY
2025
Bachelor of Business Administration (BBA)/Fifth Semester/Final Time: 03:00 hrs Full Marks: 60 /Pass Marks: 24 IT 355: Database Management System (New Course) Candidates are requires to give their answers in their own words as far as practicable. Figures in the margin indicates full marks. Group A Case Study: 1×10=10 1. Design an Entity –Relationship (ER) diagram for a School Management System that keeps track of students, teachers, classes and subjects. Each student has a unique student ID, name, age, gender, and contact number. Students are assigned to a class , and each class has a class ID, name, subject specialization, and contact number. A teacher can teach multiple subjects, and a subject can be taught by mutliple teachers. The system also records the subject ID, subject name, and number of periods per week. Additionally, students can enroll in multiple subjects, and their performance is recorded with marks obtained in each subject. Create an ER diagram showing the entities, their attributes, and the relatonships between them. Convert ER diagram to relations. Group B Answer any SEVEN questions. 7x5=35 2. Consider the following "CUSTOMER" table:
Cust_Id Cust_Name Address Contact No.
C005 Rakesh Birgunj 9852011111
C010 Mahesh Nepalgunj 9862022222
C012 Aniket Butwal 9805033333
C020 Hitesh Pokhara 9812344444
C025 Mandip Birgunj 9842055555
C028 Hari Pokhara 9842166666
Write SQL query to: (a) Create the above table with primary key "Cust_id". (b) Insert the given set of data in the table. (c) Display Customer Names and contact numbers whose adress starts with 'B'. 3. Explaun the different types of database systems in detail. 4. Distinguish between DDL and DML with two examples of each. 5. Discuss the different data recovery strategies. 6. Define functional dependency and normalization. Why is normalization done? 7. Explain anyone security model for database security. 8. Discuss performance tuning. Write the strategies for performance tuning. 9. What is transaction? Define the ACID properties of a transaction. 10. What are cloud databases and databases as a service(DBaaS)? Group C Answer the questions. 5x3=15 11. Write short notes on the database and DBMS. 12. Write short notes on entity and attribute. 13. Discuss about SQL functions with examples. 14. Define authentication and authorization. 15. What is referential integrity. *****THE END*****