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. Each AllTaste Restaurant branch has a mainstay menu that is very popular with customers, so information on the availability of the number of servings is needed to be able to serve orders. Here are two transactions (T1 & T2) that are ordering a food menu at the same time.

T1: Start the transaction at time t1, read 10 servings of food stock at t2. Because ordering one portion, the stock is reduced by 1 at t3. On t6, update the stock count, and commit to t7.

T2: Transaction T2 starts a transaction on t2, reads the number of stocks in t3 as many as 10. At t4 orders 3 portions. On t5 it updates the stock to 7 and then on t6 commits it.

As a result of the T1 and T2 transactions above, there was an incorrect amount of food stock. Make a solution with 2PL. What kinds of problems happened? Give a reason why choosing this type of problem! How much food is still available?

6. It is known that the customer table is initially stored in a centralized database server. To increase efficiency in access and operational costs, the database is distributed across several branch areas. An example of a customer table looks like this:

1. There are several types of fragmentation, explain! What type do you use when fragmentation of the table above? Explain how the fragmentation was done and give reasons why choosing this type!
2. Describe how the fragmented table looks like and describe it according to 3 rules (completeness, reconstruction, disjointness).

7. 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 Customer Code Customer Name Gender Address Branch JL Anggrek No. 200 No. 202001 John White Male Jakarta 5 Jakarta Griya Indah Blok A1/J 201001 David Ford Male No.5 Bandung, Jawa Bandung Barat JL Bandung Raya No.8 201001 Mary Howe Female RT 01/RW 04 Bandung Bandung Jawa Barat JL Petukangan No.39 202002 Susan Brand Male Jakarta RT 01/RW 03 Jakarta, Perumahan Loka No.3 203005 Julie Lee Female Jakarta Jakarta. 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 Customer Code Customer Name Gender Address Branch JL Anggrek No. 200 No. 202001 John White Male Jakarta 5 Jakarta Griya Indah Blok A1/J 201001 David Ford Male No.5 Bandung, Jawa Bandung Barat JL Bandung Raya No.8 201001 Mary Howe Female RT 01/RW 04 Bandung Bandung Jawa Barat JL Petukangan No.39 202002 Susan Brand Male Jakarta RT 01/RW 03 Jakarta, Perumahan Loka No.3 203005 Julie Lee Female Jakarta Jakarta