Why is primary key and foreign key important in database design?
Essentially, primary and foreign keys are used as a way to constrain or link related data in a database. This ensures that data remains consistent and that the database contains no redundant data. For example, if you delete a table (or even a row in a table) that other tables rely on, the redundant data is removed.
What is the point of having a foreign key?
A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them.
What are the pros and cons of coupons?
The biggest con of using coupons is that they cost you money. Any discount you offer will mean less money in your pocket. The key is to calculate whether that discount will make a difference to your profit margin by introducing new customers to your store or bringing back old customers who may have gone elsewhere chasing other coupons.
What are the rules for choosing a primary key?
There are a couple of rules to follow when choosing a primary key for a table: all records in a primary key must be unique, a primary key cannot contain NULL values, a composite primary key cannot exceed 16 columns and a key length of 900 bytes, primary key values shouldn’t be changed
How are coupons used in the grocery industry?
This is a common strategy used by food stores. The coupon could introduce new customers to your store. The key to getting this strategy to work is to use the coupon as a way to begin long-term communications with the new customer through social media or email.
How are coupons good for a small business?
Coupons will drive business to your store. The key is to develop your coupon strategy so you know how that discount marketing strategy will either increase your long-term repeat business or increase your sales per customer. (For more tips on driving sales, see 7 Popular Marketing Techniques For Small Businesses.