MIS4113: Homework #3 – Spring 2026

Part 1 – (30pts)Entity-Relationship and Database Diagramming Using Crow’s Foot Notation

1. (9pts) Using Visio or LucidChart, draw the following entities and relationships:
   1. PATIENT (PatientID, LastName, FirstName, DateOfBirth)
   1. APPOINTMENT (AppointmentID, PatientID, ApptDate, ApptTime, Reason)
   1. Notes:
      1. The PATIENTentity can stand on its own.
      1. The APPOINTMENTentity is dependent upon PATIENT.
      1. The relationship between the entities is as follows:
         1. A PATIENT may have no appointments (e.g., a new registration) or can have many APPOINTMENTS.
         1. An APPOINTMENT belongs to one and only one PATIENT.

Paste an image of your conceptual E-R diagram here:

• (6 pts) Transform the drawing above into a database diagram as outlined in the lectures and Chapter 6 of the textbook.

Paste an image of your database diagram here:

• (9 pts) Using Visio or LucidChart, draw the following entities and relationships:
  • STOCK(TickerSymbol, CompanyName, FedID#, HQCity, HQState, Industry)
  • INVESTOR(InvestorID, InvestorName,SS#, City, State, Type)
  • Notes:
    • The STOCK entity can stand on its own.
    • The INVESTOR entity can stand on its own.
  • The relationship between the entities is as follows:
    • A STOCK may be owned by zero or more INVESTORs.
    • An INVESTORmust own at least one STOCK and may own many STOCKs.

Paste an image of your conceptual E-R diagram here:

• (6 pts) Transform the STOCK and INVESTOR diagram above into a database diagram as outlined in the lectures and Chapter 6 of the textbook.

Paste an image of your database diagram here:

Part 2– (40 pts) Creating a CONCEPTUAL Entity-Relationship Diagramming

You will be graded on:

1. (8pts) Identifying the correct relations and attributes
2. (8pts) Diagramming the necessary entities
3. (8 pts)Correct minimum cardinality
4. (8 pts) Correct maximum cardinality
5. (8 pts) Formatting relationship lines, identifiers, attributes, and entity names correctly

Alotta Hot Air HVAC – Invoice                                                         

                                                                        Amount Due:$2,582.00

Customer Details:
First Name: AlexLast Name:Rao                      Cust#: A08743            

Email:arao@gmail.com                                  Phone:  252-321-5648

Address:1235^thSt         City: Greenville           ST: NC              ZIP: 27858

Service Details:

Date of service:2/13/2026      LaborHrs:7.25            
ServiceDescription:Install new air handler    Service Code:AirHand-Rpl
Service Category:A-H Install

TechnicianDetails: 

TechID:RP        TechName:Big Mike               Experience Level:Sr                Hourly Rate:$100

Alotta Hot Air HVAChas hired you to develop a database to track their service transactions. They are interested in tracking 1) the customers they serve, 2) the technicians who work for the company,3) the services they provide and 4) the work orders they complete. Below are the business rules that relate to the information they want to track in the database they have asked you to design.

BUSINESS RULES:

A customer may have no work orders and may have many.
A work order is assigned to one and only one customer.

A technician may be assigned to no work orders and may be assigned to many work orders.
A work order has exactly one technician assigned to it.

A service may be included in zero or many work orders.

A work order must include at least one service and may include many services.

For each transaction the company completes, they want to track which customer is servicedby which technician, which services are provided, the date of the transaction and the total amount due.

Paste an image of your CONCEPTUAL drawing here:

Part3– (30 pts) Logical Database Diagramming Using Crow’s Foot Notation

You will be graded on:

1. (6pts) Diagramming of the necessary entities
2. (6 pts) Diagramming of the necessary attributes
3. (6pts) Including reasonable data types and null statusfor each attribute
4. (6 pts) Correct relationships and cardinality
5. (6 pts) Identification of primary, foreign, and alternate keys in the correct format

Paste an image of your database drawing here: