Possibly a challenging question to do. You were asked to create a table in a custom order database from the Excel spreadsheet that is displayed on your screen. The first two fields ID and customer ID are primary and foreign keys respectively. The other fields paid notes and date attributes in the order table and are functionally dependent on ID. The customer ID values reference the customer table that was created earlier in this section. The paid field must have a value of either true or false.
Make the notes field a short text data type. As mentioned on the screen, keep a copy of your answer and check our solution in the next section.