Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Complex Variables and Applications

Authors: James Brown, Ruel Churchill

8th edition

73051942, 978-0073051949

More Books

Students also viewed these Mathematics questions