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
Computers and Technology, 22.06.2019 02:30
The can be used to paste text in any order
Answers: 1
Computers and Technology, 22.06.2019 16:30
Technician a says that a dry sump system uses no oil storage sump under the engine. technician b says that a wet sump system uses no oil storage sump under the engine. who is correct?
Answers: 3
Computers and Technology, 23.06.2019 02:00
Arecipients list has been loaded into a document. which commands should be clicked in order to filter the list so that letters will not be printed for recipients who live in a certain state? mailings tab, start mail merge, select recipients, type new list, then insert only contacts from the desired states mailings tab, rules, select recipients, use existing list, then choose a recipients list that includes only contacts in certain states mailings tab, select recipients, use existing list, rules, fill in, then type in certain states mailings tab, rules, skip record select “state” under field name, then type in the state name under “equal to”
Answers: 2
You have been shortlisted for interview at Salimia Ltd, a new established company operating from Rui...
Chemistry, 29.10.2020 06:20
History, 29.10.2020 06:20
Spanish, 29.10.2020 06:20
Advanced Placement (AP), 29.10.2020 06:20
Social Studies, 29.10.2020 06:20
Geography, 29.10.2020 06:20
Physics, 29.10.2020 06:20
Biology, 29.10.2020 06:20
Mathematics, 29.10.2020 06:20
Biology, 29.10.2020 06:20
Mathematics, 29.10.2020 06:20
History, 29.10.2020 06:20
Mathematics, 29.10.2020 06:20