Question: Create the Registration table with appropriate data types and make sure that it does not violate any entity and referential integrity rules. Create constraints

Create the Registration table with appropriate data types and make sure that it does not violate any entity

Create the Registration table with appropriate data types and make sure that it does not violate any entity and referential integrity rules. Create constraints to ensure that the register date is greater or equal to company operation start date and all the attributes cannot be null. Sample records of the table are shown below: Customer No 1000000018 1000000019 1000000018 PackageID P0000001 P0000002 P0000002 Register Date 02-02-2021 02-02-2021 01-03-2021 Increase 5% of Phoenix Package's price with 3 additional channels. Remove all the package registrations made by a male customer named 'Lim Tai Ko'. Display all the details of female customers who stay in Damansara. Display all the details of registrations (which include the customer name and package name) made during March 2021. List the customer number, customer name and number of packages for those customers who have subscribed more than 2 packages with each package costs more than RM100.

Step by Step Solution

3.45 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To create the registration table with appropriate data types and make sure that it does not violate any entity and referential integrity rules we can use the following SQL statement sql CREATE TABLE R... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!