Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

For my SQL project i have gotten a couple of The requirements to work except for a couple.

/in /by

For my SQL project i have gotten a couple of The requirements to work except for a couple. I made 3 tables
CREATE TABLE Faculty (

FacultyID INT(6) PRIMARY KEY,

FirstName VARCHAR(50) NOT NULL,

LastName VARCHAR(50) NOT NULL,

Email VARCHAR(255) NOT NULL,

Date_of_Birth INT NOT NULL,

Date_of_Hire date NOT NULL

);

2. Show how to make a table named Courses to store CourseID (Primary key), Discipline Name (e.g. SDEV), Course Number (e.g. 300), Number of Credits (e.g. 3), Year first offered (e.g. 2010) and Course Title. You should select the appropriate data types and constraints for the table.

Answer:

CREATE TABLE Courses (

CourseID INT(6) PRIMARY KEY,

Discipline VARCHAR(50) NOT NULL,

Course_Number INT(11) NOT NULL,

Date_First_Offered INT(11) NOT NULL,

Number_of_Credits INT(11) NOT NULL,

Course_Title VARCHAR(50) NOT NULL

);

3.Make a table named facultycourses to store Faculty and Courses taught and should be designed based on the faculty and course tables previously created using primary and foreign keys.

Answer:

CREATE TABLE FacultyCourses (

FacultyCoursesID INT(6) PRIMARY KEY,

FacultyID INT(6) NOT NULL,

CourseID INT(6) NOT NULL,

FOREIGN KEY (FacultyID) REFERENCES Faculty(FacultyID) ,

FOREIGN KEY (CourseID) REFERENCES Courses(CourseID)

);

i am having trouble making these requirements.

I need to be able to insert statements to populate at least 20 faculty records, 20 course records and 25 faculty course records
Use the correct select statements to display all records in all 3 tables. The faculty query should display the faculty last name in descending order and the Courses query should display the courses in ascending order by course title. the FacultyCourses table is not specified. 3 select statements can be created to satisfy the requirement
Use select and appropriate Joins to display all columns from the faculty and courses tables each faculty and Faculty and Course in the FacultyCourses table. This will be a 3-table join.
Thank you. i would appreciate the help and will happily compensate extra

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"