Question: Can someone please help me with my database homework? Homework Four Address Phone Status -- Student SNum SName 101 John 102 Scott 123 main 22
Can someone please help me with my database homework? 

Homework Four Address Phone Status -- Student SNum SName 101 John 102 Scott 123 main 22 main 562-111-1111 562-222-2222 562-333-3333 junior junior sophomore 103 Mary 789 main 111 main 104 Bill 562-444-4444 senior -- Course CNum CTitle Unit -- Enrollment SNum CNum 101 380 Grade 300 3 102 380 380 385 MIS Intro Database System Analysis and Design 103 300 104 300 101 300 102 385 Homework Four (Cont.) In Oracle Database, - create the above three tables, and make sure you have integrity rules specified as we discussed in the class (primary key and foreign keys). Insert data into the tables (the data shown in the above tables). . Note that order of inserts matters. - Insert some data that can cause integrity check failure Insert one row that can cause entity integrity check error - Insert one row that can cause referential integrity check error
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
