Database Design and Development Topic: Overview of Normalisation concepts MCQs and True/False i. The advantages of normalisation include ________. the elimination of modification anomalies the elimination of duplicated data more complex SQL for multitable subqueries and joins simpler SQL queries ii. The defining characteristic of BCNF is that a table is in BCNF if ________. … Read more
Database Design and Development Topic: Structured Query Language (SQL) – Part 1 MCQs i. SQL stands for Standard Query Language. True/False ii. The SQL keyword LIKE is used in SQL expressions to select partial string values. True/ False iii. In an SQL query, which SQL keyword actually begins the query? EXISTS FROM SELECT WHERE iv. … Read more
What do you understand by a strong entity and a weak entity? Provide example. A strong entity is complete by itself and is not dependent on any other entity type. EXAMPLE customer(customerID, name,surname) A weak entity is dependent on a strong entity to ensure its existence. Adress(addressid, adressName, customerid) i. What do you mean by … Read more