C170 Data Management - Applications Questions and Answers (100% Correct Answers) Already Graded A+

For Expert help and assignment handling,
1





C170 Data Management - Applications
Questions and Answers (100% Correct
Answers) Already Graded A+
What are some examples of Relational databases? Ans: - MySQL


- Oracle
© 2026 Assignment Expert




- SQL Server


- DB2
Guru01 - Stuvia




what are the aspects of the relational model as it applies to databases?
Ans: 1. Data structure that prescribes how data is organized.


2. Operations that manipulate data structures.


3. Rules that govern valid relational data.


Define Structural Rules Ans: Rules that govern data in every relational
database. Ex:


- unique primary key


- unique column names


- no duplicate rows

, For Expert help and assignment handling,
2




What is data independence? Ans: rows and columns of a table have no
inherent order and their order does not impact query results.


Referential Integrity Ans: requires that all foreign key values must either
be fully NULL or match some primary key value


what are the 4 ways referential integrity can be violated? Ans: 1. a
primary key is updated
© 2026 Assignment Expert




2. a foreign key is updated


3. a row containing a primary key is deleted
Guru01 - Stuvia




4. a row containing a foreign key is inserted


what is the most important normal form? Ans: Boyce-Codd Normal Form
(BCNF)


rules for first normal form (1NF) Ans: - Table has a unique primary key
(simple or composite)


- No rows or columns are duplicated (all fields and records are unique)


- no cells contain a NULL value


- no cells contain multivalued fields


rules for second normal form (2NF) Ans: a table that is in 1NF and has a
simple primary key is automatically in 2NF.