Question

Convert the following conceptual design into logical design.

Answer 1

Answer:

Conceptual design is the first stage in the database design process. ... The output of this process is a conceptual data model that describes the main data entities, attributes, relationships, and constraints of a given problem domain.

Answer 2

Answer:

The process to map from a Conceptual Model to a Logical Model is as follows. First, a set of entities is transformed into a relation, set of tuples. Second, an attribute is transformed into an attribute of the relation. Third, the identifier of the entity becomes the primary key of the relation