Database Design
True / False
Multiple choice
Copyright By PowCoder代写 加微信 powcoder
Fill in the blanks
Problem solving questions
What to study
Reading assignments (Chapter numbers vary based on edition)
Additional Videos and Lecture Recordings
Homework assignments and solutions
Midterm exam
Practice review questions and exercises at the end of chapters
Project and Checkpoint documents
What to check
Have access to all course materials to look up info if needed
Make sure you have proper room set up with stable Internet access and no distractions.
Know how to navigate Carmen site
Be able to track time !!!
I will be available via Zoom and e-mail during the exam to support you. We will use office hours Zoom link.
Collect requirements (users, views, constraints, tasks)
Model requirements and validate (ERD and EERD)
Map ERD to relational model
Verify model with relational algebra
Build model using DBMS (SQL)
Optimize model (Normalization and Indexing)
Build transactions and other user tools
Relational Model
Relational Algebra
Embedded SQL
Functional Dependencies
Normalization
Transactions
XML and Non Relational Databases
Final project
Database Approach
Types of Databases
Relational Database
Data Models
Database schema
Initial steps in design
Collecting user requirements
ER /EER Model
Be able to read, construct, refine using ERD and EERD notation
ER Model Concepts
Attributes
Relationships: cardinality and participation
Weak Entities
Chen notation
Min/max constraint notation
Specialization and Generalization
Union Types
Relational Model
Understanding relational data model and its components
Mapping ER /EER to relational schema: understand and apply all steps
Superkeys / Keys,etc
Primary Keys / foreign keys
Constraints
Relational Algebra
Understanding different join types
Understanding notation
Reading/writing expressions in Relational Algebra
Read and understand Relational Calculus expressions
Classification of SQL statements and terminology
Reading and writing expressions
SQL Data Definition and Data Types
Specifying Constraints in SQL
SELECT, CREATE, INSERT, DELETE, UPDATE, ALTER, DROP, etc Statements in SQL
Specifying JOIN conditions
Aggregate functions
Converting SQL statements to relational algebra and back
Embedded SQL, purpose and basic rules
Normalization
Functional Dependencies
Transitive
Understand and apply Normal Forms up to BCNF
Definitions of 4NF and 5NF and when they apply
Use of normalization
Types (cluster, hash, b-tree)
Costs vs. Benefits
Indexes in SQL: be able to understand and create SQL statements involving indexing
Joins and Indexes
Query Optimization
Transactions
Terms and definitions
Concurrency Control and Issues
ACID properties and their implementation
Transaction schedules: be able to interpret and construct
SQL implementation of transactions
Recoverable Schedules
Serial Vs. Serializable Schedules
Precedence graphs
Other DB Types: XML/NoSQL
Understand use and benefits
HTML and XML documents
Need for DTD and XML schema documents
Structured, Semistructured, and Unstructured Data
Hierarchical Vs. Relational DB
Be able to read simple XML and DTD documents and explain their structure
Non-relational DBs Vs Relational DBs
Properties and Types of NoSQL DBs
Big data, data warehouses, data mining, and BI systems
Understand Relational DB / DBMS functions and how they fit into the large picture of Information Systems world
Understand DB design process and interrelation of all steps and components
DB project development process
How to put it all together?
/docProps/thumbnail.jpeg
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com