Question: Part A: Create a Database with SQL Plus Oracle. Given a business situation in which managers require information from a database, determine, analyze and classify
Part A: Create a Database with SQL Plus Oracle. Given a business situation in which managers require information from a database, determine, analyze and classify the data so that Queries can be created to speculate trends in the business. Shihan Kai Leung has an intensive background in Martial Arts and has offered instructions since the 1970s. The Shotokan style emphasizes rigorous physical training to develop the world-famous clean, robust linear and focus techniques. Whether you want to create a sound mind or a healthy body, our Dojo offers unlimited classes six days a week. We have classes for different levels and for children and adults. Based on the information provided below, create a database for Kai Leung's Shotojuku. We also offer team training classes in Kata, Kumite, and Kobudo for our competition team. http://shotojuku.com/ Requirements and Business Rules (Follow steps done in class) I do NOT need the Spool Use notepad -Copy and paste in the Final word document or take a screenshot. RUN THE SCRIPT On SQLPlus or ORACLE LIVE 1. Create tables (5 tables) 2. minimum 3 column names (attributes) 3. Include Primary Keys 4. Foreign Key with or without Alter table 5. On DELETE CASCADE 6. Normalize Tables. 7. Check the default insert for dates' DD-MON-YY.' 8. Drop tables statement at the begging of the script Don't forget that tables have CONSTRAINTS, and they must NOT be violated Start with tables that DO NOT have Foreign Keys fist Suggestions: Name of tables STUDENT, SCHEDULE, BILL, INSTRUCTORS, And TEAM
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
