| Post |
|
641 Week 11 Outline on MongoDB
Posted on 11/8/2025) by Liping Liu
(641 Week 11 Outline on MongoDB) Lecture 1: NoSQL Database
NoSQL Databases do not organize data as tables linked by PK-FK relations. Instead, they may use one of the following data models:
Document Model
Graph Model
Key-value pair
Why NoSQL: prevalent use of small devices and distributed systems of apps requires flexible data structure, big data, high demand for availability... more >>
|
|
641 Week 9 Outline
Posted on 10/26/2025) by Liping Liu
(641 Week 9 Outline) Review:
1. Find employees who make more than all managers
2. Find the maximum average salaries of all departments
3. Find the number of columns in EMP table
4... more >>
|
|
641 Week 7 Outline
Posted on 10/11/2025) by Liping Liu
(641 Week 7 Outline) Warm-Up Queries:
Find the employment year of each employee
Find the departments in Dallas
Find the salesmen who were hired after 1980
--Find menagers whose name ends with M
select enamefrom empwhere job = 'MANAGER' and ename like '%M';
--Give salesman 100 commission
update empset comm = comm + 100where job = 'SALESMAN';
--handle missing values
upate empset comm = 0where comm is null;
select 12*sal + commfrom empgroup by empno;
--use nvl(comm, 0)
update empset comm = nvl(comm, 0) + 100where job = 'SALESMAN';
Lecture 1: Intermediate SQL Programming: Join is to merge two table so that the result will have all the columns and rows from both tables; matching records from the two tables are merged into one record in the pool, but the non-matching records are added to the pool with missing values for the columns of the other table... more >>
|
|
Oracle Client Setup and Account Admin
Posted on 10/5/2025) by Liping Liu
(Oracle Client Setup and Account Admin) Oracle Data Access Component for Database Programming
If you need to connect to Oracle in Visual Studio to program Oracle databases, you just need to download Oracle... more >>
|
|
324: Review I for Database Management
Posted on 9/16/2025) by Liping Liu
(324: Review I for Database Management) Concepts:
Databases
DBMS
Logical Data Models
Hierarchical Models
Network Models
Relational Models
Primary key
Foreign Key
Referential Integrity Rules
Entities
Relationships
Mapping Cardinality
Optionality
Attributes
Composite Attributes
Multi-valued Attributes
Relations
Relational Models
Recursive Relationships
Weak Entities
Super and Sub Entities
Gerund
SQL
Constraints
Oracle Meta Tables
Oracle Data Types
Skills and Techniques:
Conceptual Data Modeling (Entity-Relationship Diagramming) from the understanding of business objects and their relationships or from forms, reports, tables, and other data carrier to understand data requirements... more >>
|
|
641 Week 4 Outline
Posted on 9/15/2025) by Liping Liu
(641 Week 4 Outline) Review of Forward Engineering Rules
Where do you create foreign keys for 1:m relationships? Are FK values required?
Where do you create foreign keys for m:m relationships? Are FK values required?
Where do you create foreign keys for 1:1 relationships? Are FK values required?
How do you transform weak entities and associative entities?
Lecture 1: Grammatical Analysis for Business Data Modeling: nouns for objects or attributes and verbs for relationships
Modeling Exercise 1: Insure-A-Person Inc... more >>
|
|
324 Week 4 Outline
Posted on 9/15/2025) by Liping Liu
(324 Week 4 Outline) Review Questions:
How to handle multi-valued attributes
How to handle data on relationships
ERD ==> Relational Model Rules (L1:m, 1:1, m:m)
Course and Sections (why splits), Course and Prerequisites (Two entities or one?), Grade (where to store it), minimum grade required for prerequisites
Lecture 1: Advanced Data Modeling (Continue)
4) What about entities that are different but similar? (Chapter 3 of LIU)
Super and sub type entities: How to handle different types of entities that have many attributes in common, e... more >>
|
| Post |
