Database Course Curriculum Quiz

What is the relational model, and what are its advantages?

• Data Independence

• Faster Query Execution

• Increased Data Redundancy

• Direct Data Manipulation with Machine Code

What are entity-relationship diagrams and their components?

• A graphical representation of a database's physical storage structure

• A tool used to map database tables to XML files

• A visual representation of entities, attributes, and relationships in a database

• A diagram that shows the flow of data between different computer systems

What are the basic operations in relational algebra?

• Selection (σ)

• 
  Looping

• Sorting (Sort)

• Summation (Σ)

What is the process of creating ER diagrams?

• Identify Entities and Relationships

• Write SQL Queries First

• Assign Primary Keys Later

• Start with Normalization

How do you convert ER diagrams into relational schemas?

• Ignore Relationships

• Convert Entities into Tables

• Use Only One Table for Everything

• Skip Attributes

What are the fundamental SQL queries?

• RETRIEVE

• FETCH ALL

• SELECT

• SHOW DATA

What are advanced SQL queries and how are they written?

• SELECT INTO for Copying Data Between Tables

• Using LOOP in SQL Queries

• Ignoring Indexes in Complex Queries

• Using JOINS for Combining Tables

What are aggregate functions in SQL?

• MULTIPLY()

• SUM()

• COUNT(ALL)

• DIVIDE()

What is database normalization and its normal forms?

• 1NF ensures atomicity of data

• 2NF allows partial dependency

• 3NF permits transitive dependency

• Normalization increases redundancy

What are the ACID properties in transaction management?

• Atomicity ensures complete execution or rollback

• Consistency allows invalid data

• Isolation means transactions must run sequentially

• Durability means changes can be lost after a crash