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 xFileEditView Arrange ModelDatabaseTools Scripting HelpBird's EyeDiagramModeling AdditionsZoom: 100% - Q QtimestampsMWBcreate_time, update_timeuserMWBusername, email, password, create.categoryO PeopleMWBRegistrationcategory_id, nameP idPeople INTidRegistration INTCatalog TreeO name VARCHAR(45)O Country 1 VARCHAR(45)O email VARCHAR(45)O Country2 VARCHAR(45)vA mydbIndexesO Country3 VARCHAR(45)TablesO Registered1 DATETIMEViewsA Routine GroupsORegistered2 DATETIMEO Registered3 DATETIME1:1IndexesCatalog Layers User Types1:nDescription Editor1:1No Selection1:nn:m1:nDescription PropertiesHTemplatesReady目10:39 PMP Type here to search71°F Cloudy ^ o O 4x ENG12/5/2021| ロ a圈■ 圆

Primary key: It is a unique entity in a table which is used to easily identify and locate data in…

Answered: Please help me with these 2 questions:…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

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圈■ 圆

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 8 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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