Question 1.)

SELECT COUNT(*) FROM product;

The following SQL query:

returns the _________ of table product.

a.) Degree

b.) Number of columns

c.) Arity

d.) Cardinality

Question 2.)

If we want to record names in a student table, which of the following SQL code is invalid?

a.) create table student (fullname (firstname varchar(30), lastname varchar(30)));

b.) create table student (fullname varchar(60), firstname varchar(30), lastname varchar(30));

c.) create table student (firstname varchar(30), lastname varchar(30));

d.) create table student (fullname varchar(60));

question 3)

What's the foreign key in the following table declaration?

create table Product (

pname varchar(20) primary key,

price float,

manufacturer varchar(20) references Company.cid

);

a.) pname

b.) manufacturer

c.) cid

d.) price