Hi I got assignment due, I've doe everything but I cant see to do this:
1. Alter the database so that the serial number can be recorded at the time of sale.
2. In order to improve the integrity of the data as it enters the database, you should implement the following business rule:
When a serial number is recorded in a sale, the quantity purchased must be one. In other words — the serial number must be blank or the quantity must be 1
This might seem easy but Im so stuck, been stuck for 2 hours already . The Data type of SerialNoRequired is Yes/No which cannot be changed in the assignment. Here is the ERD for this assignment: