Running Head: DATABASEDatabase:Name:Course:Professor:Institution:1IT: DATABASE21. A table is a collection of logical and related data recorded in rows, is part of a database(Schwalbe, 2015). The database has an organized structure containing several tables andseveral other kinds of data. Any database can be one table or several tables.2. When a database has entity integrity it means the database has a mechanism wherebytuples in a table can be pointed out uniquely by the primary key (Schwalbe, 2015). Theunique nature inhibits any null primary key value. If a database displays referentialintegrity the foreign key value matches the corresponding value in a table or the foreignkey value is zero.3. Entity integrity is vital because every search will be successful due to the uniqueness ofthe primary entries (Schwalbe, 2015). Any failure to get a match value on a row in agiven table means the data is absent from the table. Referential integrity is also vital toosince it can be hard to give a strange key value in a table when this kind of integrity isapplied.4. For any two relations to be considered as union compatible they should satisfy a group ofrequirements. The two relations should have columns that are equal in number and theircorresponding columns should have similar or compatible data types.IT: DATABASE35. For any two or more tables that do not have a union compatible trait one can use thefollowing relational algebra operators select, ...
To Order an Original Plagiarism Free Paper on the Same Topic Click Here
Other samples, services and questions:
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.