Using any DBMS to do the following Part One: Data Definition Language (DDL) 1. Create table...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using any DBMS to do the following Part One: Data Definition Language (DDL) 1. Create table named Student, with the following rules and constraints (2 marks) 66 Column Name SID Sname DoB 1 Answer: Data Type Length Number 8 Varchar2 30 Date Constraints Primary Key Unique 2. Create table named Course, with the following rules and constraints (1.5 marks) Column Name Data Type Length Constraints CID Number Primary Key I Cname Varchar2 Unique Crd Number Crd >= 1 and Crd<=3 Answer: 5 60 1 Using any DBMS to do the following Part One: Data Definition Language (DDL) 1. Create table named Student, with the following rules and constraints (2 marks) 66 Column Name SID Sname DoB 1 Answer: Data Type Length Number 8 Varchar2 30 Date Constraints Primary Key Unique 2. Create table named Course, with the following rules and constraints (1.5 marks) Column Name Data Type Length Constraints CID Number Primary Key I Cname Varchar2 Unique Crd Number Crd >= 1 and Crd<=3 Answer: 5 60 1
Expert Answer:
Answer rating: 100% (QA)
The following SQL statements can be used to create the Student and Course tables in a relational dat... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
A 22-year-old college football player sustains a rough hit on the field during a practice for their biggest game of the season in 2 days. The player was knocked to the ground after a collision with...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Do some amendment and enhance the given research paper: Table of Content Abstract..3 Action Research.4 Research Methodology and Design...5 Literature Review: NoSQL Database7 Proposal.7 Iteration 1..8...
-
Describe the research question, research method and data sources of a research paper which has used these accounting values and cultural dimensions, and assess the significance of such research.
-
A transmission tower is held by three guy wires attached to a pin at A and anchored by bolts at B, C, and D. Knowing that the tower exerts on the pin at A an upward vertical force of 8 kN, determine...
-
Account Title Debits Credits Sales revenue $ 3 3 0 , 0 0 0 Loss on sale of investments $ 2 8 , 0 0 0 Interest revenue 5 , 5 0 0 Cost of goods sold 1 7 5 , 0 0 0 General and administrative expense 4 3...
-
The probability that the first stage of a numerically controlled machining operation for high-rpm pistons meets specifications is 0.90 . Failures are due to metal variations, fixture alignment,...
-
Vail Resorts, Inc., owns and operates five premier year-round ski resort properties (Vail Mountain, Beaver Creek Resort, Breckenridge Mountain, and Keystone Resort, all located in the Colorado Rocky...
-
Capstone Exercise One of the best ways to illustrate the value of good market research and the importance of applying the results of market research to your marketing strategy is to look at a...
-
Tuckered Outfitters plans to market a custom brand of packaged trail mix. The ingredients for the trail mix will include Raisins, Grain, Chocolate Chips, Peanuts, and Almonds costing, respectively,...
-
The probability of taking a step forward by a man is 1/2. Calculate the probability that he has moved 4 steps forward in 10 steps. 1 (a) 1024 15 (b) 128 1 (c) 3 (d) 4
-
In 1985 Josef Kleinfeld purchased a building in the East Village and opened a video rental store on the ground floor. Unfortunately, Kleinfeld lost a great deal of money during his first year. Things...
-
What are the two model acts that govern partnership law?
-
Which of the following items are sold by firms in monopolistic competition? Explain your selections. Corn Toothpastes Structural steel Chocolate Computer operating systems Services at...
-
What are the functions of directors, officers, and shareholders?
-
Review the pros and cons of managing marketing communications in-house rather than using the services of external agencies.
-
Activity 6 - More Motivating Questions: In this problem, we willbe exploring the distribution of sample means, x-bar when samplesof various sizes are taken from another population. For this, youwill...
-
DEPARTMENT DATA EMPLOYEE DATA EmployeeNumber FirstName Mary Rosalie Richard George Alan 3 4 5 7 8 9 855555ES 12 13 14 15 16 17 Create the database tables in SQL or ACCESS: 18 19 20 PROJECT DATA Ken...
-
Ann hires a nanny to watch her two children while she works at a local hospital. She pays the 19-year-old nanny $125 per week for 48 weeks during the current year. a. What is the employer's portion...
-
Calculate the amount of the child and dependent care credit allowed for 2012 in each of the following cases, assuming the taxpayers had no income other than the stated amounts. a. William and Carla...
-
Dr. Ivan I. Incisor and his wife Irene are married and file a joint return for 2012. Ivan's Social Security number is 477-34-4321 and he is 48 years old. Irene I. Incisor's Social Security number is...
-
When nitrogen and fluorine combine to form a molecule, the most likely chemical formula is: (a) N 3 F. (b)N 2 F. (c) NF 4 . (d) NF. (e) NF 3 .
-
A substance consisting of which of the two molecules shown below should have a higher boiling point? Why? (a) the molecule on the left, SCO, because it comes later in the periodic table (b) the...
-
In terms of the periodic table, is there an abrupt or gradual change between ionic and covalent bonds? (a) An abrupt change occurs across the metalloids. (b) Actually, any element of the periodic...
Study smarter with the SolutionInn App