Description: The purpose of this assignment is to gain additional experience in deciphering user requirements and business rules and use them draw enhanced entity relationship (EER) diagrams. The ability to critically think through business requirements and take abstract constructs to create an effective solution is again key.
Assignment Instructions:
Business is booming and you have met with an additional client. This time, the business rules are more complex and require a more detailed or enhanced ERD. The client wants to make sure you understand their requirements, are capable of designing the right solution, and are expecting you to create a professional-looking document for the CFO of their respective companies (to justify your consulting fees). Additionally, the client also wants you to present your solutions to several members in their IT department.
Listed below are the notes that were written at the business requirements meeting with the client. The goal is to gain additional experience with creating professional, documented solutions and then to effectively articulate your solutions to the client for their feedback to ensure you understand their business requirements. It is common for the management of the company to want a comprehensive Word document of your solution.
Notes for New Client 1, Develop an EER model for the following situation and make sure to list all assumptions.
An international school has hired your company to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities and initial business rules. As far as attributes, the president could not think of them all and is relying on your expertise to critically think through what they need and flesh out the attributes for each entity.
.
- Room is identified by Building ID and Room No and also has a Capacity, etc. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called Board Type.
- Media is identified by MType ID and has attributes of Media Type and Type Description. Note: Here they are tracking type of media (such as a DVD, Blu-ray, projector, etc.), not the individual piece of equipment. Tracking of equipment is outside the scope of this project.
- Computer is identified by CType ID and has attributes Computer Type, Type Description, Disk Capacity, Processor Speed, etc. Note: As with Media Type, they only want to track the type of computer, not an individual computer. You can think of this as a class of computers.
- Instructor has identifier of Emp ID and has attributes Name, Rank, Office Phone, etc.
- Timeslot has identifier TSIS and has attributes Day of Week, Start Time, End Time, etc.
- Course has identifier Course ID and has attributes Course Description, Credits, etc. Courses can have one, none, or many prerequisites. Courses also have one or more sections.
- Section has identifier Section ID and attribute Enrollment Limit, etc.
- An instructor teaches one, none, or many sections of a course in a given semester.
- An instructor specifies preferred time slots.
- Scheduling data are kept for each semester, uniquely identified by semester and year.
- A room can be scheduled for one section or no section during one time slot in a given semester of a given year. However, one room can participate in many schedules, one schedule, or no schedules; one time slot can participate in many schedules, one schedule, or no schedules; one section can participate in many schedules, one schedule, or no schedules.
1
- A room can have one type of media, several types of media, or no media.
- Instructors are trained to use one, none, or many types of media.
- A lab has one or more computer types however, a classroom does not have any computers.
- A room cannot be both a classroom and a lab. There are also no other room types to be incorporated into the system.
Notes for New Client 2, Develop an EER model for the following situation and make sure to list all assumptions.
Jane Elliott and her business partner Nadine LaRue have formed a new limited partnership, Elliott LaRue Cybersecurity Consultants. Elliott and LaRue consults with corporations to determine their security needs. You have been hired by Jane and Nadine to design a database management system to help them manage their business.
Due to a recent increase in business, Elliott and LaRue has decided to automate its client tracking system. Your team have done a preliminary analysis to determine the following set of entities and business rules. As far as attributes, they are relying on your expertise to critically think through what they need and flesh out the attributes for each entity.
- Consultant—there are two types of consultants: business and technical consultants. Business consultants are contacted by a business in order to first determine security needs and provide an estimate for the actual services to be performed. Technical consultants perform services according to the specifications developed by the business consultants. Attributes of consultant include employee ID (identifier), name, address (street, city, state, zip, etc.), tele numbers, date of birth, age, business experience (composed as number of years), type of business (or businesses), technical skills, degrees received, certifications, etc.
- Customer—customers are businesses that have asked for consulting services. Attributes include customer ID (identifier), company name, address (street, city, state, zip code, etc.), contact name, contact title, contact tele, business type, number of employees, etc.
- Location—customers can have multiple location. Attributes include customer ID (identifier), location ID (which is unique only for each customer ID), address (street, city, state, zip, etc.), tele, building size.
- Service—A security service is performed for a customer at one or more locations. Before services are performed, an estimate is prepared. Attributes of service include service ID (identifier), description, cost, coverage, clearance required, etc.
- Additional Business Rules—the following information will need to be stored to tables and should be shown in the model. These may be entities, but they also reflect a relationship between more than one entity:
- Estimates, which have characteristics of date, amount, business consultant, services, customer, etc.
- Services performed, which have characteristics of data, amount, technical consultant, services, customer, etc.
- A customer may have many consultants providing many services. Client wants to track both actual services performed as well as services offered. Therefore, there should be two relationships between customer, service, and consultant, one to show services performed and one to show services offered as part of the estimate.
For Both Diagrams:
In addition to the EER diagram, this client has requested you to develop a sample definition for each entity type, attribute, and relationship in the diagram.
Use the Crow’s Feet notation in your diagrams.
APA
CLICK HERE FOR FURTHER ASSISTANCE ON THIS ASSIGNMENT
The post The purpose of this assignment is to gain additional experience in deciphering user requirements and business rules and use them draw enhanced entity relationship (EER) diagrams. The ability to critically think through business requirements and take abstract constructs to create an effective solution is again key. appeared first on Apax Researchers.
