Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Mis 203 question Table: EMPLOYEE EMP_ID EMP_NAME EMP_NATIONALITY EMP_STATUS 2897 Gul-e-Rana Pakistani Instructor 3897 Farha Zeba Indian Lecturer 4897 Rohaya Shaari Malaysian Lecturer 1269 Fatima

Mis 203 question image text in transcribed
image text in transcribed
image text in transcribed
Table: EMPLOYEE EMP_ID EMP_NAME EMP_NATIONALITY EMP_STATUS 2897 Gul-e-Rana Pakistani Instructor 3897 Farha Zeba Indian Lecturer 4897 Rohaya Shaari Malaysian Lecturer 1269 Fatima Maloom Saudi Supervisor Table: COURSE COURSE_ID COURSE_TITLE EMP_ID MGT211 Principles of Management 2897 ECON 101 Statistics 3897 Table: COURSE COURSE_ID COURSE_TITLE EMP_ID MGT211 Principles of Management 2897 ECON 101 Statistics 3897 MIS203 2897 Principles of MIS For the tables given above answer the following questions: Ans: How many attributes are present in the COURSE table? In which table foreign key exist? Which attribute is the primary key of EMPLOYEE table? Which attribute is the primary key of COURSE table? How many tuples are there in the table of EMPLOYEE? How many tuples are there in the table of COURSE

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_2

Step: 3

blur-text-image_3

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

How To Build A Cyber Resilient Organization Internal Audit And IT Audit

Authors: Eugene Fredriksen

1st Edition

1032402210, 978-1032402215

More Books

Students also viewed these Accounting questions

Question

b. What groups were most represented? Why do you think this is so?

Answered: 1 week ago