Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fon trap occurs when there cre one or more relationships with a minimum multiplicity of zero forming part of the pathway between related entities. Select
Fon trap occurs when there cre one or more relationships with a minimum multiplicity of zero forming part of the pathway between related entities. Select one True O False SOL provides a SELECT command to select specific records from a toble based on specific criteria. Select one O True False For a table to be in 2NF, it is based on the concept of partial dependencies, Select one: True h O False SQL syntax stated below is an SQL statement that will change a column name to staffName from Payment relation. ALTER TABLE Payment DROP COLUMN staffName; Select one: True O False If B is functional dependency to A, represented by AB, SD, A is a determinant Select one: True O False Given below are samples of data stored in PRODUCT and SUPPLIER relations. (Figure 1) PRODUCT productNo productName pricePerUnit productOnHand expiry Date supplier No (RM) PO1 Yogurt 4.50 1100 12/03/22 PO2 S002 Ideal Milk 5.30 200 23/08 22 PO3 S002 Cookies 8.90 2000 30/09/22 S003 SUPPLIER supplier No address tel No S002 Kajang Hill 03-89765421 S003 Putrajaya 03-89997733 Figure 1 Write the SQL statements to: a) List full details of products that will expire on 30/09/22 (3 marks) (CLO2:PLO2C3) b) list all details of supplier in descending order of supplier number (3 marks) (CLO2.PLO2C3) c) List all the products with the price between RM5.00 and EM9.00. (4 marks) MCLO2.PLO2:03) c) List product number, name and supplier address for product supplied by supplier from Putrajaya, (5 marks) (CLO2.PLO2C3) e) Find the total number of product from supplier S003. (4 marks) (CLO2:PLO2:03) f) Add on attribute named contactperson to Supplier relation (2 marks) (CLO2.PLO2C3)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started