Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Structural modeling is a different view of the same system that you analyzed from a functional perspective. This model shows how data is organized within

Structural modeling is a different view of the same system that you analyzed from a functional perspective. This model shows how data is organized within the system. Structural modeling provides a conceptual structure for the data, not specific technical aspects such as in what database it will be stored.

In this Application, create a structural model that depicts the systems interactions with the students in the WestEast College case. Perform the following steps:

Identify the classes implied by the case.

For each class, create a CRC card that includes appropriate attributes such as the students ID number, name, address, and phone number.

Explain and justify your choices.

Briefly explain the relationship between your structural model and your functional model.

West East College Case

WestEast College hires you as a systems analyst to design its new admission/registration system. WestEast College is one of the top ranked schools in the United States. It is a small private college with nearly 3,000 students, 100 faculty, and 50 supporting staff (including 10 full-time and four part-time IT staff who are responsible for supporting all academic and operational IT needs). The college accepts new and transfer students from other colleges and countries. The college only accepts online applications.

Once prospective students have completed and submitted their application and the college receives it, they submit additional documentation such as transcripts, recommendation letters, a personal essay, residency information, proof of language proficiency, and financial aid documents.

Once students are accepted, they take a placement test for math and English. If students pass the required tests, they are assigned general education classes (such as math, English, and social studies). If they do not pass a subject, they are assigned intensive classes in the failing subject.

Students progress through four years of classes and must maintain a 2.00 GPA or they are placed on probation for 2 quarters. If they drop below 2.00, students are dismissed. They must score at least a C to move to the next class or they must repeat the class (a D is not an acceptable grade).

Students must finish their degrees in no more than 5 years and cannot switch majors more than twice.

Students eligible for graduation must pass an assessment test in their major before they may graduate.

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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

13th Edition Global Edition

1292263350, 978-1292263359

More Books

Students also viewed these Databases questions

Question

How many Tables Will Base HCMSs typically have? Why?

Answered: 1 week ago

Question

What is the process of normalization?

Answered: 1 week ago