Using the attached document:

 

1. define three (3) business processes that will access a particular table and attribute. For example: "A customer login process will require accessing the CUSTOMER table and retrieving the CustomerID and CustomerPassword attributes". Provide detail on what the business process is and who is involved. For each business process, provide the SQL that would need to be run to access it in the first, second, and third normal forms you provided in the previous section. 
2. Finally, choose a database optimization strategy, whether physical or logical, and describe how it could potentially benefit any or all of your normal form examples. Provide a comparison between a use case with and without this strategy implemented.

 

Project – Part 2Provide the college with a print management system for their student pay for print program.There will be an implementa±on of applica±ons for the purpose of tracking and billing studentsand guest for prin±ng services at the college. The print system will include several components;soFware interface for users, integra±on colleges ID Card Oracle database, Hotspot enterprise forweb and mobile prin±ng, ID card scanners, and hosted server infrastructure.

Attachments:

• 1492955927-Project Part 3.docx