4. Use an appropriate database application to design a database for a school record. Name it SchoolRecord in the folder created. a) Create two tables as shown below, defining the fields appropriately: b) tbleRecord Telephone 0244586788 SRecordld Student FName Year Location SRD1 Julius davidson 2 Ghana Floyd George George Ali Martin Luther King SRD2 4 0545996644 Togo Congo Ghana SRD3 1 0485621234 SRD4 1 0257987654 SRD5 Dubois W. 3 0302555555 Ghana tblStudent STID SRecordId Program LLB House Age 20 SRD1 SRD2 St1 NADAA St2 36 BCom. МАНАМА St3 SRD3 15 PhD MILLS St4 SRD4 50 BEcons. KUFFOUR St5 SRD5 20 FORENSICS RAWLINGS c) Using the relations, create the relationships to enable a user to design a form to show the following Student Name: Age: Telephone: House: Location: d) Save the form as GCTUStudentfrm. e) Produce the relationship report and save as GCTUONLINE report in the database.
4. Use an appropriate database application to design a database for a school record. Name it SchoolRecord in the folder created. a) Create two tables as shown below, defining the fields appropriately: b) tbleRecord Telephone 0244586788 SRecordld Student FName Year Location SRD1 Julius davidson 2 Ghana Floyd George George Ali Martin Luther King SRD2 4 0545996644 Togo Congo Ghana SRD3 1 0485621234 SRD4 1 0257987654 SRD5 Dubois W. 3 0302555555 Ghana tblStudent STID SRecordId Program LLB House Age 20 SRD1 SRD2 St1 NADAA St2 36 BCom. МАНАМА St3 SRD3 15 PhD MILLS St4 SRD4 50 BEcons. KUFFOUR St5 SRD5 20 FORENSICS RAWLINGS c) Using the relations, create the relationships to enable a user to design a form to show the following Student Name: Age: Telephone: House: Location: d) Save the form as GCTUStudentfrm. e) Produce the relationship report and save as GCTUONLINE report in the database.
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
Please help solve
![PART II
4.
Use an appropriate database application to design a database for a school record.
Name it SchoolRecord in the folder created.
a) Create two tables as shown below, defining the fields appropriately:
b) tbleRecord
SRecordld Student FName
Year
Telephone
Location
SRD1
SRD2
Julius davidson
2
0244586788
Ghana
Floyd George
George Ali
Martin Luther King
Dubois W.
4
0545996644
Togo
Congo
Ghana
SRD3
1
0485621234
SRD4
1
0257987654
SRD5
3
0302555555
Ghana
tblStudent
STID
SRecordId
Program
LLB
House
Age
20
St1
SRD1
NADAA
St2
SRD2
36
BCom.
МАНАМА
St3
SRD3
15
PhD
MILLS
St4
SRD4
50
BEcons.
KUFFOUR
St5
SRD5
20
FORENSICS
RAWLINGS
c) Using the relations, create the relationships to enable a user to design a form to show
the following
Student Name:
Age:
Telephone:
House:
Location:
d) Save the form as GCTUStudentfrm.
e) Produce the relationship report and save as GCTUONLINE_report in the database.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F8f0b8107-f307-4007-90d4-35ddf255de99%2F342d83c7-a976-4a1b-b566-7cf59a1dbe23%2F9btcez8_processed.jpeg&w=3840&q=75)
Transcribed Image Text:PART II
4.
Use an appropriate database application to design a database for a school record.
Name it SchoolRecord in the folder created.
a) Create two tables as shown below, defining the fields appropriately:
b) tbleRecord
SRecordld Student FName
Year
Telephone
Location
SRD1
SRD2
Julius davidson
2
0244586788
Ghana
Floyd George
George Ali
Martin Luther King
Dubois W.
4
0545996644
Togo
Congo
Ghana
SRD3
1
0485621234
SRD4
1
0257987654
SRD5
3
0302555555
Ghana
tblStudent
STID
SRecordId
Program
LLB
House
Age
20
St1
SRD1
NADAA
St2
SRD2
36
BCom.
МАНАМА
St3
SRD3
15
PhD
MILLS
St4
SRD4
50
BEcons.
KUFFOUR
St5
SRD5
20
FORENSICS
RAWLINGS
c) Using the relations, create the relationships to enable a user to design a form to show
the following
Student Name:
Age:
Telephone:
House:
Location:
d) Save the form as GCTUStudentfrm.
e) Produce the relationship report and save as GCTUONLINE_report in the database.
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.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 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