Database Management Systems

953 WordsJun 14, 20124 Pages
Assignment 02 Due date: 1 August 2012 NB: Make sure you select the correct unique number for your module from those indicated below. Unique number 759546 Tutorial matter covered in the prescribed book Chapters 1 - 3: Chapter 5: Chapter 6: Chapter 7: Chapter 12: Chapter 14: Chapter 16: Revise as for Assignment 01 Entity relationship modelling Advanced data modelling Normalisation of database tables Transaction management and concurrency control Distributed database management systems Database connectivity and web development Question 1 What is a composite entity, and when is it used? [4 marks] [8 marks] Question 2 Briefly, but precisely, explain the difference between single-valued attributes and simple attributes. Give an…show more content…
Each time a new product is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. And each time the product ABC is created, the parts inventory, using PART_QOH in a table named PART, must be reduced by one each of parts A, B, and C. The sample database contents are shown in table 2. Table 2: The database for question 7 Table name: PRODUCT PROD_CODE ABC PROD_QOH 1,205 Table name: PART PART_CODE PART_QOH A 567 B 498 C 549 On the basis of the above information, answer questions 7.1 to 7.3. 7.1 How many database requests can you identify for an inventory update for both PRODUCT and PART? (2) 7.2 Using SQL, write each database request you identified in question 7.1. 7.3 Write the complete transaction(s). (2) (20) 9 EXAMINATIONS Use your my Studies @ Unisa brochure for general examination guidelines and examination preparation guidelines. 10 None OTHER ASSESSMENT METHODS 11 FREQUENTLY ASKED QUESTIONS Here are some of the questions (with their answers) that students repeatedly ask. Where can I get hold of a copy of the textbook? Rob, Coronel and Crocket (2008) is a popular database textbook that many students from different universities use. You are therefore advised to purchase the book as soon as possible. If the University bookstore does not have the book in stock, ask them to put your name on
Open Document