Database Architecture, SQL, Normalization, ER Modeling
What you will learn
Student will recognize meaning of database, DBMS, component of DBMS environment, Advantages and disadvantages of DBMS, and three-level database architecture
Student will understand terminology of relational model and how to use Entity–Relationship (ER) modeling in database design
Student will understand the purpose of normalization, data redundancy, how to identify functional dependencies, the process of normalization
Student will understand data types supported by SQL standard, how to create a table and define integrity constraints using SQL
Student will understand how to update database using INSERT, UPDATE, and DELETE, how to retrieve data from one table and multiple table using SELECT
English
language