Elective Database Management System
BE Computer (PU) Semester 33 credit hours
Database Management System
SyllabusComing soonUnits and teaching hours for this subject.Open NotesBeing writtenUnit-by-unit notes with examples.Open Old Questions7 questionsFrom PU Spring 2023Open MCQ PracticeComing soonAnswer, see if you’re right straight away, and read why.Open
Recent old questions
a) Differentiate between database schema and instances. Briefly describe DDL, DML and DCL. b) Define relational data model. Draw an E R diagram for a Library…PU Spring 202315a) Suppose we have the following relation. [<3 imployee(person name, street, city) iti diced Bo! tr Works (person name, company name, salary) Company (company…PU Spring 20238a) Write SQL statements for the following queries using the given Employees relation: 1 i) Create a database named Company and Employees relation. ii) Create…PU Spring 202315a) What is database normalization? Explain in detail about INF, 2NF, 3NF with suitable examples. b) What are authorization and authentication? Why are they…PU Spring 202315