데이터베이스정리2 Database Systems 1. What is database? Motivation Database Organized collection of inter-related data that models some aspect of the real-world. Databases are one of the core components of most computer applications Database Examples Universities: Registration, grades Financial market credit card transactions Sales and purchases information of stocks and bonds Real-time market data Enterprise information Sales: c.. 2023. 10. 26. Database Theory 당시에는 정말 나의 피땀을 갈아넣어 만든 정리 노트... 데이터베이스 정말 열심히 했었더랬다. ㅎ 데이터 베이스를 사용하는 방법 (how to work?) Data model Relational Data model → R - DBMS Relational algebra SQL: Structured Query Language SQL DML: SELECT, INSERT, UPDATE, DELETE, JOIN, WITH SQL DDL: CREATE. ALTER, DROP ER Diagram, NORMALIZATION Transaction Key, Constraints, Views Procedures, Functions, Trigger 데이터 베이스 내부 동작(how it works?) Transactions D.. 2022. 8. 4. 이전 1 다음
