Solve both part Question A3Happy Shop sells different products to the customers. A customer could buy one or more productsat a time. An invoice will be issued to a customer for cach purchase. Table I is used to record allthe data in the shop.Product ProductPriceCustomer Customer InvoiceID001001001002DateQuantityNameHelenNoID21/3/2022N123N123P12$503.HelenHelen21/3/202225/3/202228/3/2022P13P12$67$50$87N1247MaryN125P14003DavisN12628/3/2022P12$503.N126$2628/3/2022Table 1: Happy Shop Database003DavisP156.(a) Identify the primary key with minimum number of attributes of Table 1 and discussTHREE different update anomalies in Table I with examples.(b) State the nomal form that Table 1 belongs to. Then, normalize Table 1 to 3NF by showingthe table schema for each table.

Ans: The primary key for the given table is customer ID. The 3 different update anomalies are as…

Happy Shop sells different products to the customers. A customer could buy one or more products at a time. An invoice will be issued to a customer for cach purchase. Table 1 is used to record all the data in the shop. Customer Customer Invoice Name Product Product Price $50 $67 Date Quantity ID No ID Helen Helen Helen Mary Davis Davis 001 N123 21/3/2022 3. P12 P13 21/3/2022 25/3/2022 28/3/2022 28/3/2022 28/3/2022 001 001 N123 N124 N125 N126 N126 Table 1: Happy Shop Database P12 $50 002 P14 $87 2. 003 P12 $50 3 003 PIS $26 (a) Identify the primary key with minimum number of attributes of Table 1 and discuss THREE different update anomalies in Table 1 with examples. (b) State the nomal form that Table 1 belongs to. Then, normalize Table I to 3NF by showing the table schema for each table.

Happy Shop sells different products to the customers. A customer could buy one or more products at a time. An invoice will be issued to a customer for cach purchase. Table 1 is used to record all the data in the shop. Customer Customer Invoice Name Product Product Price $50 $67 Date Quantity ID No ID Helen Helen Helen Mary Davis Davis 001 N123 21/3/2022 3. P12 P13 21/3/2022 25/3/2022 28/3/2022 28/3/2022 28/3/2022 001 001 N123 N124 N125 N126 N126 Table 1: Happy Shop Database P12 $50 002 P14 $87 2. 003 P12 $50 3 003 PIS $26 (a) Identify the primary key with minimum number of attributes of Table 1 and discuss THREE different update anomalies in Table 1 with examples. (b) State the nomal form that Table 1 belongs to. Then, normalize Table I to 3NF by showing the table schema for each table.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 6RA

See similar textbooks

Similar questions

The table below lists customer/car hire data. Each customer may hire cars from various outlets. A car is registered at a particular outlet and can be hired out to a customer on a given date. carReg make model custNo custName hireDate outletNo outletLoc M565 OGD Ford Escort C100 Smith, J 14/5/98 01 Bearsden M565 0GD Ford Escort C201 Hen, P 15/5/98 01 Bearsden N734 TPR Nissan Sunny C100 Smith, J 16/5/98 01 Bearsden M134 BRP Ford Escort C313 Blatt, O 14/5/98 02 Kelvinbridge M134 BRP Ford Escort C100 Smith, J 20/5/98 02 Kelvinbridge M611 OPQ Nissan Sunny C295 Pen, T 20/5/98 02 Kelvinbridge The table shown above is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table.
PATHS is a table that contains information about paths on a number line. The structure of PATHS is as follows, where x1 and x2 represent that there is a path from Coordinate x1 to Coordinate x2 (You can't move from Coordinate x2 to Coordinate x1 ). NAME ΤΥΡE NULLABLE X1 INT FALSE X2 INT FALSE Problem Please write an SQL statement that returns the beginning and end point of each path in PATHS . Sort them by the value of the beginning point in ascending order. Constraints • In the case where a direct path from Coordinate a to Coordinate b is available, no path from Coordinate b to Coordinate a will be given. |x1-x2| = 1 • No path will overlap with one another. Example Suppose that PATHS is as follows: x1 x2 1 2 2 3 4 7 7 6 This table can be visualized as follows: START END END START 7 8. 9 Therefore, your SQL statement must return the following: start end 1 4 8 6
Department DepartmentID DName ContactNo 1 UIIT 0300-1234567 2 UIMS 0300-4567891 Student RollNo Sname Fname DepartmentID 111 Ali Ahmed 1 112 Sana Waqar 2 113 Afzal Ikram 2 There are only two departments and are already initialized globally, but students can be upto 100 and just defined globally. To maintain how many student’s record have been entered you can use global variable with name as count. Write a C++ program having: Structures, structure definitions and required initializations for the above scenario. Function which takes input data (RollNo, Sname, Fname and DepartmentID) of student from user within the function, then verify that the DepartmentID exists in Department or not? If exists then copy DName and ContactNo in the student record along with above input, otherwise just display a message that department does not exists. For example the following record will not be allowed to store in the…
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
calculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal") , or ("description", amount, "deposit"). The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100
Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered To Price per Roll From 1 70 $215 71 140 $195 141 280 $175 281 and up $155 Click on the datafile logo to reference the data. DATA file (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. (b) Use the COUNTIF function to determine the number of orders in each price bin. From Number of To Price per Roll 70 $215 !!! 140 $195 280 $175 and up $155 1 71 141 281 Orders 172
Task 3: List the customer ID, first and last names, and balance for all customers. The balance should be rounded to the nearest dollar.
Task 4: KimTay Pet Supplies is running a promotion that is valid for up to 20 days after an order is placed. List the INVOICE_NUM, CUST_ID, FIRST_NAME, LAST_NAME, INVOICE_DATE, and the promotion date for each invoice as PROMOTION_DATE. The promotion date is 20 days after the invoice was placed.
1- List all the users and their card name using union2- List all the users and their card name using Intersection 3- List all the card numbers with owner names and scheduled transactions, in case the user hasnever used scheduled transaction show null or zero in the transaction column. (Hint use ISNULLfunction)
Based on the ERD below, write the SQL statement to display the average hourly job charge for a job.
Task 14: List the invoice number and invoice date for each invoice that contains an invoice line for a Wild Bird Food (25 lb).
Find your group number• The remainder after division of second to last digit of your student id by 3 is a.• The last digit of your student id is b.• Your group number is ab, which is an integer between 0 and 29.• If your group number is equal to ab=00 then take it as ab=01.Examples:• Student Id = 290316027 → Group = 27• Student Id = 290315043 → Group = 13• Student Id = 280315061 → Group = 01• Student Id = 270316085 → Group = 25• Student Id = 290315027 → Group = 27 my student Id is 280316014 but i didnt calculate ab.Can you help me .Thank you.