1a. Construct (draw) an E-R diagram representing the conceptual design of the database. Be sure to identify primary keys, relationship cardinalities, etc. State any assumptions you make.

1b. Convert your E-R diagram to the relational schema. Identify the primary keys of ever relation.

Consider the following application: An electronics vendor operates both a Web site and a chain of many physical stores. Examples include Best Buy and Circuit City. To find out more about this application, think about any experiences you may have had making purchases both online and in-store of a store like Best Buy (you can browse their website).

In our hypothetical company, it has been decided to redesign a major part of the database that underlies company operations. Unfortunately, the manager assigned to solicit database design proposals is not very computer literate and is unable to provide a very detailed specification at the technical level. Fortunately, you are able to do that.

Here are a few points to consider:

• There are different products, grouped into a variety of (possibly overlapping)

categories. Groupings can be done --> by type of product (cameras, phones, etc.), by manufacturer

(Sony, Apple, etc.), or by other means (for example, a Gateway PC might be packaged

with a Sony monitor and an HP printer and marketed as a package).

• Some customers have a contract with the company and bill their purchases to an account number. They are billed monthly. Other customers are infrequent customers and

pay with a credit or debit card. Card information may be stored for online customers,

but not for in-store customers.

• Online sales must be sent to a shipper. The company needs to store the tracking

number for the shipping company so it can respond to customer inquiries.

• Inventory must be accurate both in stores and in warehouses used to replenish stores

and to ship to online customers. When inventory is low, a reorder should be sent to

the manufacturer and listed in the database. When goods arrive, inventory should be

updated and reorders marked as having been filled.

• Sales data are important for corporate planning. Marketers may want to look at sales

data by time period, product, product grouping, season, region (for stores), etc.

This is my last assignment in a programming class I had to take as a prerequisite for a database course (seems odd). The instructor has been awful and I haven't learned much of anything. I use VBA at work and just can't follow C++. I'm stuck on this assignment and have no idea what I'm doing. I'm a database guy at work, I'm not a programmer. Please help.

In C++, a program that performs the following tasks:

1.      Design a Book class that has three data members:

string title

int   pages

double price

2.      Add constructors and methods (as well as method parameters when necessary):

Book()         // constructor(s)

getBookInfo()   // print title, pages, price

setPrice()     // change price

3.      In the main() function, create two Book objects:

b1("C++ Programming", 834, 93.53)

b2("Data Structures", 217, 64.42)

4.      Change the price of b2 to 55.46 using the setPrice() method.

5.     Using cout, Print out book information using the getBookInfo() method as shown below:

C++ Programming 834 93.53

Data Structures 217 55.46

IN C++, a program that performs the following tasks:

1.      Derive a TextBook class (child) from the Book class (parent).

2.      Add new data members:

string school

double discount

3.      Add new constructors and methods (as well as method parameters when necessary):

TextBook()           // constructor(s)

compTextBookPrice()  // price = price - discount

4.      Override inherited methods:

getBookInfo()        // print title, pages, price, school, discount

5.      In the main() function, create two Book objects and two TextBook objects:

b1("C++ Programming", 834, 93.53)

b2("Data Structures", 217, 64.42)

tb1("Database", 365, 74.41, "YSU", 20.00)

tb2("Networks", 522, 92.58, "YSU", 20.00)

6.      Using cout, print out book information as shown below:

C++ Programming  834  93.53

Data Structures  217  64.42

Database         365  54.41 YSU 20.00

Networks         522  72.58 YSU 20.00

What are some characteristics of a normal distribution? What does the empirical rule tell you about data spread around the mean? How can this information be used in quality control?

Can you compare apples and oranges, or maybe elephants and butterflies? In most cases the answer is no – unless you first standardize your measurements. What are a standard normal distribution and a standard z score?

The Acme Company manufactures widgets. The distribution of widget weights is bell-shaped. The widget weights have a mean of 40 ounces and a standard deviation of 9 ounces. Use the Empirical Rule, find a) 99.7% of the widget weights lie between and b) What percentage of the widget weights lie between 22 and 67 ounces? % c) What percentage of the widget weights lie below 49 ? %

Fluorine is so reactive that it forms compounds with materials inert to other treatments. When 0.622 g of platinum is heated in fluorine, 0.985 g of a dark red, volatile solid forms.

When 0.378 g of this red solid reacts with 0.161 g xenon gas, 0.539 g of an orange-yellow solid forms. What is the empirical formula of this product, the first to contain a noble gas?

Fluorine is so reactive that it forms compounds with materials inert to other treatments. When 0.622 g of platinum is heated in fluorine, 0.985 g of a dark red, volatile solid forms.

When 0.378 g of this red solid reacts with 0.161 g xenon gas, 0.539 g of an orange-yellow solid forms. What is the empirical formula of this product, the first to contain a noble gas?

The most common experimental technique to perform elemental analysis is combustion analysis, where a sample is burned in a large excess of oxygen and the combustion products are trapped in a variety of ways. A 99.99% pure, 0.4831 g sample containing only carbon, hydrogen, and nitrogen is subjected to combustion analysis, resulting in the formation of 1.353 g CO2, 0.2750 g H2O, and 0.1833 g NO. What is the empirical formula of the sample?

Combustion of a 0.9827-g sample of a compound containing only carbon, hydrogen, and oxygen produced 1.900 g of CO2 and 1.070 g of H2O. What is the empirical formula of the compound?   

Of the choices below, which would be the best for the lining of a tank intended for use in storage of hydrochloric acid? Explain your reasoning.                                                   (2)

A) copper

B) zinc

C) nickel

D) iron

E) tin

Answer the questions completely with complete calculations.

1. How many grams of a sample of NaNO3 should be dissolved in a 150.0 mL of water to give a 0.22 M solution?

2. A certain alcohol contains only three elements C, H & O. Combustion of 50.00 g sample of the alcohol produced 95.50 g of CO2 and 58.70 g of H2O. What is the empirical formula of the alcohol?

1) Define competitive advantage (CA).  

2) Distinguish CA carefully from sustainable CA (SCA).  

3) How much more common is CA than SCA and why?  

4) Return to Ghemawat’s reading in module 1: put my last question into an empirical context – how sustainable is CA generally?  

5) What implications does all this have for executive strategy?