ICX 1 Solution

pdf

School

Memorial University of Newfoundland *

*We aren’t endorsed by this school

Course

5720

Subject

Computer Science

Date

Feb 20, 2024

Type

pdf

Pages

3

Uploaded by ElderFogHerring33

Report
Question 1 (0.25 points) Saved Which of the following statements is true of the relational data model Question 1 options: It predates the invention of the computer. It can only represent relationships between entity types It consists of tables and chairs It consists of a set of tables containing data Question 2 (0.25 points) Saved A row in a table can be represented as follows: PostalCode = {NL, NS, NB, PE, QC, ON, MB, SK, AB, BC, YT, NT, NU}, which represents the 13 Canadian provide/territory postal designations. Question 2 options: True False Question 3 (0.25 points) Saved Which of the following is NOT a relational rule? Question 3 options: A table can contain more than one primary key Multi-valued attributes cannot be contained in a table Duplicate tuples in a table are not possible Primary key attributes must have a value for each tuple Foreign key values in one table must be present as values of a primary key in another table.
Question 4 (0.25 points) Saved Which of the following statements are true? Question 4 options: Insert operations add new tuples to a relation Delete operations change existing values in a tuple by deleting old values and adding new values Update operations add new relations to a database Delete operations can lead to loss of referential integrity Question 5 (0.25 points) Saved Which of the following are possible? Question 5 options: A tuple can have a null value for a primary key A tuple can have a null value for a foreign key Every foreign key value in a table must be a primary key value in another table If you lose a foreign key, you cannot access a database in a country other than the one in which it was created Question 6 (0.25 points) Saved A superkey is another term for primary key. Question 6 options: True False Question 7 (0.25 points)
Saved Which of the following are components of a relation? Question 7 options: tables, columns, rows, values columns, rows, values tables, columns, rows values, rows, tables Question 8 (0.25 points) Saved In a relation Question 8 options: The order of rows is meaningless The order of rows is meaningful The order of rows is an indicator of the time the rows were added The rows can be interchanged with the columns
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

Related Documents

Capstone_7_1.docx
HW4.docx
SEMINAR 3.docx
INT 220 Module 2 Assignment 2-2 Cultural Comparisons (1).docx
1.4 In-Class Activity.xlsx
Excel Bite 5 __ Vlookup and What If Analysis (2).xlsx
Discussion Thread - Standards Comparison.docx
ABA 628 test.docx
DSCI 4520 - Assignment 3.docx
BAYES' THEOREM GOOD QUESTIONS.pdf
CS Final Review Document.pdf
Asg4-sftwrsec and bof (1).docx
Recommended textbooks for you
Text book image
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
SEE MORE TEXTBOOKS