Explain and use the concepts of primitive types, variables, and variable assignment. [CSCI 1100] Develop and use boolean expressions comprising relational and logical operators. [CSCI 1100] Develop a program to solve simple problems by decomposing the problem into simple tasks, implementing procedures to solve the tasks, and composing the procedures to solve the original problem. [CSCI 1100]
Describe what business rules are and how they influence database design.Determine F-closure of functional dependency sets using Armstrong's axioms and determine the X-closure of attribute sets.Derive business rules from specifications.Describe the difference between data, information, and knowledge.Describe the purpose, function, evolution, variants, and the components of database and database management systems.Translate business rules into database table and relationship designs.Describe the properties of multiuser database transactions (ACID+S).Describe the purpose, function, evolution, classification, and building blocks of data models and data modeling.Perform standard relational algebra and calculus operations.Describe the basic components of a relational model and how relations are implemented.Describe the mechanisms and role of concurrency control in database integrity.Describe the purpose, function, and importance of a data dictionary, system catalog, and indexing.Differentiate between on-line transactional process (OLTP), on-line analytical process (OLAP), and knowledge discovery from data.Use the basic SQL data definition and manipulation operations.Construct an entity relationship diagram (ERD).Describe the main characteristics of entity relationship components and how relationships between entities are defined.Explain what database recovery management is and its role in database integrity.Identify the keys of a relation, and prime and nonprime attributes using formal database design theory.Convert a relation to first, second, third, or Boyce-Codd normal form.Describe what normalization is and its role in database design.Prove that a relation is in second, third, or Boyce-Codd normal form.Perform a denormalization of a database.