Database Requirements

The Irvine Ant Hill College has several schools: a school of business, a school of liberal arts and sciences, a school of engineering, and a school of humanities. The data stored on each school includes a school code, school name, location, and dean number.

Each school is administered by a dean. The information about each dean includes a

unique dean number, dean's name, and phone number.

Each school is made up of several departments. For example, the school of business

has an accounting department, a management department, an economics department, and a computer science department. The data stored on each department includes a unique department number, a department description, location, and the number of faculty in the department.

Each department offers several courses. For example the management department

offers courses such as introduction to management, principles of marketing, real estate management, and so on. The course number, description, and number of credits are stored for each course.

A course may have several sections. For example, the computer science department

may offer two Python programming sections, three C++ programming sections, four

database management programming sections, and so on. Each section is taught by a

single professor. The section number, day, and time must be stored for each section.

Each department hires several professors, but each professor is assigned to a single

department. Each department is chaired by a department chair, who is a professor. The information stored on each professor includes a unique faculty number, his/her name, highest degree earned, and salary.

Each professor may teach up to five classes, each one a section of a course. A

professor may also be on a research contract and teach no classes at all.

Each student can enroll in several courses, but a student is enrolled in only one section of a course. For example, it is not possible for a student to enroll in two or more sections of CS 37 C++ programming during any given semester. A student may enroll in up to 6 sections of different courses, each section containing up to 35 students. The enrollment information stored on each class section includes the student number, and grade for each student.

Each department has several students whose major is offered by that department.

However, each student only has a single major. The information saved on each student

includes a unique student number, name, and major.

Each student has an advisor in his or her department. Each advisor advises several

students. An advisor is also a professor. But not all professors advise students.

To Do

Draw a conceptual ERD. Fill in all missing cardinalities and justify each with a business rule.

A statistical program is recommended. An article reported on various chemical properties of natural and artificial soils. Here are observations on x = cation exchange capacity (CEC, in meq/100 g) and y = specific surface area (SSA, in m/9) of 20 natural soils. X 65 121 133 101 78 89 63 57 117 118 76 125 75 71 133 104 76 96 58 109 y 176 323 460 289 205 210 295 161 314 265 236 355 240 133 431 306 132 269 158 303 Minitab gave the following output in response to a request for r. correlation of x and y = 0. 850 Normal probability plots of x and y are quite straight. (a) Carry out a test of hypotheses to see if there is a positive linear association in the population from which the sample data was selected. State the appropriate null and alternative hypotheses. OH: P = 0 H: p > 0 O Ho: P = 0 Ha: p #0 O Ho: p # 0 Ha: P = 0 O Ho: P = 0 Ha: p