what does logical design , physical design and conceptual design refer to

Question

Question

engineering Computer-Science

Answer 1

Answer #1

Conceptual: Conceptual Data Model defines what the system contains. The purpose is to organize, scope and define business concepts and rules.
Logical: Logical view defines how the system should be implemented regardless of the DBMS. The purpose is to developed technical map of rules and data structures.
Physical: This Data Model describes how the system will be implemented using a specific DBMS system. The purpose is actual implementation of the database.

Answer 2

Similar Homework Help Questions

(Subject Database) Q1. Define, compare and contrast Conceptual, logical and physical database design Q2. What are...

(Subject Database) Q1. Define, compare and contrast Conceptual, logical and physical database design Q2. What are the data elements necessary to create an invoice for a customer? Save this query as a view named Invoice View Q3. Create an alphabetical index on customer name in the Customer table. Q4. Prepare a report that evaluates possible client/server solutions to handle new customer application system for all branch offices? What technology characteristic you will evaluate? Q5. What is a query optimizer in...
Explain the difference between logical and physical design when it comes to system design. Please be...

Explain the difference between logical and physical design when it comes to system design. Please be specific with examples.
How to create database design using SQL for an Airbnb planning business? Also draw conceptual model,...

How to create database design using SQL for an Airbnb planning business? Also draw conceptual model, logical model and physical model.

difference between logical and physical model . (subject name: systems analysis and design)

difference between logical and physical model . (subject name: systems analysis and design)
We apply a database model (e.g., the relational model) to our database design at which point...

We apply a database model (e.g., the relational model) to our database design at which point in the lifecycle? a. As part of the conceptual -> logical design transition b. As part of the logical - > physical design transition c. As part of the physical -> implementation transition d. As part of the requirements definition -> conceptual design transition
hello i want to do the conceptual design for my project , what is the conceptual...

hello i want to do the conceptual design for my project , what is the conceptual design i need an example to do it

How does the logical vs. physical address space affect compilation, linking, and loading?

How does the logical vs. physical address space affect compilation, linking, and loading?
Q.No.1 Convert following conceptual design into logical design: Supervisor Supervises Registers Optional) 0.10 Staff staffNo (PK)...

Q.No.1 Convert following conceptual design into logical design: Supervisor Supervises Registers Optional) 0.10 Staff staffNo (PK) namo fName IName position Sex DOB 0..1 Manages 0_100 Property For Rent property No PK) address street city postcode type rooms rent 1..1 Associated with Views Clent dentNo (PK) name Namo IName telo 1.. viewDate comment Owns Holds States 0. Owner ownerNo {PK) address telo {Manciatory, Ort Preference profТуро maxRont Lease TeaseNo {PK) payment Method dopositPaid rentStart rentFinish Ideposit duration Private Owner Business Owner...
Where does the logical to physical address translation take place within the ISO/OSI protocol stack?

Where does the logical to physical address translation take place within the ISO/OSI protocol stack?

Which of the following is FALSE? Application Design may be done in parallel with Database Implementation...

Which of the following is FALSE? Application Design may be done in parallel with Database Implementation Conceptual design provides a model of the DATA Physical design involves the creation of the database Logical design is independent of a specific Database Management System