BrandonBerne_Week4_Assignment - internal database A list of...

Info icon This preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Brandon Berne 5/23/2010 Week4 ILab Why use a foreign key? From what I’ve been able to learn you use a foreign key to ensure table integrity. They’re also used to establish relationships between tables. Where does a foreign key go in your entities and why? A foreign key always goes in a child entity. Entity Definition Matrix Entity Name Business Definition Check-Ins The act of returning equipment that was out in an employee’s possession. Check-Outs The act of lending equipment for an employee to use. damage injury or harm impairing the function or condition of a person or thing Employee a worker who is hired to perform a job Employee Id A numeric identification method for employees Equip ID A numeric Identification method for keeping track of tools.
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: internal database A list of all the equipment available to be checked out or in. maintenance managers Person in charge over supervisors. outstanding loans Equipment that is currently checked out. qty in Amount of equipment being returned. qty out Amount of equipment being checked out Brandon Berne 5/23/2010 Week4 ILab skill classification Set of a that person posses to allow them to perform certain tasks that require a level of training. supervisor Person in charge over employees. tracked equipment Equipment which is monitored by location/employee/skill classification untracked equipment Equipment that is unmonitored and still expected to be returned....
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern