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...
icon
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
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
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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…
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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY