Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Student Information System (SIS) database stores information about courses offered by the University, some basic information about instructors and students, and student course experiences.

image text in transcribed
image text in transcribed
The Student Information System (SIS) database stores information about courses offered by the University, some basic information about instructors and students, and student course experiences. Information about courses consists of the folowing facts: course number, the name and the code of the offering department, the general anea of study (e.g. Engineering, Business, and Professional Courses), a list of topics coveredin the course. Note that a course number is unique only within a specific department. For each instructor, we store a name, gender, age, and areas of expertise (if applicable). An instructor can be permanent faculty or a freelancer. If an instructor is faculty, we store the year when they started their career as a faculty, and whether they ane teaching or research faculty. If an instructor is research faculty, we record a list of their research interests. For each student identified by a unique Student ID-we store basic demographic data such as year and month of birth, gender, and country of birth. In addition, we store the year and month when this student begun his study at university. Additional information about students incude their professional history outside our University. For each significant job that the student held in the past or is now, we record the job title, Company name (or self-employed), Company expertise (can be more than one), start and end date of the employment, and a list of skills used during or acquired on the job. Each time the course is offered we call it an 'edition of the course. For each edition we record the start and end date, the time of day the course was offered (Start Date, End Date, Timings), an approximate overall number of students enrolled in this course, and the name of the course instructor. Each edition of a course can be co-taught by more than one instructor

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Datacasting How To Stream Databases Over The Internet

Authors: Jessica Keyes

1st Edition

007034678X, 978-0070346789

More Books

Students also viewed these Databases questions