Database System Questions It should be noted that in these questions they are related to each other

1. AllTaste Restaurant is a restaurant that is famous for its taste, so it has a lot of customers. All the flavors are here, serving typical archipelago food that has spread in several cities with various mainstay menus. However, even though it already has many branches and a large number of order transactions every day, AllTaste Restaurant does not yet have an application and database to manage transactions and data. Order recording and sales reports are still done manually. AllTaste Restaurant owners know that information technology can support their business, so they plan to build applications to serve food orders both offline and online.
   1. In the database design stage, it is known as bottom-up, top-down, and inside-out approaches. Explain the three approaches! In your opinion, what approach is used for database system development at AllTaste Restaurant? Explain why you chose this approach!
   2. What techniques do you use to collect information (fact-finding technique)? Give your reasons why choose this technique!

2. As a continuation of the AllTaste Restaurant database design stage above, some entity information and documents are known as follows:
   • Food Menu: food menu code, food menu name, food category, regional specialty, price, menu image (one menu can have many pictures), number of portions available per day.
   • Customer: customer code, customer's full name, place of birth, date of birth, gender, address, email, phone number, WA number.
   • Employee: employee code, employee name, phone number, position.
   • RM Branch: Branch code, branch name, address, city, phone number, WA number, email.
   • An example of a purchase receipt form as follows:

From the information above, do the normalization steps from 1NF, 2NF, 3NF, to BCNF.

3. Draw ERD from the table of results of the normalization steps in question number 2. ERD is completed with all the attributes of each entity, PK, FK, multiplicity (participation and cardinality).
4. Create an enhanced entity-relationship with ERD from question number 3, complete with participation and disjoint constraints.
5. After the database is finished, management/owners of AllTaste Restaurant need the information to assist them in making decisions, but due to the condition of the database which is spread across several regions, it becomes a challenge in accessing data. Data Warehouse (DW) which is an integrated database is the choice to answer the needs of AllTaste Restaurant management.
   1. In your opinion, what approach is appropriate for AllTaste Restaurant, Enterprise DW or Data Mart? Explain the reasons for choosing this approach! Then create the DW architecture according to the approach you choose.
   2. What data mining techniques are used to categorize the most popular food menus in each branch? Explain why choosing this technique?

P.S:

- Please answer in a proper format - Please answer in a typed or softcopy format - Please don't do it with pen or pencil, do it with software or tools - If you want to ask any question, ask it in the comment section, I will try to answer it

Thanks!

AllTaste Restaurant - South Jakarta Branch Address: Jl. Raya Rasa No.20 Jakarta Selatan, Phone: 021-59983744, WhatsApp: 08123456789 Transaction Code : 202012120 Date : 11 Nov 2020 12:00 Code - Customer : 100 - Andy, Phone number: 082123456789 Payment Type : Cash/e-payment Cashier : KSR1905 - Julia Menu Code 77 65 25 Menu Grilled Chicken Satay Tongkol Asam Padeh Sayur Lodeh Price 15000 13000 12000 10000 Quantity Discount Total (Rupiah) 2 2500 30000 2 26000 1 12000 2 20000 2500 88000 12 Discount Total Pay 2500 85500 AllTaste Restaurant - South Jakarta Branch Address: Jl. Raya Rasa No.20 Jakarta Selatan, Phone: 021-59983744, WhatsApp: 08123456789 Transaction Code : 202012120 Date : 11 Nov 2020 12:00 Code - Customer : 100 - Andy, Phone number: 082123456789 Payment Type : Cash/e-payment Cashier : KSR1905 - Julia Menu Code 77 65 25 Menu Grilled Chicken Satay Tongkol Asam Padeh Sayur Lodeh Price 15000 13000 12000 10000 Quantity Discount Total (Rupiah) 2 2500 30000 2 26000 1 12000 2 20000 2500 88000 12 Discount Total Pay 2500 85500