The tables are attached in separate file!
Use the DESCRIBE command to display the data types of the columns after each table is created.
Use the ALTER TABLE statement to define the StudentID as the PRIMARY KEY for the STUDENTS table.
Use the ALTER TABLE statement to define the StudentID and CourseNumber as the PRIMARY KEY for the COURSES table.
Use the ALTER TABLE statement to define StudentID in the COURSES table as a FOREIGN KEY that references the StudentID in the STUDENTS table. Use the USER_ tables and display the following metadata:
List the tables in the presently in the schema
List the Indexes
List the Views
For the STUDENT and COURSES tables, display the columns in each table, their data types and whether or not they allow NULL values
For the STUDENT and COURSES tables, display constraints on each table For each student, count the number of courses he or she has taken.
Modify the above query to only count CMIS courses.
Add .05 to all of the CMIS major's GPA's ??" the instructor has been grading too strictly!
Change Sam's tutor from Sue to Jane
For any student who is currently majoring in CMIS and who has a GPA of less than 3.0, change their major to Marketing ??" they need an easier option!
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
**I need all the statements to execute the above queries!**