Database System Question

An automobile part trading company would like to store the following attributes for each
part in a database table:

PartNo: 10 bytes
Name: 30 bytes
UintMeasure: 5 bytes
UnitCost: 4 bytes
UnitPrice: 4 byes
QtyOnHand: 4 bytes
QtyOnOrder: 4bytes
PreferredSupplier: 30 bytes

Consider a disk with block size of 512 bytes and block pointer of 6 bytes long. Each record has a unique value of PartNo.
There are altogether 50,000 parts in the company.

Compute the following:

i) The number of file blocks required for storing the part records.

ii) The percentage of disk space saving achieved by implementing PartNo as primary index from implementing it as secondary index.

iii) The percentage of improvement on number of block accesses required for searching a product record based on PartNo’s value achieved by implementing PartNo as primary index from implementing it as secondary index.

1. You're processing data to be uploaded into a database. In what stage of data preprocessing would you deal with fields where there is no data, or data is missing? A.Data Consolidation B.Data Cleaning C. Data Transformation D. Data Reduction

2. You're company, Outdoor Excursions just acquired another local tour company, Excursions Inc. and you've been tasked with merging Excursions Inc's database with yours. During datapreprocessing, you encounter inconsistencies in the "marital status" column. Some values indicate "married", "single", or "widowed", others are represented by their first letters "m", "s", and "w", and others are left blank. What are some ways you could deal with that data? Select all that apply. Delete the column Recode the existing values Do Nothing Fill in missing values All of the above

3. Explain the term "model fitting". Why is it important in data mining and machine learning?

Explain MIS infrastructure and some ways it ensures continuous business operations. (Ch 5 - D/R, Scalability)

Discuss advantages and disadvantages of Cloud Computing, and why it is such an important development for MIS.

Identify the environmental impacts associated with MIS.

Describe a database, a database management system, and how they are different that spreadsheets.

Describe the important qualities of data (fig 6.4)

Define a data warehouse, and provide a few reasons they can make a manager more effective.

Explain the different network categories (LANs and WANs)

Explain topology and the different types found in networks.

Identify the different physical media types found in networks.

Differentiate the protocol between a circuit based telephone network and how the Internet works.

Describe the different wireless networks we use (think of your phones)

How is the focus of CRM systems different than SCM and ERP systems.

Why are enterprise systems so hard to implement

SNOWMOBILE CLUB - Database Development

Draw an Entity-Relationship Diagram which must include all entities and their attributes. Primary Keys underlined, Foreign Keys labeled, Weak entities double boxed.

You have been asked to develop a database to help the Wisconsin Snowmobile Association track their club members.

The following are the predefined business rules:

1) Snowmobile Clubs are tracked by Wisconsin county.

2) A club can be assigned to multiple counties.

3) Members can belong to one or more clubs.

4) Some clubs could have the same name.

5) New clubs can be started at any time.

6) The Wisconsin Snowmobile Association has an elected Executive Board consisting of a President, Vice President, Secretary, Treasurer and Executive Director, all of whom must be current members.

7) Each county must have a Director and a Representative.

8) Each club has a President, Vice-President, Secretary and Treasurer.

topic:- Fundamentals of Databases

* no hand writing

*the answer must be unique not copied "plagiarized "

______________

Introduction to Data Base

Purpose

The purpose of this assignment is to help you learn more about databases in real life.

Brief Introduction

Databases are important in businesses and organizations because they provide a highly efficient method for handling data. Some of the data that are easily managed include: employee records, student information, payroll, accounting, project management and inventory, etc.. A database management system stores, organizes and manages a large amount of information.

Action Items

• You are requested to submit one example of application where databases are used and discuss one relation from this database. You need to illustrate attributes and keys.
• All students have to participate at least twice in the discussions.

Submission Instructions

Post your ideas and responses on the discussion board. At least 1 original posting and 2 responses are mandatory.

Given the following six relations for an order-processing database application in a company:

CUSTOMER (Cust#, Cname, City)

ORDER (Order#, Odate, Cust#, Ord_Amt)

ORDER_ITEM (Order#, Item#, Qty)

ITEM (Item#, Unit_price)

SHIPMENT (Order#, Warehouse#, Ship_date)

WAREHOUSE (Warehouse#, City)

Here, Ord_Amt refers to total dollar amount of an order; Odate is the date the order was placed; Ship_date is the date an order (or part of an order) is shipped from the warehouse. Assume that an order can be shipped from several warehouses.
Hint: Remember, the relations (tables) describing entities carry the primary keys that are referenced by the relations (tables) describing relationships between entities.

1. Specify all the foreign keys for this schem State each foreign key using the following format “foreign key is the attribute ---------- of relation --------- that references relation
   -------------“.
2. State two queries involving more than one table that can be posed on this database indicating the tables to visit to answer the queries each time.

1) Determine the number of moles of Br2 in a sample consisting of:

8.02×1022 Br2 molecules

2.23×10²⁴ Br atoms

11.0 kg bromine

Determine the mass percent H in the hydrocarbon isopentane, CH3CH(CH3)CH2CH3?

Determine the empirical formula of:

benzo[a]pyrene, a suspected carcinogen found in cigarette smoke, consisting of 95.21% C and 4.79% H, by mass

hexachlorophene, used in germicidal soaps, which consists of 38.37% C, 1.49% H, 52.28% Cl, and 7.86% O by mass.

The element X forms the compound XOCl2containing 59.6% Cl.

What is element X?

Dimethylhydrazine is a carbon-hydrogen-nitrogen compound used in rocket fuels. When burned in an excess of oxygen, a 0.312 g sample yields 0.458 gCO2 and 0.374 g H2O.
The nitrogen content of a 0.486 g sample is converted to 0.226 g N2.

The organic solvent thiophene is a carbon–hydrogen–sulfur compound that yields CO2, H2O, and SO2 on complete combustion. When subjected to combustion analysis, a 1.3020−gsample of thiophene produces 2.7224 g CO2, 0.5575 g H2O, and 0.9915 g SO2.

What is the empirical formula of thiophene?

1.)In a mid-size company, the distribution of the number of phone calls answered each day by each of the 12 receptionists is bell-shaped and has a mean of 51 and a standard deviation of 4. Using the empirical rule (as presented in the book), what is the approximate percentage of daily phone calls numbering between 43 and 59?

2.)A company has a policy of retiring company cars; this policy looks at number of miles driven, purpose of trips, style of car and other features. The distribution of the number of months in service for the fleet of cars is bell-shaped and has a mean of 38 months and a standard deviation of 3 months. Using the empirical rule (as presented in the book), what is the approximate percentage of cars that remain in service between 41 and 47 months?

3.)he physical plant at the main campus of a large state university recieves daily requests to replace florecent lightbulbs. The distribution of the number of daily requests is bell-shaped and has a mean of 60 and a standard deviation of 8. Using the 68-95-99.7 rule, what is the approximate percentage of lightbulb replacement requests numbering between 52 and 60?

The Federal Election Commission maintains data showing the voting age population, the number of registered voters, and the turnout for special electons. The following table shows the voter turnout as a percentage of the voting age population in presidential elections from 1964-2000:

Year        % Vote             Year          % Vote             Year            % Vote

1964       61.92                1980        52.56                  1996          49.08

1968       60.84                1984        53.11                  2000          51.30

1972       55.21                1988        50.11

1976      53.55                 1992        55.09

6: What is the R² value?