Need help with a database assignment!! Can I get a screenshot of all the tables,

Question

Need help with a database assignment!! Can I get a screenshot of all the tables, table relationships, form, and report? Thanks in advance for your help!

-------------------------------------------------------------------------------------------------------------------------------------------------

Access Project: Develop an Access Database that illustrates the registration process at Mount Olive College.

Based upon the information below, create a Microsoft Access Project that accomplishes the following tasks:

Project Part 1

Make a table for students that contains fields for the following data: first name, last name, student ID, major, and matriculation date. Be sure to set the correct primarykey.

Make a table for instructors that contain fields for the following data: first name, last name, instructor ID. Be sure to set the correct primary key.

Make a table for rooms that contains fields for the following data: room number, and building ID. Be sure to set the correct primary key.

Make a table for courses that contains fields for the following data: course ID, and course title. Be sure to set the correct primary key.

Make a table for course offerings that contains fields for the following data: course ID, section ID, term offered, year offered, instructor ID, room number, starting time, ending time, and building ID. Be sure to set the correct primary key.

Make a table for course registrations that contains fields for the following data: course ID, section ID, student ID.

Update each of the six tables with at least seven (7) records, using your own fictitious data.

Create a form to input new course registrations. This form should have CourseID, SectionID, and StudentID.

Create a report that shows course registrations

Explanation / Answer

1)

CREATE TABLE `students` ( `first name` VARCHAR(20) NOT NULL , `last name` VARCHAR(20) NOT NULL , `student ID` VARCHAR(10) NOT NULL , `major` VARCHAR(10) NOT NULL , `matriculation_date` DATE NOT NULL , PRIMARY KEY (`student ID`));

2)

CREATE TABLE `instructor` ( `first name` VARCHAR(20) NOT NULL , `last name` VARCHAR(20) NOT NULL , `instructor ID` VARCHAR(10) NOT NULL , PRIMARY KEY (`instructor ID`));

3)

CREATE TABLE `rooms` ( `room number` INT NOT NULL ,`building ID` VARCHAR(10) NOT NULL , PRIMARY KEY (`building ID`));

4)

CREATE TABLE `course` ( `course ID` VARCHAR(10) NOT NULL ,`course title` VARCHAR(20) NOT NULL , PRIMARY KEY (`course ID`));

5)

CREATE TABLE `course_offering` ( `course ID` VARCHAR(10) NOT NULL , `section ID` VARCHAR(10) NOT NULL,`term offered` INT NOT NULL,`year offered` INT NOT NULL,`instructor ID` VARCHAR(10) NOT NULL,`room number` INT NOT NULL,`starting time` TIME NOT NULL,`ending time` TIME NOT NULL,`building ID` VARCHAR(10) NOT NULL, PRIMARY KEY (`course ID`));

6)

CREATE TABLE `course_registration` (`course ID` VARCHAR(10) NOT NULL , `section ID` VARCHAR(10) NOT NULL,`student ID` VARCHAR(10) NOT NULL);

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

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