XYZ Company sells their products on the internet. The company is implementing an
ID: 3797606 • Letter: X
Question
XYZ Company sells their products on the internet. The company is implementing an Order Management System for this purpose. The table CUSTOMER maintains the information related to each customer. The table ORDER maintains the orders for each customer. The primary key for CUSTOMER is CUSTOMER_NUMBER. The primary key for ORDER is ORDER_NUMBER. A customer can have zero, one or more than one orders. The database designer of the project wants to maintain referential integrity between these two tables. What should she do in her design? None of the choices Define CUSTOMER_NUMBER from CUSTOMER table as a foreign key in ORDER table Define CUSTOMER_NUMBER as not null in ORDER table Define ORDER_NUMBER from ORDER as a foreign key in CUSTOMER table In a weather forecasting system PROBABILITY_OF_ RAIN field could take any value from 0 to 1. The set containing all the values between 0 and 1 (including 0 and 1) is known as Candidate set for the field PROBABILITY_OF_RAIN Subset for the field PROBABIUTY_OF_RAIN Full set for the field PROBABILITY_Of_RAIN Domain for the field PROBABILITY_OF_RAIN Study the data n the table below. Table Name: COMPLAINT NOTES For the above table, the column COMPLAINT_ID can be the Primary Key (TRUE or FALSE)Explanation / Answer
Q4) D(Defining OderNumber as foreign key in Customer table)
This is because an order must be of some customer,so linking this order number with a customer in the customer table.
Q5) D(Domain for the field PROBABILITY_OF_RAIN)
The domain of a function is the set of "input" or argument values for which the function is defined. That is, the function provides an "output" or value for each member of the domain.So the values between 0 to 1 (including 0 and zero) is the domain set
Q6) False.
Complaint Id cannot be the primary key.This is because primary key must be unique for the records.But NOTE_ID 1 and 3 are having the same COMPPLAINT_ID (i.e. 100)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.