Describe how shopping cart table is related to all the other tables in the database.
In Microsoft Access, the relationship between two tables is established by dragging the
__ from the __ table onto the __ in the __ table.
A unique JobID assigned to a particular job, would be designated as the job table __.
A recursive relationship between a product and its components is called __.
The basic ASP.NET component is a(n) __.
In Microsoft SQL Server Edit Diagram window, the link between Employee and Job
tables will show __ next to SSN in Employee table and __ next to SSN in Job table.
In a many-to-many relationship, a new __ table is created between the two tables.
Last name would be stored in _ _data type and zip code in __ data type.
Jerry, the owner of Exotic Flower’s Inc., built a small greenhouse to store several types
of exotic flowers that he purchases from wholesale suppliers around the world. Each
exotic flower Jerry buys and resells falls into one of several flower groups that differ
with respect to their storage needs, duration, time in bloom, price, etc. Each of the
orders placed by customers specifies the type of exotic flower, the supplier it came
from, the date of order, expected delivery date, flower condition on delivery, as well as
the quantity ordered. Customer’s data contain all the standard information needed to
collect payment and deliver the flowers.
For questions 86″88, please refer to the preceding paragraph.
Complete the design of the flower table in an Oracle database using appropriate SQL
script. Make sure to indicate which of the fields is the primary key.
In Microsoft Access, the statement used to retrieve client’s contacts with emails from
zip codes 03223 and 03264 only, would be __.
In Oracle, the statement used to retrieve client’s contact with emails that end in “net”,
from zip codes 03223 and 03264, would be __.
The most common way of designing a relational database is through the creation of a(n)
__.
Using the above Web screens, list all the fields in the customer table. Make sure to
correctly identify the primary key.
When inserting new client information into the JobClient table, without a particular job
assignment, you must specify __ field.
Modeling many-to-many recursive relationships requires a(n) __ table.