Microsoft Access "SQL" Coding statements

Mylay1990

artcoursedatabase3.accdb

Home >Computer Science homework help >Microsoft Access "SQL" Coding statements

CourseNumber	Course_name	CourseDate	Fee
1	Adv Pastels	10/1/2011	500
2	Beg Oils	9/15/2011	350
3	Int Pastels	3/15/2011	350
4	Beg Oils	10/15/2011	350
5	Adv Pastels	11/15/2011	500

CustomerNumber	CustomerLastName	CustomerFirstName	Phone
1	Johnson	Ariel	206-567-1234
2	Green	Robin	425-678-8765
3	Jackson	Charles	360-789-3456
4	Pearson	Jeffry	206-567-2345
5	Sears	Miguel	360-789-4567
6	Kyle	Leah	425-678-7654
7	Myers	Lynds	360-789-5678

CustomerNumber	CourseNumber	Amountpaid
1	1	250
1	3	350
2	2	350
3	1	500
4	1	500
5	2	350
6	5	250
7	4	0

CREATE TABLE CUSTOMER (CustomerNumber INTEGER NOT NULL, CustomerLastName CHAR(25), CustomerFirstName CHAR(25), Phone CHAR(12), CONSTRAINT CUST_pk PRIMARY KEY (CustomerNumber));

CREATE TABLE COURSE (CourseNumber integer, Course_name CHAR(25), CourseDate TEXT, Fee CHAR(25), CONSTRAINT COURAE_pk PRIMARY KEY (CourseNumber));

CREATE TABLE ENROLLMENT (CustomerNumber integer, CourseNumber integer, Amountpaid varchar, CONSTRAINT ENROLLMENT_fk1 FOREIGN KEY (CustomerNumber) REFERENCES CUSTOMER(CustomerNumber), CONSTRAINT ENROLLMENT_fk2 FOREIGN KEY (CourseNumber) REFERENCES COURSE(CourseNumber));

SELECT * FROM COURSE;