Computer Science Research Paper – Description
Practice Lab #1 – Validate the sample database is populated with STUDENT tables and data
Login to the DaaS environment and connect to Oracle for DBST 651 using the DBST_USER account. Before proceeding with the lab, you must validate that the COURSE, ENROLLMENT, GRADE, GRADE_CONVERSION, GRADE_TYPE, GRADE_TYPE_WEIGHT, INSTRUCTOR, SECTION, STUDENT, and ZIPCODE tables exist.
Validate tables exist using Oracle SQL Developer: Expand the ‘Tables’ node under the connection you made and you should see the 10 tables from the STUDENT schema.
Validate tables exist using SQL Developer with the following query:
SELECT table_name FROM user_tables;
If the 10 STUDENT tables do not exist, navigate to Course Content > Hands-on Resources > StudentSchema within the classroom using a browser in the DaaS environment. Extract the contents of the zip file and follow the instructions in the Readme.pdf to create the STUDENT schema.*
For each STUDENT table, execute a SELECT query displaying a count of the total number of rows in that table by replacing with the name of the STUDENT table.
SELECT COUNT(*) AS “Count of ” FROM ;
Example: SELECT COUNT(*) AS “Count of COURSE” FROM COURSE;
Deliverable:
Submit a single Word document that contains the query executed and output text or output screenshots showing the results for all 10 STUDENT tables. Ensure that both the column alias (i.e. ‘Count of ’) and the count itself is visible on all 10 results.
The post Computer Science Research Paper first appeared on .
