Physical Database Design

Question Description

I’m studying for my Computer Science class and need an explanation.

Part 1 - Physical Database Design

1.Use the Data Dictionary that is added below.

2.From the data dictionary tables, build MS Acess tables.

3.Via "Database Tools" create table relationships.

Physical data model represents how the model will be built in the database. A physical database model shows all table structures, including column name, column data type, column constraints, primary key, foreign key, and relationships between tables. Features of a physical data model include:

  • Specification all tables and columns.
  • Foreign keys are used to identify relationships between tables.
  • De-normalization may occur based on user requirements.
  • Physical considerations may cause the physical data model to be quite different from the logical data model.
  • Physical data model will be different for different RDBMS. For example, data type for a column may be different between MySQL and SQL Server.

The steps for physical data model design are as follows:

  1. Convert entities into tables.
  2. Convert relationships into foreign keys.
  3. Convert attributes into columns.
  4. Modify the physical data model based on physical constraints / requirements.


  • Using the FAME partial data dictionary (10 tables)
  • Build MS Acess tables
  • Once tables are complete
  • From the menu, enter "Database Tools"
  • Create table relationships

I have added the access file already with tables in it, You just have to create relationships from the word document added below.

Unformatted Attachment Preview

Data Dictionary for Order Management System Customer Table – This table stores customer details Y CustomerID FullName DeliveryAddress Email INTEGER INTEGER VARCHAR2 VARCHAR2 10 10 20 20 Unique customer identifier Defines the name of the customer Stores the cutomer delivery address Stores the email of the customer Product Table – Stores details about a product Y ProductID INTEGER 10 ProductName Description UnitPrice VARCHAR2 10 VARCHAR2 20 INTEGER 7 Unique product identifier like serial number Defines the name of the Product Provides more details of the Product Stores the price of the product Order Table – Stores details about a Customer’s order Y OrderID INTEGER 6 OrderDate CustomerID DATE VARCHAR2 20 TotalCost INTEGER 7 Used to uniquely identify a particular order Defines the date the order was made Uniquely identifies the customer who made the order from the customer table Stores the total cost the order would amount to. Order Line– Stores details about an Order Line Y OrderID INTEGER 6 Y ProductID Qty Toppings INTEGER INTEGER INTEGER 10 5 7 OtherInfo VARCHAR 2 25 Used to reference the orders table to uniquely identify an order Defines Product in the order Defines the quantity of the orders Stores details about the toppings of the product Stores any additional information about an order line ...
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Final Answer


Demsey (609)
Carnegie Mellon University

Top quality work from this tutor! I’ll be back!

Heard about Studypool for a while and finally tried it. Glad I did caus this was really helpful.

Thank you! Reasonably priced given the quality


Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors