Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A relational database is ________________. Group of answer choices 2 or more databases that share data points with each other 2 databases with the same
A relational database is ________________.
Group of answer choices
2 or more databases that share data points with each other
2 databases with the same primary key
a database with relevant content
2 databases in the same Access project.
Flag question: Question 2
Question 210 pts
What field type would be the best for a integer based primary key?
Group of answer choices
Autonumber
Number
Short text
Long number
Flag question: Question 3
Question 310 pts
When naming a table what prefix would you use?
Group of answer choices
tbl
Table
dataSet
Mr.
Flag question: Question 4
Question 450 pts
Match the field types to the value they store.
Group of answer choices
Short text
[ Choose ] A numeric value. Any integer value between -1024 to 1023 A unique number which is automatically generated for every record. A string of alphabetical characters ranging from 0 to 2.4 billion A value that is either yes or no. A number generated based off of other data in the record An alphanumeric value up to 255 characters A date/time value.
Yes/No
[ Choose ] A numeric value. Any integer value between -1024 to 1023 A unique number which is automatically generated for every record. A string of alphabetical characters ranging from 0 to 2.4 billion A value that is either yes or no. A number generated based off of other data in the record An alphanumeric value up to 255 characters A date/time value.
Autonumber
[ Choose ] A numeric value. Any integer value between -1024 to 1023 A unique number which is automatically generated for every record. A string of alphabetical characters ranging from 0 to 2.4 billion A value that is either yes or no. A number generated based off of other data in the record An alphanumeric value up to 255 characters A date/time value.
Number
[ Choose ] A numeric value. Any integer value between -1024 to 1023 A unique number which is automatically generated for every record. A string of alphabetical characters ranging from 0 to 2.4 billion A value that is either yes or no. A number generated based off of other data in the record An alphanumeric value up to 255 characters A date/time value.
Date/Time
[ Choose ] A numeric value. Any integer value between -1024 to 1023 A unique number which is automatically generated for every record. A string of alphabetical characters ranging from 0 to 2.4 billion A value that is either yes or no. A number generated based off of other data in the record An alphanumeric value up to 255 characters A date/time value.
Flag question: Question 5
Question 510 pts
Which of the following field names matches the naming conventions for Access?
Group of answer choices
LastName
last_name
lastName
lastname
Flag question: Question 6
Question 610 pts
Why are primary keys used in data database management?
Group of answer choices
To maintain data integrity.
To save hard drive space.
As a checksum.
To verify the database is working properly.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started