Review the scenario below identify the conceptual
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 vend-ing option for the products to be disbursed. Drinks are packaged in four-packs, six-packs, and ten-packs.
A.: Conceptual model: Zoe had a plan to buy eight 6*pack drinks and her expectation was to get some
assistance carrying the products to her car.
Physical model: Zoe discovers that drinks are packed in 4*pack, 6*pack, and 10*pack(carbonated drinks, non-
carbonated drinks, and sugar free drinks) and the entire drink distribution system is automated now.
3. Provide five reasons for creating a conceptual data model.
A.: 1.
CM describes exactly the information needs of the business;
2. It facilitates discussions;
3. It prevents mistakes and misunderstandings; 4. It forms important “ ideal system ” documentation; 5.It forms a sound basis for physical database design. P.S. It captures functional and informational needs of a business, satisfies current and future needs, increases sales and/or reduce costs.
3. It prevents mistakes and misunderstandings; 4. It forms important “ ideal system ” documentation; 5.It forms a sound basis for physical database design. P.S. It captures functional and informational needs of a business, satisfies current and future needs, increases sales and/or reduce costs.
Comments
Post a Comment