Given the following information concerning a four-year planning horizon for a particular ERP system implementation: Licensing rights for all four (4) years - $400,000 Application server and database server purchase - $75,000 (four-year expected life) Computer purchases and upgrades - $28,000 (one-time charge) Maintenance contract for computers and servers -- $5,500 per year Training - $10,000 for the first year, $5000 for the remaining three years Consulting - Free for the first 6 months then $12,000 per year (prorated for partial years) New hire - Database/ERP system administrator at $200,000 annual salary (includes benefits) Suppose the total costs for ERP system implementation over the four year planning horizon is $1,440,000. It would be better to use SaaS to contract out ALL of the above expenses for a convenient monthly fee as long as that fee was less than: $48,000 $30,000 $12,000 $25,000 not enough information to determine

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.

Lavender Sdn Bhd is a company involved in the manufacture of perfume and its financial statements are as follows:

Lavender Sdn Bhd Statement of Financial Position as at 31 December 2019

Lavender Sdn Bhd Statement of Profit or Loss & Other Comprehensive Income

for the year-ended 31 December 2019

Additional information:

1. Property, Plant & Equipment with a carrying value of RM200,000 was sold for     RM180,000. This asset had originally cost RM250,000.
2. Depreciation of Property, Plant & Equipment during the year amounted to RM98,000.
3. Dividends paid during the year amounted to RM46,000 and are reported in the Statement of Changes in Equity.

1. Prepare a Statement of Cash Flow for the year ended 31 December 2019 using indirect method.

2. Briefly discuss the usefulness of Statements of Cash Flows in financial reporting.

Perform a horizontal analysis of the Balance Sheet.