DSO34AT-Faculty of Information and Communication Technology – IT Computer Science Assignment Help

Assignment Task

Task 

1. The year is 2026, you’re are an Elon Musk level of Billionaire, but a lot more eccentric! You decided to buy all KFC, McDonalds and Nandos and any similar establishments in South Africa. You now want to develop a system that can be used at all establishments. 

1.1. You still want these chicken outlets to still retain their current names, addresses, menus and different prices. 

1.2. For now, the system must be able to record sales at each of these outlets as shown on the receipts. To help you with this:

1.2.1. Collect receipts/slips from each of the three chicken fast-food outlets.

1.2.2. Identify similar features on each of the receipt – e.g. there might be order number and cashier name/number on each of the receipt, irrespective of whether it is from KFC, Nandos or McDonands.

1.2.3. Develop ERD that can be able to record all details reflected on receipts and any more details you night deem necessary for the system.

Criteria

• Are the table in 3rd Normal Form? If Not- why?
• Is there any EERD from the resulting DB design?
• Are tables created on a DBMS and populated with example data, at least 5 records in each table?
• Has the ERD been drawn automatically using DBeaver or other tools?
• Has the business rules been stated for each relationship?
• Is there an SQL query to generate a receipt for a certain purchase at two different shops?

This DSO34AT-IT Computer Science Assignment has been solved by our IT Computer Science Expert at TV Assignment Help. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. 

You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.