*Question 1

*Question 1

  

In an E-R diagram, there are ________ business rule(s) for every relationship.A) two B) three C) one D) none

===============

*Question 2

 

Redundancy         Strong                Files        SecondTransitive        Normalization            Duplicate    TernaryPrimary Key        Application programs         Share        Instance1.In the beginning of computer-based data processing, __ were used instead of databases. 2.One disadvantage of file-processing systems is that applications are often developed independently causing __ data.  3.With the traditional file-processing approach, users have little opportunity to ___ data outside of their own applications. 4.__increases the risk of inconsistency. 5.__are used to create and maintain the database as well as provide information to users. 6.A single occurrence of an entity type is called an entity __. 7.A(n) __ entity type exists independently of other entity types. 8.A simultaneous relationship among the instances of three entity types is called a __ relationship.9.A(n) __ is an attribute that uniquely identifies each row in a relation. 10.The process of decomposing relations with anomalies to create smaller, well-structured relations is called __. ==========================

*Question 3

 

Write a create table statement for the table Customer which has the following attributes:

First Name, Last Name, Middle Initial, Shipping address, Billing address, daytime phone number, email address, Credit Card number, Name on card, expiration date, security code.  Use your best judgement for the data type and length, points will be deducted for bad choices.