Podcast
Questions and Answers
What is the duration of the final exam in the course?
What is the duration of the final exam in the course?
Which topics are included in Section A of the final exam?
Which topics are included in Section A of the final exam?
What is NOT a requirement listed for the final exam resources?
What is NOT a requirement listed for the final exam resources?
In the context of database design, what do weak entities typically need?
In the context of database design, what do weak entities typically need?
Signup and view all the answers
Which of the following is NOT an operation in Relational Algebra?
Which of the following is NOT an operation in Relational Algebra?
Signup and view all the answers
What type of key ensures referential integrity in a relational database?
What type of key ensures referential integrity in a relational database?
Signup and view all the answers
What is the main focus of the Database Development Life Cycle (DDLC)?
What is the main focus of the Database Development Life Cycle (DDLC)?
Signup and view all the answers
Which of the following is a characteristic of a conceptual data model?
Which of the following is a characteristic of a conceptual data model?
Signup and view all the answers
Study Notes
Database Design
- Semester 1 course
- Presented and prepared by Denise Allen
- Email: [email protected]/[email protected]
Course Update
- Week 13
- Lecture Test 2: Thursday, November 21, 4:30 PM - 6:00 PM
- Lab Test: Week of November 18
- Exam Update
Final Exam - Study Guide
- Duration: 2 hours and 15 minutes
- Questions required: Four (4)
- Number of sections: Three (3)
- Section A: 60 points, 2 questions on conceptual modelling and SQL
- Section B and C: 20 points each, 1 question to choose from 2
Resources
- Good pencil (more than one)
- Sharpener
- Ruler
- Eraser
- Pens
- ID
- Punctuality
- Brain
Topics - Unit Three: Conceptual Data Modelling
- Only the notation used in the lecture is accepted.
- Identify and use constructs in the design of a conceptual data model, such as:
- Object/entity
- Weak entities
- Strong entities
- Relationships (weak and strong)
- Attributes
- Aggregates
- Generalization and specialization
- Participation of relationships
- Cardinalities
Topics - Unit Four: Relational Database Model
- Convert a conceptual model into a relational model normalized to at least Fourth Normal Form using conversion rules.
- Topics include:
- Entity integrity
- Referential integrity
- Foreign keys
- Primary keys
- Composite, candidate, super keys
Topics - Unit Seven: Introduction to SQL
- Topics for this unit are:
- DDL (Data Definition Language): create table, alter table, etc.
- DMLs (Data Manipulation Language): update, delete, select, etc. for multiple tables
- Joins and sub-queries
- Views
- Aggregate functions (max, min, avg)
Topics - Unit Two: Database Planning and the DDL
- Notes are on Moodle
- Topics include:
- Strategic Database Planning: description, purpose, and relevance
- The Database Development Life Cycle methodology
- The ANSI/SPARC three-level database architecture
- Understanding basic characteristics of conceptual data models (Network, Relational, Object-Oriented, Hierarchical)
Topics - Unit Five: Relational Algebra and Relational Calculus
- Relational Calculus is not tested.
- Relational Algebra operations: union, intersection, difference, product, select, project, join (natural, theta, outer), rename, assignment.
- Formulate solutions to specific queries using Relational Algebra.
Topics - Unit Six: Alternatives to Databases
- Understand the different types of data (structured, semi-structured, unstructured) and examples.
- Characteristics of NOSQL and RDBMS, advantages and disadvantages of each.
- Use JSON and XML to represent given sets of data.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Related Documents
Description
Prepare for your Database Design Semester 1 final exam with this comprehensive study guide. It includes essential topics on conceptual data modeling, SQL, and various entities and relationships crucial for your understanding. Make sure to review the required materials to excel in the upcoming tests.
