CIS105: Computer Applications & Information Systems Lect. 18 - toshiki-notebook

Housekeeping:

• Zoom Office Hours: Tuesday April 23rd and 25th, no class starting today.

18.1: Datase Overview ​

• Column = Field
  
  
  
  • AKA attributes
  
  
  
  


• Tables hold database data


• DBMS


• Oracle

18.2: Database Structure ​

• Entity Relationship Modeling (ERM): a database-modeling method used to construct a theoretical and conceptual representation of data to produce a schema.
  
  
  
  • Tables
  
  
  • Reports
  
  
  • Queries
  
  
  • Forms
  
  
  
  


• DBAs still need to know the business.

18.3: Business Database Advantages ​

• Data Validation


• No Errors + No Repeats = Data Integrity


• GIGO: Garbage-in-Garbage-Out

18.4: Structured Query language ​

• Most widely used query language


• SQL Clauses for updating fields:
  
  
  
  • APPEND
  
  
  • DELETE
  
  
  • UPDTE