*Question 1In an E-R diagram, there arebusiness rule(s) for every relationship.A) two B) three C) one D) none===============*Question 2Redundancy 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 causingdata. 3.With the traditional file-processing approach, users have little opportunity todata 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 arelationship.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 3Write 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.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]