Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Given below are samples of data stored in PRODUCT and SUPPLIER relations. (Figure 1) PRODUCT productNo productName pricePerUnit productOnHand expiry Date supplier No (RM) PO1

image text in transcribed

image text in transcribed

image text in transcribed

Given below are samples of data stored in PRODUCT and SUPPLIER relations. (Figure 1) PRODUCT productNo productName pricePerUnit productOnHand expiry Date supplier No (RM) PO1 Yogurt 4.50 1100 12/03/21 S002 PO2 Ideal Milk 5.30 200 23/08/21 S002 Cookies 8.90 2000 30/09/21 S003 SUPPLIER supplier No S002 S003 address Kajang Hill Putrajaya telNo 03-89765421 03-89997733 Figure 1 Write the SOL statements to: e) Find the total number of product from supplier S003. f) Add an attribute named contact Person to Supplier relation. Based on the scenario given below, draw an ER diagram and specify the multiplicity constraints for each relationship. (20 marks] (CLO2:PLO2:04) IMMA University consists of several departments. Each department runs a number of courses. The university provides a set of modules used in different courses. Each course uses a number of modules but not every module is used. A course is assigned a unique course code and a module is identified by a unique module code. A module can be used in one course only, but can be studied by many students. In addition to the module code each module unique title, start date and end date are also stored. The database should also store each course unique title and duration. A student can enroll in one course at a time. Once enrolled a student is assigned a unique matriculation number. Additional data stored on each student includes student name and address. Each department is managed by a member of academic staff. Each department has a name, phone number and location. Each department employs many members of academic staff. A member of academic staff works for one department only. All members of academic staff teach modules. Every member of academic staff teaches one or more modules and a module may be taught by more than one member of academic staff. Each member of academic staff is identified by a unique staff number. Additional data stored on each member of academic staff includes name and phone extension number. Paragraph B

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

Database Basics Computer EngineeringInformation Warehouse Basics From Science

Authors: Odiljon Jakbarov ,Anvarkhan Majidov

1st Edition

620675183X, 978-6206751830

More Books

Students explore these related Databases questions

Question

What is the relationship between humans?

Answered: 3 weeks ago

Question

Define Leap year?

Answered: 3 weeks ago

Question

Prepare a short profile of Lucy Clifford ?

Answered: 3 weeks ago

Question

Prepare a short profile of Rosa parks?

Answered: 3 weeks ago