Name: Database Management System For PGDCA 1st Semester of Panjab University Chandigarh
Brand: Amit Book Depot
Availability: OutOfStock

Database Management System For PGDCA 1st Semester of Panjab University Chandigarh

by Madhurima

₹0 ₹0.00(-/ off)

Rating & Reviews

23 Customer Review

Have Doubts Regarding This Product ? Ask Your Question

Q1

Is this book sufficient for the PGDCA 1st Semester DBMS exam at Panjab University?

A1

Yes, it is specifically written for the PGD-1103 paper and covers the entire Panjab University syllabus in detail.
Q2

What are the main topics covered in the Database Design chapter?

A2

It covers Data Models, the Entity Relationship Model, Entities, Attributes, and creating E-R Diagrams for conceptual design.
Q3

Does this book explain the difference between DBMS and the old file-oriented approach?

A3

Yes, the first chapter provides a detailed comparison between the Database Approach and the File-Oriented Approach, highlighting the advantages of DBMS.
Q4

Which normalization forms are explained in the Relational Model section?

A4

The book thoroughly explains 1NF, 2NF, and 3NF, along with partial and transitive dependencies.
Q5

Will I learn about database security and user privileges from this text?

A5

Absolutely. It covers data security risks, password threats, and how to grant and revoke system and object privileges.
Q6

What types of SQL functions are explained in the book?

A6

It covers various functions including Character Functions, Date Functions, and Group Functions for data analysis.
Q7

Does this book cover transaction control commands like COMMIT and ROLLBACK?

A7

Yes, it includes a dedicated section on Transaction Control Language (TCL) explaining COMMIT and ROLLBACK.
Q8

What is the difference between DDL and DML as explained in this book?

A8

The book clearly distinguishes DDL (CREATE, ALTER, DROP) for defining structure and DML (INSERT, UPDATE) for manipulating data.
Q9

Are there any questions on concurrency control and database recovery?

A9

Yes, the Database Security chapter includes locking techniques for concurrency and log-based recovery from failures.
Q10

Does the book cover the relational algebra and calculus concepts?

A10

Yes, the Relational Model chapter includes dedicated sections on relational algebra and relational calculus.

0.00

0 Overall Rating

5

0
4

0
3

0
2

0
1

0

Try this product & share your review & thoughts

No Description Added

No Table Content Added

Have Doubts Regarding This Product ? Ask Your Question

Q1

Is this book sufficient for the PGDCA 1st Semester DBMS exam at Panjab University?

A1

Yes, it is specifically written for the PGD-1103 paper and covers the entire Panjab University syllabus in detail.
Q2

What are the main topics covered in the Database Design chapter?

A2

It covers Data Models, the Entity Relationship Model, Entities, Attributes, and creating E-R Diagrams for conceptual design.
Q3

Does this book explain the difference between DBMS and the old file-oriented approach?

A3

Yes, the first chapter provides a detailed comparison between the Database Approach and the File-Oriented Approach, highlighting the advantages of DBMS.
Q4

Which normalization forms are explained in the Relational Model section?

A4

The book thoroughly explains 1NF, 2NF, and 3NF, along with partial and transitive dependencies.
Q5

Will I learn about database security and user privileges from this text?

A5

Absolutely. It covers data security risks, password threats, and how to grant and revoke system and object privileges.
Q6

What types of SQL functions are explained in the book?

A6

It covers various functions including Character Functions, Date Functions, and Group Functions for data analysis.
Q7

Does this book cover transaction control commands like COMMIT and ROLLBACK?

A7

Yes, it includes a dedicated section on Transaction Control Language (TCL) explaining COMMIT and ROLLBACK.
Q8

What is the difference between DDL and DML as explained in this book?

A8

The book clearly distinguishes DDL (CREATE, ALTER, DROP) for defining structure and DML (INSERT, UPDATE) for manipulating data.
Q9

Are there any questions on concurrency control and database recovery?

A9

Yes, the Database Security chapter includes locking techniques for concurrency and log-based recovery from failures.
Q10

Does the book cover the relational algebra and calculus concepts?

A10

Yes, the Relational Model chapter includes dedicated sections on relational algebra and relational calculus.

No Syllabus Added

0.00

0 Overall Rating

5

0
4

0
3

0
2

0
1

0

Try this product & share your review & thoughts