Answered step by step
Verified Expert Solution
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)
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started