CSCI N207 Quiz One Answers

docx

School

Ivy Tech Community College, Indianapolis *

*We aren’t endorsed by this school

Course

210

Subject

Computer Science

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by MagistrateMolePerson2564

CSCI N207 Quiz One Answers Question What is the best type for a field that is used to store US phone numbers in an Access database? Answer Short Text Number Date AutoNumber i Question Which of the following also refers to a row in a database table? Choose all that apply. Answer Record Answer Entity Attribute Field Question Which of the following is the best candidate for a table name of a table that stores degrees for major programs in a school, e.g Bachelor of Science, Bachelor of Art, Master of Science, etc ? Degree DEGREE MAJOR DEGREE Answer MAJOR_DEGREE

Question ‘What i the best field length for field whose value s the name of one of the 12 months? For instance, January, or August, o any other month. tAnswer 9 Question Which of the following follows the field name convention used in tis class? Job Description tAnswer JobDescription JOB_DESCRIPTION Job_Desciption Question Which of the following fields can be unique identifers in an employee table? Choose allthat apply tAnswer EmployeeNumber LastName tAnswer SocialSecurityNumoer DateOfBirtn

Question Ifthe ID feld in one table is a primary key and is defined as AutoNumber (long integer), what should be the field type and size of its foreign key field in another table? AutoNumber (long integer) Number (integer) Rosesy Number (long integer) AutoNumber (integer) Question Which of the following also refers to a column in a database table? Choose all that 2ppl. Answer Attibute T Answer Field Record Entiy Question 1§12, 26,9, 40, 22 are values in a foreign key feld, which of the following are values in the corresponding primary key feld? 9.9,12,22,26,40 8,9,10,15,22,26, 40 Answer 8,9,12,15,22,25,26, 40 89,1225, 40

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Question na relational database, each table can have more than one primary keys True False Question answer n 3 relational database, each table can have more than one unique identifiers True False Question answer answer 112,357 are values in a primary key field, which of the fllowing are values i the corresponding foreign key field? Choose il that apply. 1234587 7133 1258 1375

Question Answer Aprimary key must be 3 unique identifer. Question Answer What does E.R. stand for in a relational database? Entity Relationship Entiy Relations Entries and Relationships Enterprise Relationship. Question Answer In 3 relational database table, a cell can hold muttple values True False

Question Each value in a foreign key field must be unique. True answer False Question na relational database, each table must have a forsign key fild True answer False Question I3 relational database, a foreign key field must match with its primary key fied in what aspects? Choose al that apply. valve, Answer fsid type. Answer feld size field name.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Question What s the best fleld type to store customer birth dates in a CUTSTOMER table? Text Number Answer Date AutoNumber Question Which one s a better software toolto store and manage data? Excel Answer Access

Related Documents

Barnacle Lab work.docx

Quiz 1.docx

Q9.pdf

Q3.pdf

CSCI N207 Quiz Five Answers.docx

CSCI N207 Quiz Three Answers.docx

CSCI N207 Quiz Four Answers.docx

CSCI N207 Quiz Two Answers.docx

README.md.docx

4347 Project Description(1).docx

Midterm Exam-103-code1-solution.pdf

Midterm Exam-103-code2-solution.pdf

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:9781305251038

Author:Joan Casteel

Publisher:Cengage Learning

A Guide to SQL

Computer Science

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Course Technology Ptr

Principles of Information Systems (MindTap Course...

Computer Science

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

Principles of Information Systems (MindTap Course...

Computer Science

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

Database Systems: Design, Implementation, & Manag...

Computer Science

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning