Examine the Metadata/Data Dictionary in the attached PDF file. We will review in class what the...

 

Transcribed Image Text:

Examine the Metadata/Data Dictionary in the attached PDF file. We will review in class what the term metadata means. If you want to get ahead, read the documents named "Using Database Management Systems" in the Database Module. Write queries to respond to the five information requests in the attached PDF file. We will review and practice in class, how to write and test single table queries in a Relational Database Management System (RDBMS). Use the metadata in the file to assist you in understanding the defined structure of the student table. Use the metadata to correctly write the queries for the 5 requests for information in the attached PDF document. Write your queries in a TEXT EDITOR document and upload the completed document into the drop box in this assignment link. Your answers MUST Be submitted as Text File WITH AN SQL EXTENSION Create SQL queries to extract the following from the Student table, whose metadata is shown Table: Student Column Name Data Type Size Description Student Number (Primary Key) Student First Name Student Last Name snum Text 6 firstname Тext 15 lastname Text 25 Address of the Student City of the Student State of the Student Zip Code of the Student street Text 25 city Text 15 st Тext Zip Тext Phone Text 10 Contact Phone Number Major Gpa gender scholarship Students Current Major Student Grade Point Average Gender of Student (For M) true = Yes ; false = No Text 15 Numeric Text 1 Boolean a. Student ID, Student Name, Phone Number for students that live in Newark DE b. Student ID, Student Name, Phone Number for students with grade point averages greater than 3.0 c. Student ID, Student Name, Phone Number for students that live in NY and PA d. Student Name, Address, City, State and Zip Code for students that are Female and major is CIS e. Student ID, Student Name, Phone Number for students in zip code 19130 that are on Scholarship Examine the Metadata/Data Dictionary in the attached PDF file. We will review in class what the term metadata means. If you want to get ahead, read the documents named "Using Database Management Systems" in the Database Module. Write queries to respond to the five information requests in the attached PDF file. We will review and practice in class, how to write and test single table queries in a Relational Database Management System (RDBMS). Use the metadata in the file to assist you in understanding the defined structure of the student table. Use the metadata to correctly write the queries for the 5 requests for information in the attached PDF document. Write your queries in a TEXT EDITOR document and upload the completed document into the drop box in this assignment link. Your answers MUST Be submitted as Text File WITH AN SQL EXTENSION Create SQL queries to extract the following from the Student table, whose metadata is shown Table: Student Column Name Data Type Size Description Student Number (Primary Key) Student First Name Student Last Name snum Text 6 firstname Тext 15 lastname Text 25 Address of the Student City of the Student State of the Student Zip Code of the Student street Text 25 city Text 15 st Тext Zip Тext Phone Text 10 Contact Phone Number Major Gpa gender scholarship Students Current Major Student Grade Point Average Gender of Student (For M) true = Yes ; false = No Text 15 Numeric Text 1 Boolean a. Student ID, Student Name, Phone Number for students that live in Newark DE b. Student ID, Student Name, Phone Number for students with grade point averages greater than 3.0 c. Student ID, Student Name, Phone Number for students that live in NY and PA d. Student Name, Address, City, State and Zip Code for students that are Female and major is CIS e. Student ID, Student Name, Phone Number for students in zip code 19130 that are on Scholarship

Answer rating: 100% (QA)

The SQL statements have been made in VS code a SELECT snum firstname lastname phone FROM ... View the full answer