Business.baylor.edu



In-Class Data Modeling ProblemsProblem #1A nonprofit seeks to provide personal and career counseling to clients. They assign members of the nonprofit staff as advisors to the clients but don’t want to overwhelm their staff with too many clients—each staff advisor is able to handle a certain number of clients at once, and this number differs per staff person. The nonprofit currently tracks the information below about their clients but wants to track more client information such as what is discussed each time the client meets with their assigned advisor. The amount of time advisors spend in each client session is also important to know to receive government funding. Design the ERD, and suggest other fields they may want to store.In-Class Data Modeling ProblemsProblem #2The Jonesboro County Basketball Conference (JCBC) is an amateur basketball association. Jonesboro County is made up of several cities; each city has one team that represents it in the JCBC. A few cities do not yet have teams. Each team has a between 9 and 12 players. Each team has a full-time head coach and may also have up to two part-time coaches (for example, offensive and defensive coaches). All coaches receive a salary based on their experience and level of education. Each team plays games against other teams during the season. Each game has a home team and a visitor team. Design the ERD, and suggest other fields they may want to store.In-Class Data Modeling ProblemsProblem #3A real-estate firm lists property for sale. The firm has a number of sales offices in several states. Attributes of sales office include office_number and location.Each sales office is assigned one or more employees. Attributes of employee include employee_id and employee_name. Each employee is assigned to only one sales office.There is always an employee assigned to manage a sales office.The firm lists property for sale. Attributes of property include property_id and location. A location consists of an address, city, state, and zip_code.Each unit of property must be listed with a sales office (and only one sales office). A sales office may have any number of properties listed or may have no properties listed.Each unit of property has one or more owners. Attributes of owners are owner_id and owner_name. an owner may own one or more units of property. An attribute of the relationship between property and owner is percent_owned.Design the ERD for this scenario.In-Class Data Modeling ProblemsProblem #4The H. I. Topi School of Business operates international business programs in 10 locations throughout Europe. The school had its first class of graduates in 1965. The school keeps track of each graduate’s student number, name when a student, country of birth, current country of citizenship, current name, current address, and the name of each major the student completed (each student has one or two majors). To maintain strong ties to its alumni, the school holds various events around the world. Events have a title, date, location, and type (eg, reception, dinner, or seminar). The school needs to keep track of which graduates have attended which events. For an attendance by a graduate at an event, a comment is recorded about information school officials learned from that graduate at that event. The school also keeps in contact with graduates by mail, email, telephone, and fax interactions. As with events, the school records information learned from the graduate from each of these contact communications. When a school official knows that he or she will be meeting or talking to a graduate, a report is produced showing the latest information about that graduate and the information learned during the past two years from that graduate from all communications with that graduate, and the events the graduate attended.Design the ERD, and suggest other fields they may want to store. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download