Create the Registration table with appropriate data types and make sure that it does not violate...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
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 the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
The provided text describes the positive outcomes of Atom Bank, a UK - based bank, after it shifted to a four - day workweek. The decision was driven by the need for revitalization after COVID - 1 9...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
When sound propagates through a one-dimensional duct and causes all air particles to oscillate around their own equilibrium positions. If we put a plate in one cross-section of the duct and drive the...
-
The following information has been extracted from the financial statements of XYZ Ltd for the year ended 31 December 2022: Income Statement Sales revenue: $3,000,000 Cost of goods sold: $1,200,000...
-
Thousands of years of organized religion have done nothing to solve any problems and have almost always exacerbated them by promoting fear, superstition, and irrational mythologies. Kneeling in...
-
An incomplete subsidiary ledger of wire cable for May is as follows: a. Complete the materials issuances and balances for the wire cable subsidiary ledger under FIFO. b. Determine the balance of wire...
-
Fill in the Blanks. \(\mathrm{A}(\mathrm{n})\) ________________ formula permits the computation of \(x_{i}\) from known values of \(x_{i-1}\).
-
Various Unrelated Transactions. Following are several unrelated transactions involving a university. 1. In fiscal year 2011, the university was notified by the federal government that in 2012 it...
-
Can you please provide a feedback to this post? 1. What is the managerial view on business? What are the stakeholders view on business? How do they differ? The management viewpoint on business...
-
Refer to the Bulletin of Marine Science (Apr. 2010) study of teams of fishermen fishing for the red spiny lobster in Baja California Sur, Mexico, Exercise 11.63 (p. 614). Recall that simple linear...
-
Briefly, describe what is meant by confirmation bias and framing effect and suggest two specific actions managers could take to guard against the influence of these biases.
-
Why is economics central to an understanding of the problems of development?
-
Regardless of your specific views about the SDGs, do you think it is better to have these goals (or perhaps even any goals) than not to specify international development goals? How, or why not?
-
How does the concept of capabilities to function help us gain insight into development goals and achievements? Is money enough? Why or why not?
-
It has been said that ending extreme poverty and achieving genuine development are possible but not inevitable and that this gives the study of economic development its moral and intellectual...
-
What would achieving the vision of ending extreme income and multidimensional poverty look like, beyond raising minimum family income to above the poverty line to be able to buy basics? (To...
-
The Mohr circle for certain stress system is shown in figure. The Principal stresses (major and minor) in MPa respectively are 700 wor (Note: tension and '-' compression) OL 250MPa (a) 320.26, 70.26...
-
Accounting policies and practices that are most important to the portrayal of the companys financial condition and results, and require managements most difficult, subjective, or complex judgments...
-
Design a survey form of your own. Fill it out as it might have been completed during the database design forHenry Books. For any questions you have too little information to answer, make a reasonable...
-
When do you use OLAP?
-
Describe the purpose of the JOIN command in relational algebra.
-
What would the QA/QC planning grid (see Figure 12. 6) look like for a project you have been involved in? Data from Figure 12. 6 Table 12.6 QA/QC planning grid, with examples Quality assurance...
-
Why is the definition of quality critical to the success and acceptance of a project?
-
What is the purpose of the Quality Management Plan?
Study smarter with the SolutionInn App