The Trick 'o' Treat candy Production Table:
This is my product table where my fields are all based on the product. This table will mainly be for customers who may wish to buy any of the candy from the shop based on their preferences and choice.
Trick 'o' Treat Supplier Table:
This is the supplier table where all my fields are based on the supplier of the candy that is bought by Trick 'o' Treat Candy (both images are of the same table but it was too long to get the full thing on the screenshot). This table will be for the people working in the shop to keep track on the product coming into the shop and at what rate.
Relationship Between Databases:
This is my product table where my fields are all based on the product. This table will mainly be for customers who may wish to buy any of the candy from the shop based on their preferences and choice.
Trick 'o' Treat Supplier Table:
This is the supplier table where all my fields are based on the supplier of the candy that is bought by Trick 'o' Treat Candy (both images are of the same table but it was too long to get the full thing on the screenshot). This table will be for the people working in the shop to keep track on the product coming into the shop and at what rate.
Relationship Between Databases:
A relationship exists between two table when one of the tables has a foreign key that relates to or is the same as the primary key of the other table. This allows relational databases to divide and store their data in different tables while linking similar data items. I added a relationship between my two tables as for the supplier table the primary key was the supplier code and for the product table one of the foreign key was the supplier code which I then linked together to form a relationship.
Query 1 for the Product table:
This was my first query table and the query was the amount of stock more than 200 and less than 500. This query will allow buyers to narrow down their view for the delivery primarily based on the amount of candy in stock. This query will allow the buyer to see what types of brands can be bought at various prices with the amount of stock between 200 and 500.
Query 2 for the Product Table:
This query concerns the price of the candy. This query allows customers who are in need for candy that is between a certain price. This table consists of the candy that costs more than 1 pound and less than 5 pounds.
Query 1 for the Supplier Table:
This table is a query for the company (TT candy Production) based on the supplier candy. This query narrows down the amount of candy supplied to the shop based on a certain number. This query is about the amounts of candy supplied to the store that is more than 500 units.
Query 2 for the Supplier Table:
This table is based upon the time between the delivery dates for the candy that is being brought into the shop. These dates are based on the time consumed on the packaging of the product and the time taken to deliver from the outlets. This query consists of the candy that can be produced and delivered in less than or equal to 15 days.
Form for the Product Table:
This form is a form for the customers who want the candy to be delivered to them. They will have to fill in the form based on the candy they require and if possible they can add a picture of the candy to make the identification of the product easier.
Form for the Supplier Table:
This table is for the supplier of the candy to fill out when the product is delivered to the shop. This will allow TT Production to keep a track on the dates of when the candy is brought into the shop to prevent the selling of expired foods. The supplier will have to place an image of the candy that is being supplied to the shop to help with the identification of the candy.
Reports:
A report is the formatted results and organised form of the table in a database. Reports can help with decision making and an analysis of the companies performance and variety.
Report for the Product Table:
Report for the Supplier Table:
Query 2 for the Product Table:
This query concerns the price of the candy. This query allows customers who are in need for candy that is between a certain price. This table consists of the candy that costs more than 1 pound and less than 5 pounds.
Query 1 for the Supplier Table:
This table is a query for the company (TT candy Production) based on the supplier candy. This query narrows down the amount of candy supplied to the shop based on a certain number. This query is about the amounts of candy supplied to the store that is more than 500 units.
Query 2 for the Supplier Table:
This table is based upon the time between the delivery dates for the candy that is being brought into the shop. These dates are based on the time consumed on the packaging of the product and the time taken to deliver from the outlets. This query consists of the candy that can be produced and delivered in less than or equal to 15 days.
Form for the Product Table:
This form is a form for the customers who want the candy to be delivered to them. They will have to fill in the form based on the candy they require and if possible they can add a picture of the candy to make the identification of the product easier.
Form for the Supplier Table:
This table is for the supplier of the candy to fill out when the product is delivered to the shop. This will allow TT Production to keep a track on the dates of when the candy is brought into the shop to prevent the selling of expired foods. The supplier will have to place an image of the candy that is being supplied to the shop to help with the identification of the candy.
Reports:
A report is the formatted results and organised form of the table in a database. Reports can help with decision making and an analysis of the companies performance and variety.
Report for the Product Table:
Report for the Supplier Table:
No comments:
Post a Comment