Question: 1 The relational database model is named after the mathematical term for a two - dimensional table. True O False 2 ) Consider the following

1 The relational database model is named after the mathematical term for a two-dimensional table. True O False 2) Consider the following table. The area in the red rectangle represents which data element? First Name Deanne Santos Ronda Kory Charlene Tracy Marquis Regina Francesca Reba Hattie Luke Last Name Abbott Adams Adkins Adkins Adkins Aguilar Aguilar Aguirre Alexander Allen Allison Allison Salary $29,400 $25,400 $82,200 $73,000 $61,200 $27,200 $14,300 $62,600 $48,200 $43,500 $62,500 $76,900 O A relationship O A record An attribute O A table 3 Which of the following issues do we try to address when designing database tables? Data integrity Data quality Ensuring each table contains data about only one theme O Limiting duplicated data Each of the above statements are true This question may not have been answered. 4 Which of the following is true about database columns? Database tables may not have more than three columns No two columns on the same table can have the same name Database columns must appear in alphabetical order Two columns can contain the same information This question may not have been answered. 5 Which of the following would be an appropriate domain for a table column that contains information about a the age of people? A set of three-digit positive numbers. O A set of up to 10 letters and numbers. A set of positive and negative numbers. O Any of these would be appropriate. This question may not have been answered. 6 Which of the following is true about database rows? Information about the same instance can be split across rows They contain information about many instances of the table They contain information about only one instance of the table None of the above statements are true about database rows This question may not have been answered. J 7) Which of the following best describes what a database management system tool is used for? Used to optimize data storage, enhance data quality, and prevent unwanted access to data. Used to optimizes data storage, preserve data quality, and provide access to data. Used to maximize data storage, preserve data quality and prevent unwanted access to data. Used to minimize data storage, enhance data quality, and provide access to data. 8 Why is it important to Normalize data in a database? Duplicate data can lead to problems over time. Reduces the need to updated in multiple places. Ensures that each table contains data about very specific things. All of the above are important for a Normalized database. This question may not have been answered. 9) Which of the following would not be descriptive as a heading for a column that contained text about what an employee does? JobNumber O Position O Title Job Title This question may not have been answered. 10) Which of the following should not use a domain of text? O Zip Code StreetAddress LastName O Birthdate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!