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

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.

[5/16, 12:08] Kim: This is a required assignment worth 15 points (15-points/1000-points). Assignment must be submitted by the due date. No late assignments are allowed. Please discuss the following topics and provide substantive comments to at least two other posts.

Select from the following list four (4) topics and discuss.

The discussion questions this week are from Chapter 2 (Jamsa, 2013).

Chapter 2 topics:

Define and describe PaaS

List the benefits of PaaS

Describe the potential disadvantages of PaaS

Describe how a cloud-based database management system differs from an on-site database.

List the computing resources normally provided with PaaS.

Assume your company must deploy a .NET solution to the cloud. Discuss the options available to developers. Research on the web and estimate the costs associated with deploying a PaaS solution.

Assume your company must deploy a PHP or Java solution to the cloud. Discuss the options available to developers. Research on the web and estimate the costs associated with deploying a PaaS solution.

Note: You are required to use at least two-peer reviewed sources (besides your textbook) to answer the above questions. The initial post is due by Wednesday at 11:59pm ET. You must engage on at least three separate days (by Wednesday for the first post and two additional days of peer engagement). Do not wait until Sunday to engage with peers, this should be an active conversation with your peers. When replying to peers be sure to engage with substantial posts that add to the conversation.

Environmental Sampling of Prokaryotes The class hypotheses: Ha: There will be no 1.1 differences in bacterial biodiversity among the surfaceon sampled. Ha: The door handles will have the greatest bacterial biodiversity. The p-value from the ANOVA test: _p = 0.3520 Myun Shannan-Were Figure 1. Bacterial biodiversity of surfaces sampled. 8. Based on that p-value, answer these questions: yes a. Is there a statistically significant difference in bacterial blodiversity? b. Which class hypothesis is supported by the statistical analysis? Alternative (H C. Explain why the graph alone cannot be used to determine if there is a statistically significant difference in bacteria biodiversity .For a classical ideal gas, let the surface area of that hyper-surface be ZE. By definition E = N!h3N JH