Structured query language

Assignment Help Basic Computer Science

Reference no: EM13762905

Structured Query Language

Refer to the database design crested in Lab Modifying a Database Design in Visio to complete.

Perform the following steps in MySQL:

Create the tables and relationships from the database design
Create a query with all fields from the student table, where the student's last name is "Smith".
Create a query that includes students' first names, last names, and phone numbers.
Create a query that includes instructors' first names, last names, and courses they teach.

Include the following screen shots in a Microsoft Word document to show the completion of the steps above:

Screen shot depicting the tables created within MySQL.
Screen shots depicting the records added into each table.
Screen shots depicting the SQL code and the query results from each of the queries created.

Your assignment must follow these formatting requirements:

Submit the lab as a Microsoft Word document.
Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page is not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.

Reference no: EM13762905

Questions Cloud

Determine whether a packet should get destroyed : Packets are destroyed if they get "lost" and keep traveling the internet without arriving at a destination. What is parameter is evaluated to determine whether a packet should get destroyed?

Write the content review of the given contents : Write the Content Review of the following contents and Explain Lev Vygotsky's theory of the Zone of Proximal Development and how knowledge of this theory might inform your future work with children.

What is difference between beta required rates of return : Company A has a beta of 0.70, while Company B's beta is 0.85. The required return on the stock market is 11.00%, and the risk-free rate is 2.25%. What is the difference between A's and B's required rates of return?

Write easy commentary about course perspectives : It is also helpful in considering the behavior or functioning of any organism or entity in the environment - Transactions between entities are the primary focus in improving the quality of life, social functioning, etc., for all who live with the ..

Structured query language : Create the tables and relationships from the database design

The role of community and public health nurse : How do these skills differ from those required in the institutional setting?

True sampling error : The true sampling error is usually not known because

Create a c++ project using appropriate data types : Create a C++ project. Declare the following identifiers using appropriate data types.

Study of the human muscles : 1. The study of the human muscles.

User Account

All Pages