User Account

All Pages

Write the t-sql statement that would create a table

Assignment Help PL-SQL Programming
Reference no: EM131670366

Question 1: Write single, syntactically correct, T-SQL statements for each of the following:

a. Delete a database named "SportingFC"
b. Create a database named "SportingFC"
c. Make a database named "SportingFC" the currently active database

Question 2: Write the T-SQL statement that would create a table named "Team". The table should contain 3 attributes -TeamID, TeamName and Established. Give these attributes appropriate data types and assign a Primary Key.

Established refers to the date that the team was established.

Question 3: Write the T-SQL statement that would display all records and all fields from a table named "Team". The data should be presented such that teams are grouped based on the Established year and within each group, the data should be presented in ascending order of the Team Name.

Questions 4 to 6 are based on the following table:

A table named "Player" contains details about every player belonging to a sporting club. It contains 4 fields - PlayerID, GivenName, FamilyName and Phone. PlayerID is a number that is auto-generated by the DBMS.

Question 4: Write the T-SQL statement that would insert 2 records into the table Player,assuming that none of the fields can be left "NULL".

Question 5: Write the T-SQL statement that would display all players that have a PlayerID greater than or equal to 1000

Question 6: Write the T-SQL statement that would delete all players named "Smith" from the Player table.

Verified Expert

The assignment is to test the basics of T-SQL command of SQL SERVER (SQL commands). The assignments covers the basics of creating, deleting and using databases. It also covers the fundamental commands of creating tables with the given attributes and applying various constraints like PRIMARY KEY to the required fields in the table.It also covers the Select queries on the given tables and retrieving the records from the table. The records are inserted into tables using the INSERT command and DELETE command to delete records from the table.

Reference no: EM131670366

Questions Cloud

Looking forward to the elementary science : Xia has been looking forward to the Elementary Science Fair for weeks. Her fourth-grade class had just finished learning about the biological cell
Species and scientific correction : Imagine you are explaining to a friend what the term species means. In your own words define the term species then provide three (3) examples.
Discuss about the various specialties : Shown here is an Excel-produced pie chart representing physician specialties. What does the chart tell you about the various specialties?
The science-what is the human microbiome : After reading and exploring resources here in this forum, find a news (NY Times, Chicago Tribune, Huffington Post, local digital newspapers, etc.)
Write the t-sql statement that would create a table : Write the T-SQL statement that would create a table named "Team". The table should contain 3 attributes -TeamID, TeamName and Established
What duties medical care describes the role of a pa : What is a physician assistant? What duties (medical care) describes the role of a PA? What duties (medical care) can a APRN (Advanced Practice Nurse) conduct?
Difference between quality control : What is the difference between quality control, quality assurance and total quality management? How has the business view of quality been shaped over time?
Compute the number of audits being performed by the firms : Suppose 100 CPA firms are surveyed to determine how many audits they perform over a certain time. The data are summarized using the Minitab stem-and-leaf plot.
Think of hypothetical screening programs : Think of hypothetical screening programs for diseases of interest to you; find one example of a disease where high sensitivity would be more important

Reviews

inf1670366

1/6/2018 5:28:29 AM

Exceptionally proficient, made a stunning solution with regards to on the paper. He comprehended the task and completed paper before due date allocated. I will utilize his administrations once more. Best administration yet!

inf1670366

11/30/2017 5:30:52 AM

Actually, I need screenshot in which software they work because it's also attached to my task thanks Can you please explain me in class2, what they have asked n question 4 to 6 because you didn't provide the answer of 4 to 6

Write a Review

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd