Homework Help is Here – Start Your Trial Now!
Business
Management
1. Transform the data model to a physical model (database design). Note: a. Draw the entity-relationship diagram (ERD) in Crow's foot notation using MS Visio 2019/2021. Use only the crow's foot database notation (template) in MS Visio (10 pts. penalty is assessed if the wrong template is used). b. There must be no many-to-many relationships (to place FKs appropriately). c. The ERD must include not only tables, foreign keys and relationships with cardinalities but also all columns and their data types (do not use char type only; you need to choose the appropriate data types for each column instead) and also display data types in the Visio file (10 pts. reduction if data types are not included or displayed). See below for instructions on how to enable and modify the display of data types. d. The names must be the same as provided in the data model; clearly label the primary keys and foreign keys. e. All foreign keys are required, i.e., cannot be null. GG_SERVICE PK ServiceID ServiceDescription CostPerHour I OWNER PK OwnerID OwnerName OwnerEmail OwnerType -+----Has EMPLOYEE PROPERTY_SERVICE PK EmployeelD PK PropertyServiceID --Perform--O o Has H LastName FirstName ServiceDate HoursWorked CellPhone ExperienceLevel Attend TRANINING COURSE PK CourseID Date Time Location o---Has---+ Uses OWNED PROPERTY PK PropertyID PropertyName Street City State Zip Has SUB_PROPERTY PK PropertyID PK SubPropertyID SubPropertyType SubPropertyName Description EQUIPMENT PK EquipmentID EquipmentType Manufacturer Model DatePurchased -Require--0 EQUIPMENT REPAIR PK RepairID CostOfRepair DateOfCompletion

1. Transform the data model to a physical model (database design). Note: a. Draw the entity-relationship diagram (ERD) in Crow's foot notation using MS Visio 2019/2021. Use only the crow's foot database notation (template) in MS Visio (10 pts. penalty is assessed if the wrong template is used). b. There must be no many-to-many relationships (to place FKs appropriately). c. The ERD must include not only tables, foreign keys and relationships with cardinalities but also all columns and their data types (do not use char type only; you need to choose the appropriate data types for each column instead) and also display data types in the Visio file (10 pts. reduction if data types are not included or displayed). See below for instructions on how to enable and modify the display of data types. d. The names must be the same as provided in the data model; clearly label the primary keys and foreign keys. e. All foreign keys are required, i.e., cannot be null. GG_SERVICE PK ServiceID ServiceDescription CostPerHour I OWNER PK OwnerID OwnerName OwnerEmail OwnerType -+----Has EMPLOYEE PROPERTY_SERVICE PK EmployeelD PK PropertyServiceID --Perform--O o Has H LastName FirstName ServiceDate HoursWorked CellPhone ExperienceLevel Attend TRANINING COURSE PK CourseID Date Time Location o---Has---+ Uses OWNED PROPERTY PK PropertyID PropertyName Street City State Zip Has SUB_PROPERTY PK PropertyID PK SubPropertyID SubPropertyType SubPropertyName Description EQUIPMENT PK EquipmentID EquipmentType Manufacturer Model DatePurchased -Require--0 EQUIPMENT REPAIR PK RepairID CostOfRepair DateOfCompletion

Understanding Business
Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
See similar textbooks
icon
Related questions
Question
1. Transform the data model to a physical model (database design). Note: a. Draw the entity-relationship diagram (ERD) in Crow's foot notation using MS Visio 2019/2021. Use only the crow's foot database notation (template) in MS Visio (10 pts. penalty is assessed if the wrong template is used). b. There must be no many-to-many relationships (to place FKs appropriately). c. The ERD must include not only tables, foreign keys and relationships with cardinalities but also all columns and their data types (do not use char type only; you need to choose the appropriate data types for each column instead) and also display data types in the Visio file (10 pts. reduction if data types are not included or displayed). See below for instructions on how to enable and modify the display of data types. d. The names must be the same as provided in the data model; clearly label the primary keys and foreign keys. e. All foreign keys are required, i.e., cannot be null.
Transcribed Image Text:1. Transform the data model to a physical model (database design). Note: a. Draw the entity-relationship diagram (ERD) in Crow's foot notation using MS Visio 2019/2021. Use only the crow's foot database notation (template) in MS Visio (10 pts. penalty is assessed if the wrong template is used). b. There must be no many-to-many relationships (to place FKs appropriately). c. The ERD must include not only tables, foreign keys and relationships with cardinalities but also all columns and their data types (do not use char type only; you need to choose the appropriate data types for each column instead) and also display data types in the Visio file (10 pts. reduction if data types are not included or displayed). See below for instructions on how to enable and modify the display of data types. d. The names must be the same as provided in the data model; clearly label the primary keys and foreign keys. e. All foreign keys are required, i.e., cannot be null.
GG_SERVICE PK ServiceID ServiceDescription CostPerHour I OWNER PK OwnerID OwnerName OwnerEmail OwnerType -+----Has EMPLOYEE PROPERTY_SERVICE PK EmployeelD PK PropertyServiceID --Perform--O o Has H LastName FirstName ServiceDate HoursWorked CellPhone ExperienceLevel Attend TRANINING COURSE PK CourseID Date Time Location o---Has---+ Uses OWNED PROPERTY PK PropertyID PropertyName Street City State Zip Has SUB_PROPERTY PK PropertyID PK SubPropertyID SubPropertyType SubPropertyName Description EQUIPMENT PK EquipmentID EquipmentType Manufacturer Model DatePurchased -Require--0 EQUIPMENT REPAIR PK RepairID CostOfRepair DateOfCompletion
Transcribed Image Text:GG_SERVICE PK ServiceID ServiceDescription CostPerHour I OWNER PK OwnerID OwnerName OwnerEmail OwnerType -+----Has EMPLOYEE PROPERTY_SERVICE PK EmployeelD PK PropertyServiceID --Perform--O o Has H LastName FirstName ServiceDate HoursWorked CellPhone ExperienceLevel Attend TRANINING COURSE PK CourseID Date Time Location o---Has---+ Uses OWNED PROPERTY PK PropertyID PropertyName Street City State Zip Has SUB_PROPERTY PK PropertyID PK SubPropertyID SubPropertyType SubPropertyName Description EQUIPMENT PK EquipmentID EquipmentType Manufacturer Model DatePurchased -Require--0 EQUIPMENT REPAIR PK RepairID CostOfRepair DateOfCompletion
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON
SEE MORE TEXTBOOKS