Advanced Database Development Revision

How confident are we about the TCA?

• Very, I could take it tomorrow.

• Okay, I just need some revision.

• Not hugely confident, but I should get there.

• Absolutely no confidence at all.

Many-to-Many relationships can occur in Relational Databases

• True

• False

What is the definition of Generalisation?

• An entity is divided into sub-entities based on their characteristics.

• Extracting common properties from a set of entities to create an entity from them.

• Collecting entities together to create an entity that contains all properties.

• Simplifying complex entities.

The ANSI-SPARC Model is a formal standard for industry.

• True

• False

What are the levels of the ANSI-SPARC Model?

• Physical, Logical

• Logical, Conceptual, External

• Internal, Conceptual, External

• Conceptual, Views

Which of the following is true for Views?

• Structure data in a way that users or groups of user find intuitive

• Improve the performance of the database.

• Summarise data from multiple tables

• Restrict access to the data in such a way that a user can see and modify only what they need.

Security is...

• Protecting data against unauthorised disclosure

• Protecting data against unauthorised alteration

• Protecting data against authorised destruction

What considerations should be taken when considering Database Security?

• Legal

• Social

• Ethical

• Personal

• Operating Systems

Which of the following are types of Column Overloading?

• Alternating Attributes

• Concatenated Attributes

• Encoded Attributes

• Overlapping Attributes

In Industry we tend to Normalise to 5NF

• True

• False