Databases I (INF2603)

An in depth summary of chapters 1 to chapters 8 of the Databases I textbook for INF2603.

INF2603 ASSESSMENT 8 SEMESTER 2 2025 What command should be used to save permanently all changes made to a database. a. COMMIT  b. WRITE ALL c. SAVE d. SAVE ALL

INF2603 ASSESSMENT 8 SEMESTER 2 2025 The RDBMS automatically creates the ____ tables in which to store metadata. a. data schema b. data dictionary  c. data authorization d. data appendix

INF2603 ASSESSMENT 8 SEMESTER 2 2025 Use the value ____ to insert a row with some blank data. a. 0 b. BLANK c. [blank] d. NULL

INF2603 Assignment 5 (DETAILED ANSWERS) 2025 - DISTINCTION GUARANTEED - DISTINCTION GUARANTEED - DISTINCTION GUARANTEED Answers, guidelines, workings and references ,... Without using chartGP and examples from the book provide an example to emphasize your case, describe the situations when a 3rd NF relation is in BCNF and when it is not. Because you are a registered student at UNISA and you have classmates who are your friends, please write SQL code to enter your own correct information and also...

Achieve a distinction with this comprehensive and well-organized set of INF2603 Assignment 5 (ANSWERS) 2025 - DISTINCTION GUARANTEED. Ensure accuracy and excellence in your submission!!!! Without using chartGP and examples from the book provide an example to emphasize your case, describe the situations when a 3rd NF relation is in BCNF and when it is not. Because you are a registered student at UNISA and you have classmates who are your friends, please write SQL code to enter your own correct in...

INF2603 Assignment 5 (COMPLETE ANSWERS) 2025 (865742) - DUE 5 September 2025; 100% TRUSTED Complete, trusted solutions and explanations. For assistance, Whats-App 0.6.7-1.7.1-1.7.3.9. Ensure your success with us.... Without using chartGP and examples from the book provide an example to emphasize your case, describe the situations when a 3rd NF relation is in BCNF and when it is not. Because you are a registered student at UNISA and you have classmates who are your friends, please write SQL code ...

INF2603 ASSIGNMENT 6 SEMESTER 2 2025

INF2603 ASSIGNMENT 6 SEMESTER 2 2025 EXCEL The "____" characteristic of a primary key states the following: The selected primary key must not be composed of any attribute(s) that might be considered a security risk or violation. For example, using a Social Security number as a PK in an EMPLOYEE table is not a good idea. a. unique values b. nonintelligent  c. preferably single-attribute d. security compliant The correct answer is: security compliant Question 2 C...

NF2603 ASSIGNMENT 6 SEMESTER 2 2025 ____ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes. a. Specialisation b. Generalisation  c. Partial completeness d. Total completeness The entity supertype contains the common characteristics and the entity subtypes contain the unique characteristics of each entity subtype. True  False