what is physical database design??
“Physical database design is the process of producing a description of the implementation of the database on secondary storage; it describes the base relations, file organizations, and indexes used to achieve efficient access to the data, and any associated integrity constraints and security measures”. [1] The prerequisites for the physical design of a database can be summarized as follows: [5] – Global logical data model (entities and attributes are well defined, the relationships between them and special rules that define relational integrity) – Relations are normalized – Descriptions of where and when data are used (entered, retrieved, deleted, updated) – Expectations/requirements for response times, data security, backup, recovery, retention, integrity. – Description of technologies (DBMS) used for implementing the system – GUI standard ideas But what does this mean? Let’s go over each one of them…. Entities and Attributes definition: Tables are the heart of a database, therefore
Related Questions
- What is the relationship between a database and an information system, and how does this relationship have a bearing on database design?
- What Elements Jointly Produce Physical Database Design?
- What Elements Jointly Produce Physical Database Design?
- What are tha major benefits of the database approach?
- What are tha major benefits of the database approach?
- what is physical database design??
