Create a query with all fields from the student table

Assignment Help Database Management System
Reference no: EM131396230

Lab : Structured Query Language (SQL)

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

Perform the following steps in MySQL:

Create the tables and relationships from the database design discussed in Lab 2.

Add at least five (5) records into each table (Note: You must determine the field values).

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.

Verified Expert

In this assignment we have created a report for the given database case study.So we have design a database in MYSQL in which we have normalized all the table in the database for the further use..And we have written all the given queries as per the requirement and attached all the screenshot of the database.

Reference no: EM131396230

Questions Cloud

Criticize given definitions - feminism is militant movement : Criticize the following definitions in light of the eight rules for lexical definitions:- Feminism is a militant movement originated by a group of deviant women for the purpose of undermining the natural distinction between the sexes.
What is the image of computer programmer in popular culture : What is the image of the computer programmer in popular culture? Is the image different in books than in TV shows and movies? Would you like a programmer image for yourself, and if so, which one?
Important variable in macro-economics : Explain why "supply of labor" is a critically important variable in macro-economics.
Concepts that help us distinguish social media : Explain the seven concepts that help us distinguish social media from face-to-face communication. Provide an example of how the social media you use reflects these seven concepts.
Create a query with all fields from the student table : Create the tables and relationships from the database design discussed in Lab 2. Add at least five (5) records into each table (Note: You must determine the field values). Create a query with all fields from the student table, where the student's las..
Criticize the given definitions - wood means fibrous : Criticize the following definitions in light of the eight rules for lexical definitions:- "Wood" means fibrous, lignified cellulose.
Criticize the given definition - logic is study of arguments : Criticize the following definitions in light of the eight rules for lexical definitions:- Logic is the study of arguments including definitions.
Evaluate the five essential control components for managers : Evaluate the five essential control components for managers and auditors established by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).
Minimum wage good for the us macro-economy : Is a $15 an hour minimum wage good for the U.S. macro-economy? Explain why. Is it bad for the U.S. economy? Explain why.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Normalize the following table

Normalize the following table upto and including the 3NF. Submit a 1 page printout of only the final set of normalized tables in Data Architect. Just use Data Architect to do the tables. No need for E-R, mapping, relationships etc. Just tables. State..

  Define what is meant by a process in a process model

Define what is meant by a process in a process model. How should a process be named? What information about a process should be stored in the CASE repository?

  Why network is the key to data needs throughout organization

Ascertain the need for a robust network infrastructure to support strategic initiatives related to BI within an organization of your choice. Moreover, analyze the main reasons why the network is the key to data needs throughout the organization.

  Who were barons at the time of their appointment

Find all Governors General of Australia who were Barons at the time of their appointment. List them by Title and name and date that they were appointed to the position. Order the list by ascending date of appointment

  Create the physical data model

Using anyRDBMS preferably (MySQL), create the physical data model for the logical data model provided in the attachment. This should include all of the data definition language SQL.This should be based upon the previous ERD created (see figure bel..

  Build entity relationship model military information system

Build an entity relationship model for the above scenario. Show all attributes and indicate all of your key attributes in red.

  Determine probability that the patient has metastatic cancer

Given that a patient has severe headache, has a brain tumor, not in coma and does not have symptoms of increased serum calcium, determine the probability that the patient has metastatic cancer.

  Write long term problems when constraints are implemented

Why are these so significant yet so frequently ignored by developers? Write the long term problems when these constraints are not implemented? "

  What is normalization and explain why it is important

Write the SQL SELECT statement to display the average rent of the properties. What is normalization? Explain why it is important. List and describe the 4 components of a database system.

  Find the entities from the functional requirements

Find the entities from the functional requirements. Entities can come from Nouns in the text, they may also come from forms, reports and legacy code.

  How many cylinders does the disk have

Consider a disk with a sector size of 512 bytes, 2000 tracks per surface, 50 sectors per track, ?ve double-sided platters, and average seek time of 10 msec.

  Design and create a database for an airline

CSG1207/CSI5135 Systems and Database Design. You are required to design and create a database for an airline. The database must contain details of the airline's planes, flights, flight instances and staff, as well as supporting data as detailed bel..

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!

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