Recent content by PinInPastels

As the case study (It's for my ICT GCSE) told me to, I created three tables: tblStock Name, Type of item*, Country, Barcode, Weight, Price, Quantity Available (stock), Description, Picture. tblCustomer Customer ID, Title, Name, Surname, Date of Birth, Phone Number, Address, Credit Card Number...

I need to make a database that will be used for a hamper company. (It's a type of gift basket, basically.) There are standard, pre-made hampers, and there are "bespoke" hampers, which are custom-made. In the "Items" table, I need to have both standard hampers and individual items for the bespoke...

It's for my case study, and I'm stuck at this question. They want us to design the database for the company. The question is, "The database is used for stock control. When an order is entered, the database will indicate if any item has fallen below a set stock level. Design & make a system...