Database For this lab we will be taking our various tables created from our norm
ID: 3748203 • Letter: D
Question
Database
For this lab we will be taking our various tables created from our normalization process and entering them into Oracle.
For each of your tables you will use SQL and the CREATE TABLE command to create each table with it's various attributes (columns).
You will then use the INSERT INTO command to add 5 rows of data (you make up your own data) to populate each table.
After creating the tables and entering the data - use the SELECT * FROM tablename to list all of the data in each table. You can do a screen capture to save the table data.
Turn in each "screen shot" of each of your tables with all of the data.
InstructionsDatabase
For this lab we will be taking our various tables created from our normalization process and entering them into Oracle.
For each of your tables you will use SQL and the CREATE TABLE command to create each table with it's various attributes (columns).
You will then use the INSERT INTO command to add 5 rows of data (you make up your own data) to populate each table.
After creating the tables and entering the data - use the SELECT * FROM tablename to list all of the data in each table. You can do a screen capture to save the table data.
Turn in each "screen shot" of each of your tables with all of the data.
Explanation / Answer
If you hav any doubts, please give me comment...
CREATE TABLE Student(
StudentID INT NOT NULL PRIMARY KEY,
StudentName VARCHAR(100),
DOB DATE,
Major VARCHAR(20),
PhoneNUmber VARCHAR(20),
);
INSERT INTO Student VALUES(101, 'ANUNAGA', '1993/03/10', 'CS', '987-123-8873'),(102, 'John Storm', '1995/10/04', 'EC', '843-264-2766'), (103, 'Abraham', '1993/8/25', 'CE', '976-386-7553'), (104, 'Dean Winchester', '1992/8/16', 'EE', '866-754-7532'), (105, 'Sam', '1992/10/21', 'CS', '864-972-6534');
SELECT * FROM Student;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.