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 .