Information Technology (802)

Which payment method is NOT mentioned as an option in the XYZ Shopping Website case study?

Which command lists all the tables created in the currently selected database?

A shopping website's database design typically requires separate tables for entities like Category, Product, Customer, and Orders.

Which constraint ensures that a user-specified value (e.g., 40000) is stored when no value is provided for an attribute?

List any four domains/sectors where database management applications are commonly used, as mentioned in the textbook.

Which constraint is used to restrict the values of an attribute to a specific range (e.g., Dept_No <= 110)?

Write the CREATE TABLE command for the CATEGORY table with schema CATEGORY(Category_id INT(10) Primary Key, Name VARCHAR(20), Description VARCHAR(40)).

By default, primary key columns are:

Explain the four phases of database application development as applied to designing a shopping website, referencing entity identification and table design.

If a table's primary key comprises MORE than one attribute, how must it be specified in the CREATE TABLE command?

Given int a=15, b=4; what is the value of a%b?

Which clause is used to specify a foreign key and the table/column it references?

Given int a=22, b=7; what is the value of a%b?

In the Key column of a DESC output, what does 'MUL' next to a foreign key column indicate?

Given int a=9, b=5; what is the value of a%b?

Which referential action automatically sets the foreign key value to NULL when the referenced primary key row is deleted?

Given int a=31, b=6; what is the value of a%b?

Which referential action automatically deletes the corresponding rows in the referencing table when the referenced row is deleted?

Given int a=18, b=4; what is the value of a%b?

Which referential action rejects the delete/update operation on the referenced table if there are related rows in the referencing table?