Scribd
Upload
4 views1 page

Dbms Assignment

The document outlines the differences between centralized, client-server, and distributed DBMS architectures, detailing their respective use cases. It also discusses anomalies related to insertion, update, and deletion in a company’s order details table. Furthermore, it provides a normalization process for the table through 1NF, 2NF, and 3NF, illustrating the transformations at each stage.

Uploaded by

shreyasharma12aug
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
4 views1 page

Dbms Assignment

The document outlines the differences between centralized, client-server, and distributed DBMS architectures, detailing their respective use cases. It also discusses anomalies related to insertion, update, and deletion in a company’s order details table. Furthermore, it provides a normalization process for the table through 1NF, 2NF, and 3NF, illustrating the transformations at each stage.

Uploaded by

shreyasharma12aug
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Assignment-1.

1: Explain the difference between centralized, client- server, and


distributed DBMS architectures. what are the use case for each.

A company stores order details in a single table: (Order ID, Customer Name,
Customer Address, Product Name, Product Category, Unit Price, Quality, Total
Price).

identify insertion, update, and deletion anomalies.

Normalize the table to 1NF, 2NF, 3NF, showing the transformation at each stage.

You might also like