Question

The physical database design identifies data integrity and security requirements.
A.TRUE
B.FALSE
C.
D.

Answer 1

Answer:

(B). False

Physical development is the procedure of deciding how the database will be organized for data storage and how users will access that data in order to maintain the database's quality, safety, and efficiency.

Explanation:

The method of transforming a database schema into the physically relational model of a specific database management system is known as physical data modelling (DBMS).

Physical database design's goal is to convert the logical descriptive statistic into the technological requirements for data storage and retrieval. A design for data storage that will deliver acceptable performance and guarantee integrity of data, safety, and reusability is the objective.

You transform the information obtained during in the logical design into a representation of the database model, containing columns and restrictions, during the physical design process. The type of index and segmentation are physical design choices that have a significant impact on database performance.

The system's real input and output operations are related to the physical design. It refers to the methods used to input, validate, process, and output data from a system. By developing the design specification, which describes in detail what the candidate system does, it creates the functioning solution.

#SPJ2

Answer 2

Answer:

The physical database design identifies data integrity and security requirements is (b) false.

Explanation:

• A physical database design will represent the creation of database into the actual system.
• The logical designs are performed by the database platform eventually and it depends on semantics of the Database Management system.

• There are 3 components of Physical database design:

1) Data files

2) Redo log files

3) Control files

• To create the database we follow these steps. They are:

1) It should specify the keys for entities.

2) To find the relationships between different entities.

3) Finding all the attributes of entities that are present.

4) By resolving many-to-many relationships.

Example:

We can attribute the column name of the employers by using the syntax:

EMPLOYEE_NUMBER, to EMPNO

#SPJ2