Database Systems Concepts & Design
Database systems are part of the management system which functions when the application of theoretical foundation of relational databases are done. Specific query languages are used to create SQL data structure, which meets the specified requirements.
You are taught in this Database Systems Concepts & Design how requirement analysis, specification, design, and implementation are implemented in the real world projects. After taking this course, you will be able to create relational database application and know how to evaluate alternative internal schema structures.
Assessment
This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.
Certification
Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.
Having an Official Edukite Certification is a great way to celebrate and share your success. You can:
- Add the certificate to your CV or resume and brighten up your career
- Show it to prove your success
Course Credit: Georgia Institute of Technology via Udacity
Course Curriculum
Module 1: Course Overview | |||
Welcome Video | 00:01:00 | ||
Module 2: Fundamentals of Databases | |||
(headshot) Introduction | 00:01:00 | ||
Overview | 00:01:00 | ||
Why Use Models | 00:01:00 | ||
A Map is a Model of Reality | 00:01:00 | ||
Map Example v3 | 00:02:00 | ||
A Message to Model Makers | 00:01:00 | ||
To Use or Not To Use | 00:01:00 | ||
To Use | 00:02:00 | ||
Not To Use | 00:01:00 | ||
Outline of Major Topics | 00:01:00 | ||
Data Modeling | 00:01:00 | ||
Process Modeling | 00:01:00 | ||
Data Models-Architecture DBMS Architecture | 00:01:00 | ||
Examples of Data Models | 00:01:00 | ||
Relational Models Data-Structures | 00:01:00 | ||
Relational Model-Constraints | 00:01:00 | ||
Data Model-Operations | 00:01:00 | ||
Keys and Identifiers | 00:01:00 | ||
Integrity and Consistency | 00:03:00 | ||
NULL Values | 00:01:00 | ||
Surrogates Things and Names | 00:03:00 | ||
ANSI-SPARC | 00:03:00 | ||
Conceptual Schema | 00:01:00 | ||
External Schema | 00:01:00 | ||
Internal Schema | 00:01:00 | ||
Physical Data Independence | 00:01:00 | ||
Logical Data Independence | 00:01:00 | ||
ANSI-SPARC DBMS Framework, Part 01 | 00:03:00 | ||
ANSI-SPARC DBMS Framework, Part 02 | 00:02:00 | ||
Metadata-What is it | 00:01:00 | ||
Module 3: Methodology I: ANALYSIS | |||
Database Application Development Methodology-Assumptions | 00:01:00 | ||
The Software Process | 00:01:00 | ||
Overview of Methodology Data First | 00:02:00 | ||
Example Project Description | 00:01:00 | ||
(headshot) GTOnline Networking Application | 00:01:00 | ||
Analysis | 00:01:00 | ||
Analysis-Information Flow Diagram | 00:01:00 | ||
Requirements 01 | 00:01:00 | ||
Requirements 02 | 00:01:00 | ||
Requirements 03 | 00:01:00 | ||
Requirements 04 | 00:01:00 | ||
Requirements 05 | 00:01:00 | ||
IFD chart | 00:03:00 | ||
Don’t Go There | 00:01:00 | ||
Specification v2 | 00:01:00 | ||
What goes in out of the Database | 00:01:00 | ||
DETOUR: EER MODEL | 00:01:00 | ||
Module 4: Extended-Entity Relationship Model | |||
(headshot) Introduction | 00:01:00 | ||
Entity Type and Entity Surrogates | 00:01:00 | ||
Single-valued Properties | 00:01:00 | ||
Identifying Properties | 00:01:00 | ||
Composite Properties | 00:01:00 | ||
Multi-valued Properties | 00:01:00 | ||
1-1 relationship types | 00:01:00 | ||
1-many relationship types | 00:01:00 | ||
Mandatory 1-N relationship types | 00:01:00 | ||
N-M relationship types | 00:01:00 | ||
N-ary relationship types | 00:02:00 | ||
Many relationship types | 00:01:00 | ||
Identifying relationships | 00:02:00 | ||
Recursive relationship types | 00:01:00 | ||
Supertypes and subtypes-inheritance | 00:01:00 | ||
Supertypes and subtypes-inheritance | 00:01:00 | ||
Union Entity types | 00:02:00 | ||
(headshot) Thing, Relationship, Property v2 | 00:01:00 | ||
Are relationships entities? | 00:01:00 | ||
Another Example | 00:02:00 | ||
Messing with your brain part 1 | 00:02:00 | ||
Messing with your brain part 2 | 00:01:00 | ||
Relationship type or Entity type? | 00:01:00 | ||
What can the EER do? | 00:01:00 | ||
Car graphic | 00:01:00 | ||
What’s the Result Type of a Query? | 00:01:00 | ||
EER Diagram | 00:01:00 | ||
(headshot) Relational Model Theoretical Foundation v2 | 00:01:00 | ||
Relational Model | 00:01:00 | ||
Data Structures | 00:01:00 | ||
Big Deal | 00:01:00 | ||
Constraints | 00:01:00 | ||
Module 5: Methodology II: SPECIFICATION | |||
Requirements 06 | 00:01:00 | ||
Use Attribute names | 00:01:00 | ||
Requirements 07 | 00:01:00 | ||
Requirements 08 | 00:01:00 | ||
Requirements 08.1 | 00:01:00 | ||
Requirements 09 | 00:01:00 | ||
EER Mapping | 00:01:00 | ||
Reading EER Diagrams | 00:01:00 | ||
Data Formats-beg, steal, borrow | 00:01:00 | ||
Constraints | 00:01:00 | ||
Task Decomposition | 00:03:00 | ||
Web apps vs Traditional apps | 00:01:00 | ||
Task Decomposition-View Profile v2 | 00:01:00 | ||
Abstract Code-View Profile v2 | 00:01:00 | ||
Task Decomposition-Edit Profile v2 | 00:03:00 | ||
Abstract Code-Edit Profile v2 | 00:01:00 | ||
Task Decomposition Friend Requests v2 | 00:01:00 | ||
Specification | 00:01:00 | ||
DETOUR: ERR MAPPING | 00:01:00 | ||
Module 6: EER Relational Mapping | |||
EER Relational Mapping | 00:01:00 | ||
ET | 00:02:00 | ||
ET-A-F | 00:02:00 | ||
ET1-A-ET2 | 00:02:00 | ||
ET1-R-ET2-1-N | 00:01:00 | ||
ET1-R-ET2-N-M | 00:01:00 | ||
ET1-R-A-ET2 | 00:01:00 | ||
Case 1 | 00:01:00 | ||
Case 2 | 00:01:00 | ||
Case 3 | 00:01:00 | ||
Case 4 | 00:01:00 | ||
ET-B-ET1-ET2 | 00:01:00 | ||
Module 7: Methodology III: DESIGN | |||
Design | 00:01:00 | ||
EER Diagram Review 1 | 00:01:00 | ||
EER Diagram Review 2 | 00:03:00 | ||
Mapping the Super Subtype v2 | 00:02:00 | ||
Weak Entity Type Mapping | 00:01:00 | ||
Relational Schema | 00:01:00 | ||
DETOUR: NORMALIZATION | 00:01:00 | ||
Module 8: Normalization | |||
Normalize | 00:01:00 | ||
What’s it all about? | 00:01:00 | ||
(headshot) The Rules | 00:01:00 | ||
Not a relation | 00:01:00 | ||
Relation with problems | 00:01:00 | ||
Relation with Problems-Insertion anomaly | 00:01:00 | ||
Relation with Problems-Deletion anomaly | 00:01:00 | ||
Relation with Problems-Update anomaly | 00:01:00 | ||
Information loss | 00:02:00 | ||
Dependency Loss | 00:01:00 | ||
Perfect | 00:02:00 | ||
Functional Dependencies | 00:01:00 | ||
Full Functional Dependencies | 00:01:00 | ||
Functional Dependencies and Keys | 00:01:00 | ||
Overview of Normal Forms | 00:01:00 | ||
Normal Forms-Definitions | 00:01:00 | ||
Kent and Diehr quote | 00:01:00 | ||
1NF BCNF flow chart | 00:02:00 | ||
Compute with Functional Dependencies-Armstrong’s rules | 00:01:00 | ||
How to guarantee lossless joins | 00:01:00 | ||
How to guarantee preservation of FDs | 00:01:00 | ||
Email Interest | 00:01:00 | ||
3NF and BCNF | 00:01:00 | ||
It Nevers Happens in Practice | 00:01:00 | ||
Module 9: Methodology III: Design (SQL Statements) | |||
SQL-Create Table Statements | 00:02:00 | ||
SQL-Create Tables 1 | 00:02:00 | ||
SQL-Create Tables 2 | 00:01:00 | ||
Design-on to Abstract Code | 00:01:00 | ||
SQL-View Profile 1 | 00:01:00 | ||
SQL View Profile, part 02 | 00:01:00 | ||
SQL Edit Profile, part 01 | 00:01:00 | ||
SQL Edit Profile, part 02 | 00:01:00 | ||
SQL Edit Profile, part 03 | 00:01:00 | ||
SQL Request Friend | 00:01:00 | ||
SQL View Requests | 00:01:00 | ||
SQL Accept, Reject, Cancel Friend Requests | 00:01:00 | ||
Design on to Abstract Code w SQL | 00:01:00 | ||
Module 10: Relational Algebra and Calculus | |||
Closed Algebra | 00:01:00 | ||
Relational Algebra Operators | 00:01:00 | ||
Selection | 00:01:00 | ||
Selection-Simple Expression | 00:01:00 | ||
Selection-Composite Expression | 00:01:00 | ||
Projection | 00:01:00 | ||
Relations are Sets | 00:01:00 | ||
Union-U | 00:02:00 | ||
Intersection | 00:01:00 | ||
Set Difference | 00:01:00 | ||
Natural Join | 00:02:00 | ||
Theta Join | 00:02:00 | ||
Left Outer Join | 00:01:00 | ||
Cartesian Product-X | 00:01:00 | ||
Cartesian Product-Can be Useful | 00:02:00 | ||
Divideby | 00:02:00 | ||
Rename | 00:01:00 | ||
(headshot) Relational Calculus intro | 00:01:00 | ||
Relational Caculus Expressions | 00:03:00 | ||
Selection-CALC | 00:01:00 | ||
Selection-Composite Expression-CALC | 00:01:00 | ||
Projection-CALC | 00:01:00 | ||
Union-CALC | 00:01:00 | ||
Intersection-CALC | 00:01:00 | ||
Set Difference-CALC | 00:01:00 | ||
Natural Join-CALC | 00:01:00 | ||
Cartesian Product-CALC | 00:01:00 | ||
Cartesian Product-Can be Useful-CALC | 00:02:00 | ||
Divideby-CALC | 00:02:00 | ||
Module 11: SQL | |||
(headshot) SQL Introduction | 00:01:00 | ||
SQL History v2 | 00:01:00 | ||
Insert | 00:01:00 | ||
Delete | 00:01:00 | ||
Update | 00:01:00 | ||
General SQL Query Syntax | 00:01:00 | ||
Selection-Wildcard | 00:01:00 | ||
Selection-Where clause | 00:01:00 | ||
Selection-Composite Where clause | 00:01:00 | ||
Projection | 00:01:00 | ||
Distinct | 00:01:00 | ||
Natural Inner Join-dot notation | 00:02:00 | ||
Natural Inner Join-aliases | 00:02:00 | ||
Left Outer Join | 00:01:00 | ||
String Matching | 00:01:00 | ||
Sorting | 00:01:00 | ||
Set Operations-Union | 00:01:00 | ||
Set Operations-Intersect | 00:01:00 | ||
Set Operations-Except | 00:00:00 | ||
Built in Functions | 00:01:00 | ||
Group By | 00:02:00 | ||
Having-Condition on the group | 00:01:00 | ||
Nested Queries-In/Not In | 00:02:00 | ||
Nested Queries-Some/All | 00:00:00 | ||
Nested Queries-correlated | 00:03:00 | ||
Module 12: Efficiency | |||
Efficiency/Indexing/Physical Database… | 00:01:00 | ||
Computer Architecture | 00:12:00 | ||
Computer Architecture | 00:01:00 | ||
Main Memory vs Disk | 00:01:00 | ||
Disk | 00:03:00 | ||
Blocks | 00:00:00 | ||
Files | 00:01:00 | ||
Assumptions | 00:02:00 | ||
Heap-Unsorted | 00:01:00 | ||
Heap setup | 00:01:00 | ||
Heap | 00:01:00 | ||
Sorted but | 00:01:00 | ||
Sorted Binary | 00:02:00 | ||
Sorted File | 00:02:00 | ||
1 Primary Index -Part 1 | 00:03:00 | ||
Primary Index -Part 2 | 00:03:00 | ||
Sparse Index | 00:01:00 | ||
Secondary Index | 00:03:00 | ||
Multi-Level Index | 00:02:00 | ||
Multi-Level Headshot | 00:01:00 | ||
Multi-Level Index B-Tree | 00:01:00 | ||
Static Hashing Part I | 00:01:00 | ||
Static Hashing Part 2 | 00:04:00 | ||
Module 13: Methodology IV: Implementation | |||
Implementation | 00:01:00 | ||
AMP solution stack | 00:01:00 | ||
Implementation Data First | 00:01:00 | ||
WAMP stack demos (headshot) | 00:01:00 | ||
Install the WAMP Stack | 00:01:00 | ||
Run the WAMP Stack | 00:03:00 | ||
Demo 03 | 00:01:00 | ||
To Index or Not Many Things to Consider | 00:01:00 | ||
To Index or Not Size of Table | 00:02:00 | ||
To Index or Not Multiple Access Paths add up | 00:01:00 | ||
To Index or Not Reads and or Writes | 00:01:00 | ||
To Index or Not Already Indexed | 00:01:00 | ||
To Index or Not Some Advice | 00:01:00 | ||
Implementation Tasks | 00:01:00 | ||
Run PHP Scripts for GTOnline example | 00:03:00 | ||
HTML demo | 00:01:00 | ||
Module 14: Metadata | |||
Archival Metadata Hardware used | 00:01:00 | ||
Experiences with Metadata | 00:01:00 | ||
The Question | 00:01:00 | ||
Preservation Metadata OAIS Information Model | 00:01:00 | ||
OAIS Information Model | 00:01:00 | ||
Content Information Package | 00:02:00 | ||
OAIS Information Model part 02 | 00:01:00 | ||
Preservation Description Information | 00:01:00 | ||
OAIS Information Model part 03 | 00:01:00 | ||
Standards for Archival Metadata are not mature | 00:01:00 | ||
Metadata Representation Standards | 00:01:00 | ||
Several elements are necessary | 00:01:00 | ||
Module 15: Course Wrap Up | |||
Course Wrap-Up | 00:01:00 | ||
Assessment | |||
Submit Your Assignment | 00:00:00 | ||
Certification | 00:00:00 |
Course Reviews
No Reviews found for this course.