Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Outline the function of each of the following constraint as used in Structured Query Language. (a) (i) UNIQUE; (ii) CHECK: (iii) DEFAULT. (1 mark)

image text in transcribedimage text in transcribed

Outline the function of each of the following constraint as used in Structured Query Language. (a) (i) UNIQUE; (ii) CHECK: (iii) DEFAULT. (1 mark) (1 mark) (1 mark) (b) In the early years of computing, punched cards were used for storing and retrieving ytve data. Outline four challenges that could have been realised from using these devices. (4 marks) (c) Explain three factors that may influence the choice of database system in an organisation. (6 marks) (d) Table 2 is the un-normalised table used by a movie vendor to manage their movie distribution. Normalise the table up to the third normal form. (7 marks) Table 2 NAME Jean Zani PHYSICAL ADDRESS Mashujaa Road Sam Lemi Nairobi East Ways MOVIE TITLE The Life of a Politician, Bits and Bytes of Computers The Valley of Life, Cutting the Roses TITLE Ms. Mr. Sam Lemi Hills View way Bits and Bytes of Computers Mr.

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

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions

Question

d. Is it part of a concentration, minor, or major program?

Answered: 1 week ago

Question

Personal role: This consists of service to family and friends.

Answered: 1 week ago

Question

The role of life: It consists of your own service to yourself.

Answered: 1 week ago