Reference no: EM131395827
Lab: Structured Query Language (SQL)
Refer to the database design crested in Lab 2: Modifying a Database Design to complete this Lab.
This is the database design from Lab 2
Perform the following steps in MySQL:
1. Create the tables and relationships from the database design discussed in Lab 2.
2. Add at least five records into each table (Note: You must determine the field values).
3. Create a query with all fields from the student table, where the student's last name is "Smith".
4. Create a query that includes students' first names, last names, and phone numbers.
5. 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.
|
Examine the benefits and drawbacks of each format for users
: Examine the benefits and drawbacks of each format for users. Determine whether you agree or disagree that Blu-ray was the superior choice technologically over HD-DVD. Provide a rationale for your response.
|
|
Definitions by genus or enumerative definition
: Determine whether the following are demonstrative definitions, enumerative definitions, definitions by subclass, synonymous definitions or definitions by genus and difference.- "Poignant" is a word derived from the Latin word pungere, which means p..
|
|
Solve the problem using excel present value
: Show all steps to solve the problem, then solve the problem using excel present value (PV) calculations showing the changes over all 8 years
|
|
Enumerative definitions or definitions by genus
: Determine whether the following are demonstrative definitions, enumerative definitions, or definitions by subclass.- "Insect" means something such as a fly, an ant, a wasp, or a caterpillar.
|
|
Create the tables and relationships from the database design
: Create the tables and relationships from the database design discussed in Lab 2. Add at least five records into each table (Note: You must determine the field values).
|
|
Determine if integer is odd or even
: Your output should stand alone, like The value 4 is an even number. Hint: See the remainder (modulo) operator in §3.4.
|
|
Adjustment of the economy back to potential gdp
: Explain why an increase in export expenditure might temporarily result in the economy operating above potential GDP. Explain why this is temporary. If the government considers that the level of inflation associated with the adjustment of the econo..
|
|
Enumerative definitions or synonymous definitions
: Determine whether the following are demonstrative definitions, enumerative definitions, definitions by subclass or synonymous definitions.- A substance is "translucent" if and only if when held up to a strong light some of the light comes through.
|
|
What do you believe about your own health
: you will draft a formal paper expressing your personal philosophy of nursing paper. In this paper, you will provide a framework for your personal practice of nursing and reflect on why you chose nursing as a profession. Your paper will define how ..
|