create the following 3 tables with the column names and sizes defined using crea

Question

create the following 3 tables with the column names and sizes defined using create table SQL Email Table Student Number Date 2/1/2012 3/15/2012 3/15/2012 EmailNum Message For homework 1, do you want us to provide notes on our references? My group consists of Swee Lau and Stuart Nelson Could you please assign me to a group? 1325 1329 1644 Student Table Student Number Student Name HW1 HW2 MidTerm 1325 1644 2881 3007 3559 BAKER, ANDREA LAU, SWEE NELSON, STUART 100 90 FISCHER, MAYAN 95 100 TAM, JEFFREY VERBERRA, ADAM 70 90 VALDEZ, MARIE ROGERS, SHELLY 78 90 98 74 100 75 90 100 486 92 85 98 5265 80 90 8009 95 100 OffceVisit Table VisitID Date 2/13/2012 Andrea had questions about using IS for raising barriers to entry 2/17/2012Jeffrey is considering an IS major. Wanted to talk about career opportuniti 2/17/2012 Will miss class Friday due to job conflict Notes Student Number 1325 3559 4867 Note: 1. Table and Column names can't have space in between 2. Change the column name Date on Email_Table to Email_Date, change Date on Office_Visit to Visit Date 3. You need to create 3 queries, save query to names such as "create student table query, create email table query, and create office_visit table query

Explanation / Answer

1.

Create table Email (EmailNum int, Date DATE,Message varchar(100), StudentNumber int,Primary key(EmailNum));

Create table Student (StudentNumber int, StudentName varchar(20), hw1 int,hw2 int, MidTerm int, Primary key(StudentNumber));

Create table Visit (VisitID int, Date DATE, Notes varchar(255), StudentNumber int, Primary key(VisitiD), FOREIGN KEY (StudentNumber) REFERENCES Student (StudentNumber));

2.

ALTER TABLE Email RENAME Date TO Email_Date;

3.

Create view As Create_student_table_query select StudentNum,StudentName from Student;

Similarly, you can create other 2 views, Views help to save the query for future use like

Select * Create_student_table_query where StudentNum=1;

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.