Logical Design
In order to create a database, organizations must determine what data to collect, who will access the data, and how the data will be use (Stair and Reynolds, 2012). After this information is determine, the database is designed. Database design has two parts. The first part is the logical design and the second part is the physical design.
Logical Design The logical design is an abstract model which focus on what the system must do in order to meet the requirements of the organization’s needs. The logical design involves gathering the information about the business process, business entities, and organizational units (Unknown, 2001). The logical design is basically a blueprint that identifies the functions requirement of a system and a relationship among the data collected. During the logical design phase developer are informed in details about what the application must have in order to support the organization. The logical design consists of both input and output for information system and should be created with input from all user in order to meet the need of all functional areas (Stair and Reynolds, 2012).
Physical Design The physical design is the actual creation of the database based on the requirements of the system logical design. Physical design determines how a software system is pack into deployable units and identifies the physical entities of the system (Knoernschild, 2012). In the physical design phase schemas are produced. The physical design models uses entities and attributes to create relationships that produce the schema. During the physical design phase constraints are defined with primary keys, foreign keys, and other unique keys. In the physical design phase all pieces comes together to complete the database process for an organization (Unknown, 2001).
Rainforest Logical/Physical Design Recommendations Object-Oriented design (OO design) is recommended for Rainforest overall logical and physical design. “Many company
Logical Design The logical design is an abstract model which focus on what the system must do in order to meet the requirements of the organization’s needs. The logical design involves gathering the information about the business process, business entities, and organizational units (Unknown, 2001). The logical design is basically a blueprint that identifies the functions requirement of a system and a relationship among the data collected. During the logical design phase developer are informed in details about what the application must have in order to support the organization. The logical design consists of both input and output for information system and should be created with input from all user in order to meet the need of all functional areas (Stair and Reynolds, 2012).
Physical Design The physical design is the actual creation of the database based on the requirements of the system logical design. Physical design determines how a software system is pack into deployable units and identifies the physical entities of the system (Knoernschild, 2012). In the physical design phase schemas are produced. The physical design models uses entities and attributes to create relationships that produce the schema. During the physical design phase constraints are defined with primary keys, foreign keys, and other unique keys. In the physical design phase all pieces comes together to complete the database process for an organization (Unknown, 2001).
Rainforest Logical/Physical Design Recommendations Object-Oriented design (OO design) is recommended for Rainforest overall logical and physical design. “Many company