Using Microsoft Access, define a database called Student Registration consisting

Question

Using Microsoft Access, define a database called Student Registration consisting of six tables: Student, with the following fields: ID, primary key, short text of length 4 Last Name, short text of length 15 First Name, short text of length 15 Major Code, short text of length 3 Advisor Code, short text of length4 . . Credits, integer Major: Major Code, primary key, short text of length 3 Major Name, short text of length 30 Advisor: .Advisor id, primary key, short text of length 4 Last Name, short text of length 15 .First Name, short text of length 15 Course Course Code, primary key, short text of length 8 . Course Name, short text of length 30 . Credits, integer Section . Section ID, primary key, short text of length 8 . Course ID, short text of length S .Term, short text of length 8 . Section Year, short text of length 4 Instructor, short text of 30 Registration . . . Student ID, primary key, short text of length 4 Section ID, primary key, short text of length 8 Grade, text of length 2 SAMSUNG

Explanation / Answer

1. SELECT s.FirstName, s.LastName, c.CourseName, r.Grade FROM

Student s, Course c, Registration r, Section sc

WHERE s.ID = r.StudentID AND r.SectionID = sc.SectionID AND sc.CourseID = c.CourseCode;

2.

SELECT s.FirstName, s.LastName, m.MajorName, a.FirstName, a.LastName

FROM Student s, Major m, Advisor a

WHERE s.MajorCode = m.MajorCode AND s.AdvisorCode = a.AdvisorCode;

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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