Using SQL, write Data Definition Language commands to set up the database schema for an Admission...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using SQL, write Data Definition Language commands to set up the database schema for an Admission Database System for a University with the tables below: a. STUDENT(SD, sName, GPA, sizeHS) b. COLLEGE(CName, state, enrollment) c. Apply(sID Name, major, decision) Hint: i. slis unique and not null for each Student Meme is unique and not null for each College ii. iii. slp. SName and major are unique for each record in the Apply table iv. GPA is a decimal value with at least 2 decimal points Research (over google) the SQL syntax of the SQL "INSERT INTO" statement and determine the commands to populate the tables with data below. COLLEGE cName Stanford Berkeley MIT Cornell STUDENT SID 123 234 345 456 567 678 789 987 876 765 654 543 sName Amy Bob Craig Doris Edward Fay Gary Helen Irene Jay Amy Craig state CA CA MA NY 3.9 3.6 GPA sizeHs 1000 1500 500 1000 3.5 3.9 enrollment 15000 36000 2.9 3.8 3.4 3.7 3.9 2.9 3.9 3.4 10000 21000 2000 200 800 800 400 1500 1000 2000 Apply SID 123 123 123 123 234 345 345 345 345 678 987 987 876 876 876 765 765 765 543 cName Stanford Stanford Berkeley Cornell Berkeley MIT Cornell Cornell Cornell Stanford Stanford Berkeley Stanford MIT MIT Stanford Cornell Cornell MIT major CS EE CS EE Biology Bioengineering Bioengineering CS EE History CS CS CS Biology marine biology History History Psychology CS decision Y N Y Y N Y N Y N Y Y Y N Y N Y N Y N Case Study 2: You are provided with the specification requirements below to implement a database management system (DBMS) for "Bank X" to store details about their Branches, Accounts, and Customers. SR-1: A BRANCH has a Branch that is numeric, a Branch Name, and Branch Address. The BranchJP.is unique for each branch while Branch Name and Branch Address may not be unique. SR-2: SR-3: CUSTOMER has an SSN field that is of numeric characters, along with Name, Phone, Address. SR-4: A Branch has multiple accounts linked to it, while an account can be linked to just one branch. A customer can possess no more than 4 accounts in the same branch but of different account types. While accounts are not shared between customers. SR-5: An ACCOUNT has an Account No field in numeric characters, Account Type, and Balance. The ACCOUNT_TYPE is either Savings, Checking, Credit Card, or Mortgage. The Account No is unique for each account. SR-6: A customer can have multiple accounts in different branches. SR-7: Only the customer's phone number may be empty (NULL), all fields in the database are mandatory. 3. Using SQL, write Data Definition Language (DDL) commands to set up the database schema with the below tables. Note: Include a primary key for each table: a. BRANCH (Branship. BranchNe BrensbAddress) b. ACCOUNT (ACcNo, AccTypeID, Branch, SSN, Balance) C. ACCOUNT_TYPE (ASGTvesIP. AccountType) d. CUSTOMER (SSN, Name, Phone, Address) 4. Using SQL, write Data Manipulation Language (DML) commands to populate the tables with data to illustrate SR4 to SR7. Using SQL, write Data Definition Language commands to set up the database schema for an Admission Database System for a University with the tables below: a. STUDENT(SD, sName, GPA, sizeHS) b. COLLEGE(CName, state, enrollment) c. Apply(sID Name, major, decision) Hint: i. slis unique and not null for each Student Meme is unique and not null for each College ii. iii. slp. SName and major are unique for each record in the Apply table iv. GPA is a decimal value with at least 2 decimal points Research (over google) the SQL syntax of the SQL "INSERT INTO" statement and determine the commands to populate the tables with data below. COLLEGE cName Stanford Berkeley MIT Cornell STUDENT SID 123 234 345 456 567 678 789 987 876 765 654 543 sName Amy Bob Craig Doris Edward Fay Gary Helen Irene Jay Amy Craig state CA CA MA NY 3.9 3.6 GPA sizeHs 1000 1500 500 1000 3.5 3.9 enrollment 15000 36000 2.9 3.8 3.4 3.7 3.9 2.9 3.9 3.4 10000 21000 2000 200 800 800 400 1500 1000 2000 Apply SID 123 123 123 123 234 345 345 345 345 678 987 987 876 876 876 765 765 765 543 cName Stanford Stanford Berkeley Cornell Berkeley MIT Cornell Cornell Cornell Stanford Stanford Berkeley Stanford MIT MIT Stanford Cornell Cornell MIT major CS EE CS EE Biology Bioengineering Bioengineering CS EE History CS CS CS Biology marine biology History History Psychology CS decision Y N Y Y N Y N Y N Y Y Y N Y N Y N Y N Case Study 2: You are provided with the specification requirements below to implement a database management system (DBMS) for "Bank X" to store details about their Branches, Accounts, and Customers. SR-1: A BRANCH has a Branch that is numeric, a Branch Name, and Branch Address. The BranchJP.is unique for each branch while Branch Name and Branch Address may not be unique. SR-2: SR-3: CUSTOMER has an SSN field that is of numeric characters, along with Name, Phone, Address. SR-4: A Branch has multiple accounts linked to it, while an account can be linked to just one branch. A customer can possess no more than 4 accounts in the same branch but of different account types. While accounts are not shared between customers. SR-5: An ACCOUNT has an Account No field in numeric characters, Account Type, and Balance. The ACCOUNT_TYPE is either Savings, Checking, Credit Card, or Mortgage. The Account No is unique for each account. SR-6: A customer can have multiple accounts in different branches. SR-7: Only the customer's phone number may be empty (NULL), all fields in the database are mandatory. 3. Using SQL, write Data Definition Language (DDL) commands to set up the database schema with the below tables. Note: Include a primary key for each table: a. BRANCH (Branship. BranchNe BrensbAddress) b. ACCOUNT (ACcNo, AccTypeID, Branch, SSN, Balance) C. ACCOUNT_TYPE (ASGTvesIP. AccountType) d. CUSTOMER (SSN, Name, Phone, Address) 4. Using SQL, write Data Manipulation Language (DML) commands to populate the tables with data to illustrate SR4 to SR7.
Expert Answer:
Answer rating: 100% (QA)
Answer Insert data into COLLEGE table INSERT INTO COLLEGE CName state enrollment VALUES ... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
5) Global Tech Corp has the following capital structure: a. Debt = 35% b. Preferred Stock = 15% c. Common Stock = 50% d. After tax cost of debt = 6.5% e. Cost of preferred stock = 10% f. Cost of...
-
Consider the following information for two companies, A and B: In U.S $ Market Value of Equity (E) Market Value of Debt (D) Cost of Equity (Re) Cost of Debt (Rd) Tax Rate (Tax) Company B 500,000...
-
A small consulting company wants to make the switch to QuickBooks Online. All of their expenses are paid at the time they are incurred, so there is no need to track bills in the system. There is only...
-
Solve: y(4) +18y"+81y = 0 y(0) = -4, y'(0) = 8, y'(0) = 42, y"(0) = -108 - Submit Question X
-
Another Wall Street analyst predicted in 2010 that, after the considerable deleveraging during the financial crisis, firms would begin once again to lever up with more borrowing. "They must defend...
-
Find the \(P \%=(1-\alpha) 100 \%\) interval estimates \(\widehat{I_{\alpha}^{\mu}}, \widehat{I_{\alpha}^{\sigma}}\) (use that \(\sigma=1 / \sqrt{\tau}\) ) and \(\widehat{I_{\alpha}^{+}} ; \sigma\)...
-
Correctly apply the rules for the order of operations to accurately compute \(\left(\frac{3}{16}+\frac{7}{16} ight)^{2}+\frac{1}{5} \div \frac{3}{10}\).
-
Lita Lopez started Biz Consulting, a new business, and completed the following transactions during its first year of operations. a. Lita Lopez invests $70,000 cash and office equipment valued at...
-
Question 15 (Mandatory) (2.86 points) Consider the following forward contract scenario: . Initiation = October 23, 2014 . Expiration = March 21, 2015 Asset = one share of Actions Semiconductor Co.,...
-
Assume that you are using attribute sampling to test the controls over revenue recognition of the Packet Corporation, a public company, and will use the results as part of the evidence on which to...
-
Which form of asset financing involves the public offering of debt collateralized by a firms accounts receivables? a. Trust receipts. b. Warehousing. c. Blanket inventory liens. d. Securitization of...
-
1. Romina Corporation utilizes normal costing. During the year ended December 31, 2019, the following information were made available: - Total manufacturing costs incurred during the year -...
-
Have you ever wondered why Lady Justice is blind? Perhaps it is because to promote and preserve justice, we must be blind to other things. For this final discussion, you will consider what justice is...
-
Just need good feedback and ask me one question about my research paper? When researching the question at hand I thought of looking it from the perspective of working in the US Navy, calling Texas...
-
es Prepare journal entries for the following credit card sales transactions (the company uses the perpetual inventory system). 1. Sold $33,000 of merchandise, which cost $25,400, on Mastercard credit...
-
Your attorney, Barry Smart, comes to you looking a bit exasperated and confirms with you that client, Larry Last, is coming in tomorrow with his witnesses to sign his Last Will and Testament. You...
-
As a freshly minted MBA, the executive team of your company has invited you to help them better understand the concept of managerial/real options. Which one of the following statements made by...
-
Pearl Medavoy will invest $10,240 a year for 20 years in a fund that will earn 10% annual interest. . If the first payment into the fund occurs today, what amount will be in the fund in 20 years? If...
-
Determine the reactions at the pin at A and the rollers at B and C. EI is constant. Mo A L B Prob. F9-4 L C
-
Draw the shear and moment diagrams for the beam. Indicate values at the supports and at the points where a change in load occurs. 6 kN/m A -2 m- -2 m- Prob. F4-19 6 kN/m B -2 m-
-
Determine the force in member BD. AE is constant. 12 kN D -1.5 m Probs. 9-30/31 C 9 kN 2m B
-
A sequence is known to be arithmetic. Two of the terms are \(a_{14}=41\) and \(a_{38}=161\). Use that information to find the constant difference and the first term. Then determine the 151 st term of...
-
Christina decides to save money for after graduation. Christina starts by setting aside \(\$ 10\). Each week, Christina increases the amount she saves by \(\$ 5\). How much money will Christina save...
-
For each sequence, determine if the sequence is a geometric sequence. If so, identify the common ratio. 1. \(\{-1,-5,-25,-125,-625,-3125, \ldots\}\) 2. \(\{-3,6,-12,24,11,33\}\) 3....
Study smarter with the SolutionInn App