answer correct $,$ i send agine thise ass

Primary objective:

The primary objective of this project is to understand the principles of Advanced Database Design Concepts. The project starts with the analysis of the physical usage of a moderately realistic database system, and from this analysis to identify potential performance problem areas in the database. Then the task is to choose, implement, and test an appropriate combination of physical tuning techniques for the database you create. There are three main elements to be considered: choosing, implementing, and testing.

Topic:

You can choose your topic for this project. But the topic should be rich in detail so that you will get some reasonable size of database and data to test for your tuning methods.

Tasks:

$$ Imagine the Database system you are creating is for a medium$-$sized company and they are converting from a computer file system to a database system. If you are appointed as a data administrator of the company then list out the tasks you do for the company and the system. $($Like what kind of DBMS DBA chooses, policies you make, planning, etc..$)$

$$ You need to develop the following three phases of the project:

o Conceptual Design

o Logical Design

o Physical Design

$$ In the conceptual Design, First draw the ERD of your database.

$$ In logical design, you will convert the ERD to a proper database using coding. Discuss the issues related to it and suggest solutions. Also, find the possibilities for the integrity constraints for the data fields and explain the need for it$.$

$$ The Physical design is the most important phase of your project.

o Write the code required to implement your chosen techniques, and insert it into your schema. Include your modified schema also in your report.

o Test your implementation and demonstrate that the techniques that you have implemented do improve database performance. This will typically be achieved by executing appropriate queries and including tidily formatted output from the likes of EXPLAIN PLAN or similar. This should be done both before and after the tuning techniques have been applied. Test each technique in isolation, and then test all of your techniques in combination, to ensure that your entire integrated solution still improves database performance.