Question

Frida has been given the task of creating a database to store all her company's records and sales records. She is going to produce a relational database. The customers records will have the fields Customer_id, Name, Contact_Phone, and card Number. The sales records will have the fields Invoice_number, Item_number, Item_description, Item_cost and Customer_ref.

Complete the diagram below to show how the tables will be combined.

Answer 1

A value that's used to identify a record from a linked table is called a ______. ... A database administrator is setting up a new table that will contain customer ... The fields include name, address, company, phone, email, and customer ID. ... Gina does not know how to write SQL commands and no forms have been created.

Step-by-step explanation: