Computers and Technology, 25.02.2021 15:20 cookies1164

You have been shortlisted for interview at Salimia Ltd, a new established company operating from Ruiru, Kenya. You had applied for the position of a database specialist and the need you to demonstrate your understanding of the concept of entity relationship modelling, data normalisation and SQL using the following sample invoice that they generate using Ms excel. They wish to automate the invoicing section first before they move to the other departments. The system should generate the customer statements and other relevant records to enable the account finalise the accounts receivables. Required
a)Give the information that will be in the UNF (5 Marks)
b)Normalise to the First normal form (5 Marks)
c)Normalise to the second normal form (5 Marks)
d)Normalise to the third normal form (4 Marks)
e)Draw the entity relationship diagram giving the requisite attributes (6 Marks)

QUESTION TWO
Using the case study in Question ONE
a)Write the SQL command to create the tables specifying the primary keys (4 Marks)
b)Write the SQL command to retrieve the aLL the invoices for customer account number 5652 (4 Marks)

c)Write the SQL command to order all the invoices in order to facilitate the printing of customer statements (4 Marks)
d)Write a procedure to increase prices of the items that they sell by 5% (4 Marks)
e)Write a trigger to give an alert when the price of a product or quantity is changed in the the database (4 Marks)
f)How will the system handle the receipts issued when the customers are settling the outstanding invoices? Capture the suitable information in the receipts file (5 Marks)

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 21:30

After you clean an engine with hot water spray, it seems to stall; when it doesn't stall, it's idling noisily. technician a says to check for loose bolts on the flex plate near the torque converter. technician b says to wipe down the spark plug wires and the distributor cap. who is correct? a. technician a b. both technicians a and b c. technician b

Answers: 1

Answer

Computers and Technology, 23.06.2019 04:31

Jennifer has to set up a network in a factory with an environment that has a lot of electrical interference. which cable would she prefer to use? jennifer would prefer to use because its metal sheath reduces interference.

Answers: 1

Answer

Computers and Technology, 23.06.2019 14:00

Select the correct answer. andre was recently hired by an organization to check for system vulnerabilities. he is supposed to exploit these vulnerabilities and create a report on the extent of damage to which the system was susceptible. what position does andre hold in this organization? a. information security analyst b. information assurance manager c. penetration tester d. network security engineer e. chief information security officer

Answers: 2

Answer

Computers and Technology, 23.06.2019 17:10

Ac++an of of pi. in , pi is by : pi = 4 – 4/3 + 4/5 – 4/7 + 4/9 - 4/11 + 4/13 - 4/15 + 4/17 . ., to pi (9 ). , if 5 to pi,be as : pi = 4 - 4/3 + 4/5 - 4/7 + 4/9 = 4 – 1. + 0.8 - 0. + 0. = 3.. atoofbe to pi?

Answers: 2

Answer

You know the right answer?

You have been shortlisted for interview at Salimia Ltd, a new established company operating from Rui...

Questions