Great Deal! Get Instant $25 FREE in Account on First Order + 10% Cashback on Every Order Order Now

PowerPoint Presentation Access Homework: create the following 3 tables with the column names and sizes defined using create table SQL Note: 1. Table and Column names can’t have space in between 2....

1 answer below »

PowerPoint Presentation
Access Homework: create the following 3 tables with the column names and sizes defined using create table SQL
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
4. Once you have completed, close all tabs, then click File, Save As, then click on “Save As” button, then save it as Section number ? Your name? Access HW, then submit the homework without zip, via the Canvas assignment tab.

First row of the Email Table is related to Andrea Baker in Student Table.
Last row in Office_Visit Table related to Adam Ve
e
a in Student Table.
Answered 1 days AfterFeb 25, 2022

Solution

Kshitij answered on Feb 27 2022
31 Votes
create table student(student_number int primary key, student_name varchar2(22), hw1 int,hw2 int, midterm int);
create table email(emailNum int primary key,e_date Date, message varchar(50), student_number int, FOREIGN KEY (student_number)REFERENCES student1(student_number));
create table...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here