Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Describe the following in the 2 models Cardinality Relationships Mandatory One to Many Main Primary Identifier if possible. defined department_empv id INT + dep_id INT

Describe the following in the 2 models

Cardinality

Relationships

Mandatory

One to Many

Main Primary Identifier if possible.

image text in transcribeddefined

department_empv id INT + dep_id INT emp_id INT Indexes department dep_id INT dep_name VARCHAR(45) Indexes employee emp_id INT devices dev_id INT # emp_name VARCHAR(45) emp_dob VARCHAR(45) emp_address VARCHAR(45) emp_phone VARCHAR(45) emp_mobile VARCHAR(45) Indexes dev_model VARCHAR(45) dev_make VARCHAR(45) dev_owndate VARCHAR(45) dev_uid VARCHAR(45) emp_id INT Indexes

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introductory Relational Database Design For Business With Microsoft Access

Authors: Jonathan Eckstein, Bonnie R. Schultz

1st Edition

1119329418, 978-1119329411

More Books

Students also viewed these Databases questions

Question

Define tacit knowledge and explicit knowledge.

Answered: 1 week ago

Question

Name the different levels of e-CRM.

Answered: 1 week ago

Question

How do Data Types perform data validation?

Answered: 1 week ago

Question

How does Referential Integrity work?

Answered: 1 week ago