Tugas 1 : Identify Conceptual Model And Physical Model

Review the scenario below. Identify the conceptual model and the physical model from the scenario. 

Zoe was about to go into a store to purchase drinks for the birthday party scheduled for that evening. Zoe knows that she needs drinks for 48 people and is expecting the store to accept a check for payment and to provide her with some assistance carrying the product to her car. Zoe wants to have carbonated drinks, non-carbonated drinks, and sugar free drinks. She is expecting to purchase eight six-packs. Zoe enters the store and discovers the entire drink distribution system is automated. She also discovers that the drinks come in varying package sizes and that she must choose the correct vending option for the products to be disbursed. Drinks are packaged in four-packs, sixpacks, and ten-packs.

Answers :

Conseptual Model

Entity : Store

Attribute : Drinks, Packages

Physical Model

Tabel : Store

Column Name : Drinks (Varchar), Packages (Varchar)