newton-musyimi / coregroup Goto Github PK

Create tables
Define columns and datatypes

Create the template the system developers will use to create the system webpages.

Create the main CSS that will be used for the entire system

Change the to allow duplicate user_ids (not ideal) or restructure the entire db to use a different format of client and employee keys within the users table
i.e.

With respect to the errors:

1. Your user table should not be in any relationship with workorder. And in fact you have no FKs to support the relationship so remove it.
   • Drop the 'users' table
2. Your device table should not be in a relationship with the user table but rather the client table. Clients own devices.
   • Change relationship to reflect devices are owned by clients
3. Why do you want all users to have access to the logs? I would not want to give client users that level of access. Consider only allowing that relationship with the employee users only via the employees table.
   • Change relationship to reflect logs can only be accessed by the employees by adding a FK to the 'employees' table.
4. The relationship between workorder and quotes is odd. Why is it not 1:1? Why does a client or workorder need more than one quote to do the job?
   • Drop the 'quotes' table
   • Add a 'wo_id' column to the 'invoices' table - FK
5. Why does one invoice have a link to multiple possible payments and not a 1:1 link? If you are invoiced, you have paid, in full? If not, I would make that a rule, it will make things easier for you.
   • Drop the 'payments' table
6. None of your 1:1 relationships have a FK upon which to establish the relationship.
   • Change the display format to classic
7. You could rather go with a 1:M relationship where each repair job can use many parts but each part is related to one repair job and then just give each and every part you have a single ID and if you use it, you use it.
   • Drop the 'used_resources' table
   • Add a 'wo_id' column to the 'resources' table - FK
   • Add a 'cost' column to the 'resources' table
   • Add a 'price' column to the 'resources' table
   • Remove the 'quantity' column from the 'resources' table
8. Why not just order all the things you need in a single order and have a 1:1 relationship here? Where the workorder might have zero or one order and each order belongs to one and only one workorder.
   • Make the 'orders' and 'workorders' tables have a 1:1 relationship

• Create the login.php page in the home folder of the site.

• Make the page self-executing with input protection parameters

Created a home page with reference to Akoha and Sandra

Finished changing the PHP to reflect the database changes based on errors pointed out by the lecturer (ERD).
Pages changed:

• login.php
• signup.php
• PrivilegedUser.php
• Role.php