Need help with a database assignment!! Can I get a screenshot of all the tables,
ID: 3675932 • Letter: N
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);