Ahalia sports club stores information about the sports activities they conduct regularly. The members of the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Ahalia sports club stores information about the sports activities they conduct regularly. The members of the club use items such as helmets, pads etc. supplied by the center. These items belong to different types and categories and they are supplied by different suppliers. Every sports activity is identified by an activity code, activity name, and activity description. The supplier details such as supplier code, supplier name, supplier address and supplier email are stored by the centre. Every category of item is identified by an Item Category code and Item Category name. Every item type is identified by an Item Type code, Item Type name and Item Category code. Every item is identified by an Item id, Item name, Item Type code, and Item description. Every item is supplied by one or more supplier, and a supplier supplies one or more items. When a supplier supplies an item, the quantity, price and the data of supply is recorded by the club. Every item is used in one or more sports activity and in a sports activity, one or more items are used. When an item is used in a sports activity, the hours of usage must be considered. Explain each query in your own words. 1) Write the schema of the appropriate relations for the above scenario. Identify the primary key and the foreign key in each of the relations. [6 marks] 2) Use the designed relations to write SQL statements for the following questions: - a. Display all the items having the same price from the supply relation in the ascending order of Item price. [4 marks] b. List the number of item types in each category. Only include categories with more than items. [4 marks] c. Display the details of items that is not yet used in a sports activity. d. Display all the items supplied by the supplier 'Waleed'. e. Display the names of all item types with their category names. [4 marks] [5 marks] [4 marks] Ahalia sports club stores information about the sports activities they conduct regularly. The members of the club use items such as helmets, pads etc. supplied by the center. These items belong to different types and categories and they are supplied by different suppliers. Every sports activity is identified by an activity code, activity name, and activity description. The supplier details such as supplier code, supplier name, supplier address and supplier email are stored by the centre. Every category of item is identified by an Item Category code and Item Category name. Every item type is identified by an Item Type code, Item Type name and Item Category code. Every item is identified by an Item id, Item name, Item Type code, and Item description. Every item is supplied by one or more supplier, and a supplier supplies one or more items. When a supplier supplies an item, the quantity, price and the data of supply is recorded by the club. Every item is used in one or more sports activity and in a sports activity, one or more items are used. When an item is used in a sports activity, the hours of usage must be considered. Explain each query in your own words. 1) Write the schema of the appropriate relations for the above scenario. Identify the primary key and the foreign key in each of the relations. [6 marks] 2) Use the designed relations to write SQL statements for the following questions: - a. Display all the items having the same price from the supply relation in the ascending order of Item price. [4 marks] b. List the number of item types in each category. Only include categories with more than items. [4 marks] c. Display the details of items that is not yet used in a sports activity. d. Display all the items supplied by the supplier 'Waleed'. e. Display the names of all item types with their category names. [4 marks] [5 marks] [4 marks]
Expert Answer:
Answer rating: 100% (QA)
1 Schema and key identification Based on the given scenario the following relations can be identified ActivityActivityCode ActivityName ActivityDescription SupplierSupplierCode SupplierName SupplierAd... View the full answer
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...
-
MULTIPLE CHOICE: 6. The stage of production at which the individual jointproducts are identified is referred to as the: A. Split-off point B. Joint point C. Separate identification point D. Relative...
-
Two Situations The following situations involve the application of the time value of money concepts: 1. Sampson Company just purchased a piece of equipment with a value of $53,300. Sampson financed...
-
Devon, Inc., engaged Rao to examine its financial statements for the year ended 18-4, 18-6 December 31, 2018. The financial statements of Devon, Inc., for the year ended December 31, 2017, were...
-
One calorie is equivalent to (a) \(418.4 \mathrm{~J}\) (b) \(41.84 \mathrm{~J}\) (c) \(4.184 \mathrm{~J}\) (d) \(0.4184 \mathrm{~J}\).
-
Maria Chavez owns a catering company that serves food and beverages at parties and business functions. Chavezs business is seasonal, with a heavy schedule during the summer months and holidays and a...
-
A government is exploring various sources of public revenue to finance its expenditures, including infrastructure, healthcare, and education. One of the primary sources of revenue is taxation, which...
-
The adjusted trial balance of Carla Vista Supply Company included the following selected accounts: Sales Revenue Sales Returns and Allowances Sales Discounts Cost of Goods Sold Freight-Out...
-
6. Calculate the intensity of magnetic field at the centre of the square, if square's side is 10 cm and I= 1,5 A. (show the solution!) [3]
-
Calculate the delay cost incurred in trading the LIM order. Bradley also sees that following a 10 a.m. Federal Reserve press conference, the market rose significantly throughout that day. He wants to...
-
Which of Braggs responses regarding effective performance attribution is correct? A. Only Response 1 B. Only Response 2 C. Both Response 1 and Response 2 Alexandra Jones, a senior adviser at...
-
Identify two inappropriate themes in the partners set. Justify your response. Karen Swanson and Gabriel Russell recently co-founded Green Savanah Securities, an asset management firm conducting...
-
Which of the following qualitative considerations is most associated with determining whether investment manager selection will result in superior repeatable performance? A. Transparency B....
-
Which of the following is most likely a key consideration in investment due diligence? A. Suitability of the investment vehicle B. Back office processes and procedures C. Depth of expertise and...
-
A bakery wants to determine how many trays of doughnuts it should prepare each day. Demand is normal with a mean of 5 trays and standard deviation of 2 trays. If the owner wants a service level of at...
-
Two mutually exclusive investment alternatives are being considered. Alternative A requires an initial investment of $20,000 in a machine. Annual operating and maintenance costs are anticipated to be...
-
Create relational tables that solve the update, insert, and delete anomalies inTable 4-17. TABLE 4-17 Invoice Table ORDER CUSTOMER CUSTOMER INVOICE # DATE DATE ID NAME ITEM # DESCRIPTION QUANTITY 52...
-
Figure shows that developments in IT affect both an organizations strategy and the design of its AIS. How can a company determine whether it is spending too much, too little, or just enough onIT?...
-
The balanced scorecard measures organizational performance along four dimensions. Is it possible that measures on the customer, internal operations, and innovation and learning dimensions could be...
-
Give some examples of how CRM-enabled sales analytics can provide valuable insights at each of these stages of the customer journey: prospect (lead), initial customer contact, engagement with the...
-
Someone says: Our firm focuses on maintaining long-term relationships with our customers. We dont have to do any prospecting. Evaluate this statement.
-
Why do some salespeople not immediately embrace the use of the newest technologies? What are some ways in which a salesperson who is reluctant to adopt new technologies might be influenced to do so?
Study smarter with the SolutionInn App