Assignment : You have been asked to create a small information system to administer the records of a small educational institution using MS Access. The following details need to be stored: students' surname, first name, date of birth, the date they enrolled in the institution, papers available for study, including the paper code and paper title, the enrolments of students in particular papers, including date of enrolment, mark gained, and fee charged. Create a database with the appropriate number of tables to store the above data and establish appropriate relationships between them.
Assignment : You have been asked to create a small information system to administer the records of a small educational institution using MS Access. The following details need to be stored: students' surname, first name, date of birth, the date they enrolled in the institution, papers available for study, including the paper code and paper title, the enrolments of students in particular papers, including date of enrolment, mark gained, and fee charged. Create a database with the appropriate number of tables to store the above data and establish appropriate relationships between them.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
![- Blackboard Learn
=view&content id3_68980 1&course id3 2576 1#
44 / 71
90%
Table 2.2: Data for the Customers table.
Customer ID
Job Description
Job Status
Completion Data
555-3451
555-6639
555-7877
555-2258
555-9111
555-8890
IMS
Jacob's Motor Sales
Kelth's Sports Cars, Inc.
Randy's Od Makes
Trevor's Rolling Wheels
Jacob Danlels
Kelth Moorehouse
Randy Petersen
Trevor Craig
Jack Johnson
Nick Stone
KSI
ROM
TRW
Jack's Timeless Classics
Nick's Quick Rides
ITC
NQR
Assignment :
You have been asked to create a small information system to administer the records of a small educational
institution using MS Access. The following details need to be stored: students' surname, first name, date of
birth, the date they enrolled in the institution, papers available for study, including the paper code and paper
title, the enrolments of students in particular papers, including date of enrolment, mark gained, and fee
charged.
Create a database with the appropriate number of tables to store the above data and establish appropriate
relationships between them.
99
3:57 P
A G 4)
4/27/20
DOLE
FT
F8
4
F9
F10
F11
F12
13
Insert
PrntS
PAE
&
Backspace
8
9.
%3D
U
J K
%31
Enter
1O](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb0423719-47ee-423b-98f3-708d5c95cd76%2Fc2366411-1c5a-4726-804e-3d9da3784168%2Fhqqi8yj_processed.jpeg&w=3840&q=75)
Transcribed Image Text:- Blackboard Learn
=view&content id3_68980 1&course id3 2576 1#
44 / 71
90%
Table 2.2: Data for the Customers table.
Customer ID
Job Description
Job Status
Completion Data
555-3451
555-6639
555-7877
555-2258
555-9111
555-8890
IMS
Jacob's Motor Sales
Kelth's Sports Cars, Inc.
Randy's Od Makes
Trevor's Rolling Wheels
Jacob Danlels
Kelth Moorehouse
Randy Petersen
Trevor Craig
Jack Johnson
Nick Stone
KSI
ROM
TRW
Jack's Timeless Classics
Nick's Quick Rides
ITC
NQR
Assignment :
You have been asked to create a small information system to administer the records of a small educational
institution using MS Access. The following details need to be stored: students' surname, first name, date of
birth, the date they enrolled in the institution, papers available for study, including the paper code and paper
title, the enrolments of students in particular papers, including date of enrolment, mark gained, and fee
charged.
Create a database with the appropriate number of tables to store the above data and establish appropriate
relationships between them.
99
3:57 P
A G 4)
4/27/20
DOLE
FT
F8
4
F9
F10
F11
F12
13
Insert
PrntS
PAE
&
Backspace
8
9.
%3D
U
J K
%31
Enter
1O
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY