sales-products. Create a relationship called This table should contain the following fields. Sale ID Product ID QTY sold Selling Price Data Field Data type properties Sale ID (set as the primary key) ? Product ID (set as the primary ? key) Qty Sold Number Use access default Selling Currency Format 2 decimal places For this table, you do not need to enter any data into this table To improve completeness, change the property for each of the field names from to this Required No Yes; prevents a record from being created if any values are missing. Step 11 There is a relationship between the sales table and three of the other tables and a relationship between the products table and one other table (I will not tell you which Make sure you enforce referential integrity. ones). Establish the relationships. Primary key/Foreign Key Establishing relationship Primary key/Foreign key must be like type data types Auto# cannot be FK because it can only be used one time
Create a relationship called sales-products. This table should contain the following fields. Sale ID Product ID QTY sold Selling Price Data Field Data type properties Sale ID (set as the primary key) ? Product ID (set as the primary key) ? Qty Sold Number Use access default Selling Currency Format 2 decimal places For this table, you do not need to enter any data into this table To improve completeness, change the Required property for each of the field names from No to Yes; this prevents a record from being created if any values are missing. Step 11 There is a relationship between the sales table and three of the other tables and a relationship between the products table and one other table (I will not tell you which ones). Establish the relationships. Make sure you enforce referential integrity. Primary key/Foreign Key Establishing relationship Primary key/Foreign key must be like type data types Auto# cannot be FK because it can only be used one time
Building%20a%20Database%20From%20Scratchrevised.docx