Knowledge in database design
Overview of Database Design--the ER Model
The initial phase of database design is to characterize fully the data needs of the prospective database users. Next, the designer chooses a data model and, by applying the concepts of the chosen data model, translates these requirements into a conceptual schema of the database. A fully developed conceptual schema also indicates the functional requirements of the enterprise. In a “specification of functional requirements”, users describe the kinds of operations (or transactions) that will be performed on the data. The ER data model was developed to facilitate database design by allowing specification of an enterprise schema that represents the overall logical structure of a database.
AKSHAT RAO PATIL
Database Design - Aggregate function and nested queries
This pdf contains a self-explanatory concept prepared by experienced faculty for a better understanding of the students on the topic of database design. It gives good references during the preparation of the exam.
Ankit Anand