View the step-by-step solution to:

I have some of it done, but I'm unsure if I'm on the right track.

I've been assigned to create normalized database, and would love some help with turning the "Sample Sheet" into a normalized database.  I have some of it done, but I'm unsure if I'm on the right track.

Could you break the "Sample Sheet" into the different tables, and assign relationships to them?

I'll attach both the ER Diagram and the Project information sheet.


Thank you for your help,

Brian

Background image of page 1
CIS240 Database Design Kenneth W. Riddle Final Project The fre department wants to begin tracking their equipment with a database instead oF a sign out sheet. Sample Sheet Business Rules 1. Equipment already checked-out cannot be rechecked out. 2. All checked-out equipment must be checked-in. 3. All ±mes, dates and personnel checking equipment must be recorded. 4. Equipment must be checked out by one or more individuals. 5. Checked-in equipment must be witnessed or signed in by one oF the equipment personnel. 6. The condi±on oF checked-in equipment must be verifed by the equipment personnel. ²or simplicity sake, the Following condi±ons will be recorded – good, normal wear, damage or broken. 7. Insurance requires each poten±al vehicle driver to sign the check-out sheet. This can include up to 4 people. 8. The gas level oF each vehicle will be recorded when checked-in. (Rounded by quarter tank.) Equipment List Equip. Number Equip. Type Equip. Model 100 Phone A94560345 101 Phone M870045 102 Phone A98000105 104 Radio R0989 105 Radio R0989 106 Radio R0989 107 Vehicle ²ord Car 108 Vehicle ²ord Car 109 Vehicle Dodge Truck 110 Vehicle Dodge Truck 111 Ipad A56907845 112 Ipad A56907845 113 Ipad A56907845
Background image of page 1
CIS240 Database Design Kenneth W. Riddle Final Project Equipment Personnel Name Badge Number Java, John F170 Lovelace, Ada F409 Project Tasks 1. Design the Fire Equipment list database and normalize the tables. 2. Create an ER Diagram (Crow’s Foot) using Workbench. Name and type all variables. 3. Produce a PNG fle o± the design and paste it into a Word document 4. Insert sample data into the database. 5. Run a query on each table showing the inserted data. Make a screenshot o± each and paste into your Word document. 6. Run a query showing all checked-out equipment. Make a screenshot and paste it into the Word document.
Background image of page 2
Sign up to view the entire interaction

Top Answer

Here is the answer. I have attached the... View the full answer

FireEquipment.docx

Normalized Tables
CheckOut
CheckOut_Date
EquipNo
BadgeNO
DriverSign Equipment
Equip.No
Type
Model Employee
EmpNo
firstName
LastName
Position
BadgeNo Positions
PositionID
Description
The ERD...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online