Given only the following part of an E-R diagram, what does the circle across the relationship line near the entity in the figure below indicate?

d) A maximum cardinality of many

How can a multivalued attribute be represented in an E-R model?

a) Create a new dependent entity with a 1:N relationship

b) Create a new entity with an M:N relationship

c) Create a new entity with a 1:1 relationship

Which of the following is WRONG for the E-R diagram below?

d) A librarian can work more than one department

a) A librarian can supervise one librarian

b) A librarian can supervise many librarian

c) A librarian can supervise no librarian

Which of the following is not a problem associated with storing data in a file?

d) A large amount of disk space is required

a) Inconsistency occurs when a data item is used multiple times

b) Inability to store partial data

“The maximum number of courses a student can take in one term is 6.” Which constraint should be used to enforce this statement?

d) Semantic Integrity Constraint

a) Referential integrity constraint

A rule that each foreign key value must match a primary key value in the other relation is called as?

a) Referential integrity constraint

d) Semantic integrity constraint

Which of the following is not a goal of normalization?

a) Maximizing data storage space

c) Simplifying the enforcement of referential integrity

d) Maintaining data effectively

Which of the following is wrong?

a) A relation includes a foreign key matching the primary key of other relation is called an insertion anomaly

b) If the removal of data in one entity results in the unintentional loss of data in another entity is deletion anomaly

c) A relation is in 2NF if and only if it is in 1NF and all non-key attributes are determined by the entire primary key

d) The condition that a non-key attribute determines another non-key attribute is known as transitive dependency

Which of the following sentences is incorrect?a)

a) Dependency preserving implies lossless join and vice-versa.

b) Lossless join decomposition must be achieved at all times.

c) Functional Dependencies are a kind of integrity constraints.

d) BCNF is not always achievable.

Given the table Instructor (InstructorID, Name, Course) , which of the following SQL statements would be used to add new instructor data to the Instructor table?

b) INSERT INTO Instructor VALUES (1111, ‘David’, ' CS 2204')

a) INSERT INTO Instructor SET InstructorID =1111, Name=David, Course =CS 2204

d) INSERT INTO New Instructor VALUES (1111, ‘David’, ' CS 2204')

d) INSERT INTO Instructor VALUES (‘David’, 1111, ' CS 2204')

CREATE TABLE BOOK ( BookID CHAR(20) NOT NULL, Title VARCHAR(30) NOT NULL, PublisherName VARCHAR(20), PRIMARY KEY (BookID) ); Considering SQL statement above, which of the following is wrong?

a) PublisherName can’t be null

b) The name of the created table is BOOK

c) There are three columns in this table

d) Primary key of this table is BookID

Exam Practice CS2203 - Databases 1

Authored by Darlene M

English

University

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

171 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The address of a student can be defined using street, city, state, and zip code. What type of attribute should be used to represent the address of a student?

a) Single valued attribute

b) Multi-valued attribute

c) Derived attribute

d) Composite attribute

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

For the relationship represented in the figure below, which of the following is true

a) An instructor can teach more than one course but does not have to teach any course

b) An instructor must teach at least one course

c) A course has to be taught by more than one instructor

d) A course can be taught by more than one instructor but doesn’t have to be taught by any instructor

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In an Entity-Relationship model, which concept is generally used to represent a student?

a) Entity

b) attribute

c) constraint

d) Relationship set

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

For the relationship represented in the figure below, which of the following is true?

a) Each instructor teaches one or more courses

b) Each instructor has one and only one course

c) Each course is taught by zero and one instructor

d) Each course is taught by many instructors

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The E-R model is used to build a conceptual model.

a) True

b) False

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Given only the following part of an E-R diagram, what does the hash mark across the relationship line near the entity in the figure below indicate?

a) A minimum cardinality of zero

b) A minimum cardinality of one

c) A maximum cardinality of one

d) Both b & c

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

For the relationship represented in the figure below, which of the following is true?

a) Each instructor teaches one or more courses

b) Each instructor has one and only one course

c) Each course is taught by zero and one instructor

d) Each course is taught by many instructors

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

173 questions

Đề Trọng Điểm APTIS Listening

Quiz

•

University

169 questions

OTE(Vocabulary)9

Quiz

•

9th Grade - University

176 questions

Vocabulary Quiz 9/23

Quiz

•

7th Grade - University

171 questions

writting B1 6-10

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for English

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

10 questions

Charlie and Chocolate Factory Chapters 1-10

Quiz

•

2nd Grade - University

Exam Practice CS2203 - Databases 1

The address of a student can be defined using street, city, state, and zip code. What type of attribute should be used to represent the address of a student?

For the relationship represented in the figure below, which of the following is true

In an Entity-Relationship model, which concept is generally used to represent a student?

For the relationship represented in the figure below, which of the following is true?

The E-R model is used to build a conceptual model.

Given only the following part of an E-R diagram, what does the hash mark across the relationship line near the entity in the figure below indicate?

For the relationship represented in the figure below, which of the following is true?

“A student can attend six courses, each with a different instructor. Each instructor has 30 students.”
What is the type of relationship between students and instructors?

All instances of a given entity set have the same attributes in the E-R Model.

Given only the following part of an E-R diagram, what does the circle across the relationship line near the entity in the figure below indicate?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for English

Exam Practice CS2203 - Databases 1

The address of a student can be defined using street, city, state, and zip code. What type of attribute should be used to represent the address of a student?

For the relationship represented in the figure below, which of the following is true

In an Entity-Relationship model, which concept is generally used to represent a student?

For the relationship represented in the figure below, which of the following is true?

The E-R model is used to build a conceptual model.

Given only the following part of an E-R diagram, what does the hash mark across the relationship line near the entity in the figure below indicate?

For the relationship represented in the figure below, which of the following is true?

“A student can attend six courses, each with a different instructor. Each instructor has 30 students.” What is the type of relationship between students and instructors?

All instances of a given entity set have the same attributes in the E-R Model.

Given only the following part of an E-R diagram, what does the circle across the relationship line near the entity in the figure below indicate?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for English

“A student can attend six courses, each with a different instructor. Each instructor has 30 students.”
What is the type of relationship between students and instructors?