Question
In this database assignment, you are to use Oracle LiveSQL to create two tables, add data to these tables, and check whether data has been
In this database assignment, you are to use Oracle LiveSQL to create two tables, add data to these tables, and check whether data has been added to the tables. Requirements for this project are the following: 1) Create the schema for two tables (Students table and Courses table) (35 points in total) a) Students table (attribute names and their data types) (20 points) Attributes _____ Data types__________ ManeID char(5) primary key StuName char(20) Major char(3) GPA Number(3, 2) b) Course table (attribute names and their data types) (15 points) Attributes Data types_________ CourseID char(9) primary key Department char(3) Title varchar2(20) creditHour number(1) 2) Perform the following activites to data to these two tables (35 in total) a) add 4 records of data to the Students table (10 points) ManeID StuName Major GPA 10000 Jason ACC 3.0 10001 Mary FIN 3.4 10003 Tommy CIS 3.8 10004 YourOwnName MBA 4.0 b) add 2 records of data to the Course table (5 points) CourseID Department Title CreditHour CIS366 CIS Database 3 CIS622 MBA System analysis 3 c) delete Jason from the Student table (5 points) d) change Mary's GPA to 3.6 (15 points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started