Please help me with these 2 questions: 1. Open and examine the following ERR design file people.mwb      a. Each person is described by their name and email.    b. Each person can be registered in multiple countries.    c. Ensure it is in 3rd normal form.    d. Ensure the relationships and primary and foreign keys are correct. 2. Create a database from the design. (people.mwb file show as photo included

Systems Architecture
7th Edition
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Stephen D. Burd
Chapter13: Internet And Distributed Application Services
Section: Chapter Questions
Problem 2RP
icon
Related questions
Question

Please help me with these 2 questions:

1. Open and examine the following ERR design file people.mwb  
   a. Each person is described by their name and email.
   b. Each person can be registered in multiple countries.
   c. Ensure it is in 3rd normal form.
   d. Ensure the relationships and primary and foreign keys are correct.

2. Create a database from the design.

(people.mwb file show as photo included)

MYSQL Workbench
合
MYSQL Model (people.mwb)
EER Diagram x
File
Edit
View Arrange Model
Database
Tools Scripting Help
Bird's Eye
Diagram
Modeling Additions
Zoom: 100% - Q Q
timestamps
MWB
create_time, update_time
user
MWB
username, email, password, create.
category
O People
MWB
Registration
category_id, name
P idPeople INT
idRegistration INT
Catalog Tree
O name VARCHAR(45)
O Country 1 VARCHAR(45)
O email VARCHAR(45)
O Country2 VARCHAR(45)
vA mydb
Indexes
O Country3 VARCHAR(45)
Tables
O Registered1 DATETIME
Views
A Routine Groups
ORegistered2 DATETIME
O Registered3 DATETIME
1:1
Indexes
Catalog Layers User Types
1:n
Description Editor
1:1
No Selection
1:n
n:m
1:n
Description Properties
H
Templates
Ready
目
10:39 PM
P Type here to search
71°F Cloudy ^ o O 4x ENG
12/5/2021
| ロ a圈■ 圆
Transcribed Image Text:MYSQL Workbench 合 MYSQL Model (people.mwb) EER Diagram x File Edit View Arrange Model Database Tools Scripting Help Bird's Eye Diagram Modeling Additions Zoom: 100% - Q Q timestamps MWB create_time, update_time user MWB username, email, password, create. category O People MWB Registration category_id, name P idPeople INT idRegistration INT Catalog Tree O name VARCHAR(45) O Country 1 VARCHAR(45) O email VARCHAR(45) O Country2 VARCHAR(45) vA mydb Indexes O Country3 VARCHAR(45) Tables O Registered1 DATETIME Views A Routine Groups ORegistered2 DATETIME O Registered3 DATETIME 1:1 Indexes Catalog Layers User Types 1:n Description Editor 1:1 No Selection 1:n n:m 1:n Description Properties H Templates Ready 目 10:39 PM P Type here to search 71°F Cloudy ^ o O 4x ENG 12/5/2021 | ロ a圈■ 圆
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 8 images

Blurred answer
Knowledge Booster
Fundamentals of Big Data Analytics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L