Review Questions

$1.$ What are the advan

tages of organizing data storage as separate files?

$2.$ What are the advantages of organizing data storage using a database approach?

$3.$ What are the effectiveness measures of database design?

$4.$ Explain the need for a relational database for PCs$.$ What improvements has it seen over the years?

$5.$ Give two examples of a primary key that can be used to identify a person or a thing.

$6.$ What is the difference between a primary key and a secondary key?

$7.$ Define the term metadata. What is the purpose of metadata?

$8.$ Define relationships. List some examples of relationships that exist between entities.

$9.$ What are E$-$R records?

$10.$ What is an entity subtype?

$11.$ List the different file types, their purpose, and their examples.

$12.$ Explain the role of the logical and physical views of data in database design.

$13.$ List the three steps used to normalize a relationship or a data structure.

$14.$ List the three entity constraints. In a sentence, describe the meaning of each entity constraint.

$15.$ Describe the four anomalies that may occur when creating database tables.

$16.$ Explain with examples how a one$-$to$-$many relationship can be implemented in Web design.

$17.$ List the guidelines for designing master files or database relations.

$18.$ Define denormalization.

$19.$ Explain the differences between traditional databases and data warehouses.

$20.$ List the problems with data mining.

$21.$ List five methods of analyzing business intelligence $($BI$).$

$22.$ What is big data?

$23.$ Explain the analyst$$s role in data analytics.

$24.$ What is a blockchain network? Provide an example from business.

$25.$ What are the four critical features of a blockchain network? List them.