Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

plzz answer all this important thank u Part B - 10 Short Answer Questions (50 marks in total, the value for each question is indicated)

plzz answer all this important

thank u image text in transcribed

Part B - 10 Short Answer Questions (50 marks in total, the value for each question is indicated) Question 1 (4 marks) (a) In the context of relational algebra what is meant by the term 'unary operator"? (b) List the names of two unary relational algebra operators. Question 2(4 marks) (a) Describe what is meant by the term 'data independence. (b) How does a database management system achieve data independence? Question 3 (4 marks) (a) What is a view? (b) What is the difference between a view and a base relation? Question 4(9 marks total) (a) Define the term 'foreign key'(2 mark) (b) Draw and populate 2 sample tables to illustrate the concept of a foreign key.(4 marks) (c) Referring to the 2 sample tables describe how they illustrate the use of a foreign key.(3 marks) Question 5(8 marks total) Draw an Entity Relationship Diagram to illustrate the following schema: Store(store_id, storename, suburb) Staff(Staff_id, surname, first_name, phone_number, date_of_birth, store_id*) Merchant(merchant_id, first_name, last_name, phone number) MerchantInterests(merchant id*, store id*) Assume that staff can only work at one store. A store employs many staff. A merchant can be the owner of many stores and a store can be owned by many merchants

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

Database Principles Programming And Performance

Authors: Patrick O'Neil

1st Edition

1558603921, 978-1558603929

More Books

Students also viewed these Databases questions