System of symbols | History homework help

Australian Aboriginal dreamtime painting at first looks like a non-objective work filled with beautiful patterns. These patterns are really symbols, and when used together form a story associated with spiritual journeys or mythological stories of creation. Each of the squiggles in Paddy Carroll Tjungurrayi’s Witchetty Grub Dreaming represents something, such as fire, waterhole, campsite, family, trail, etc. Look at what the symbols represent, and figure out what story Tjungurrayi (or others) is telling. Be concise about 200 words.

Paddy Carroll Tjungurrayi’s Witchetty Grub Dreaming

See more from the collection at:

National Museum of Australia

E-r diagram and sql queries project.

Project Description

 

Please note that this project must be unique in its design (E-R diagram) and implementation (SQL queries). You are not to copy or use any part of a database project that was previously submitted or appears on the Web, in a textbook, or otherwise made available via an external source. Contact your instructor if you have any questions regarding this requirement.

DELIVERABLES:

·         PART 1: (40 points)

o   Project Description (10 points)

o   Entity-relationship diagram (30 points)

·         PART 2: (60 points)

o   SQL Data Definition Language (DDL) and base tables with data (10 points)

o   SQL Data Manipulation Language (DML) queries (50 points)

·         PART 3: (50 points)

o   Display Entities/Tables (30 points)

o   Business Processes (15 points)

o   Optimization Strategy (5 points)

PART 1 (Due Week 3)

(1) Project Description. 10 points.

Provide an overview of your project identifying the major components as part of a database design. The format is an executive summary to be presented to management for review.

(2) Entity-relationship Diagram. 30 points.

Use the entity-relationship diagram (crows-foot) notation to design your database system. Be sure to: (1) identify entity types; (2) describe relationships between or among entity types; (3) identify modality and cardinality for each relationship; (4) identify associative entities and intersection data; and (5) label primary and foreign key attributes.

Your entity-relationship diagram will have a minimum of six (6) entity types of which at least two (2) are associative entities with intersection data. The ERD is accompanied by a brief explanation of each component in the entity-relationship model.

Note: You can use Microsoft Visio, Word, PowerPoint, or Access as a diagramming tool. Please obtain approval from your instructor regarding the use of other diagramming tools.

PART 2 (Due Week 5)

1.       SQL Data Definition Language. Three (3) points each for 1.1 and 1.2; and four (4) points for 1.3.

1.1.    Create a base table. Write the SQL to create a table based on one of your entities. Be sure to identify the primary key as part of your SQL syntax.

1.2.    Create a view. Write the SQL to create a view on the base table.

1.3.    Show the base tables with data. Show a base table along with six rows containing data for three entities in your entity-relationship diagram. (Display each table in the form of an MS Word table.)

2.       SQL Data Manipulation Language (insert, update, and delete). Five (5) points each for 2.1, 2.2, and 2.3.

2.1.    Insert a row. Write a SQL query to insert a row into one of your base tables.

2.2.    Update a row. Write a SQL query to change a data value in the inserted row.

2.3.    Delete a row. Write a SQL query to delete the row from your base table.

3.       SQL Data Manipulation Language for data retrieval. Five (5) points each for 3.1 through 3.7

For 3.1 through 3.7, write the SQL query AND show the output using the data in your base tables.

3.1.    Write a SQL query using a comparison operator (e.g., =, >, <).

3.2.    Write a SQL query using the “AND” or “OR” operator.

3.3.    Write a SQL query using the “BETWEEN” or “LIKE” operator.

3.4.    Write a SQL query using a built-in function.

3.5.    Write a SQL query using the “GROUP BY” clause.

3.6.    Write a SQL join query using two or more base tables.

3.7.    Write a SQL subquery using two or more base tables.

 

PART 3 (Due Week 7)

For the database concept you have chosen for Parts 1 and 2, provide the following:

·         Display your entities/tables in First Normal Form (10 points)

·         Display your entities/tables in Second Normal Form (10 points)

·         Display your entities/tables in Third Normal Form (10 points)

You may need to rework your relationships to achieve this. For each form, provide the tables and the defining associations. An example of the table overview can be seen on page 184 of the Fundamentals of Database Design textbook. An example of defining associations can be seen on page 185.

Next, define three (3) business processes that will access a particular table and attribute. For example, “a customer login process will require accessing the CUSTOMER table and retrieving the CustomerID and CustomerPassword attributes”. Provide detail on what the business process is and who is involved. For each business process, provide the SQL that would need to be run to access it in the first, second, and third normal forms you provided in the previous section.

(15 points)

Finally, choose an optimization strategy as defined in Chapter 8, whether physical or logical, and describe how it could potentially benefit any or all of your normal form examples. Provide a comparison between a use case with and without this strategy implemented.

(5 points)

W3 ba 225 assignment application problems 3

W3 BA 225 Assignment Application Problems 3

 

Page 120: Brief Exercises 3-7 and 3-9

BE3-7 Trek Company has the following production data for April: units transferred out 40,000, and ending work in process 5,000 units that are 100% complete for materials and 40% complete for conversion costs. If unit materials cost is $4 and unit conversion cost is $7, determine the costs to be assigned to the units transferred out and the units in ending work in process.

 

BE3-9 Data for Hollins Company are given in BE3-8. Production records indicate that 18,000 units were transferred out, and 2,000 units in ending work in process were 50% complete as to conversion costs and 100% complete as to materials. Prepare a cost reconciliation schedule.

 

Page 123: Exercise 3-7

E3-7 The Sanding Department of Quik Furniture Company has the following production and manufacturing cost data for March 2017, the first month of operation.

Production: 7,000 units finished and transferred out; 3,000 units started that are 100% complete as to materials and 20% complete as to conversion costs.

Manufacturing costs: Materials $33,000; labor $21,000; and overhead $36,000.

 

Instructions

Prepare a production cost report.

 

Pages 164-165: Brief Exercise 4-2, and 4-8

BE4-2 Finney Inc. has conducted an analysis of overhead costs related to one of its product lines using a traditional costing system (volume-based) and an activity-based costing system. Here are its results.

Traditional Costing ABC

Sales revenue $600,000$600,000

 

Overhead costs:

Product RX3 $ 34,000$ 50,000

 Product Y12 36,00020,000

$ 70,000$ 70,000

Explain how a difference in the overhead costs between the two systems may have occurred.

 

BE4-8 Rich Novelty Company identified the following activities in its production and support operations. Classify each of these activities as either value-added or non–value-added.

(a) Machine setup. (d) Moving work in process.

(b) Design engineering. (e) Inspecting and testing.

(c) Storing inventory. (f) Painting and packing.

 

Page 170: Exercise 4-8

E4-8 Wilmington, Inc. manufactures five models of kitchen appliances. The company is installing activity-based costing and has identified the following activities performed at its

Mesa plant.

 1. Designing new models.

 2. Purchasing raw materials and parts.

 3. Storing and managing inventory.

 4. Receiving and inspecting raw materials and parts.

 5. Interviewing and hiring new personnel.

 6. Machine forming sheet steel into appliance parts.

 7. Manually assembling parts into appliances.

 8. Training all employees of the company.

 9. Insuring all tangible fixed assets.

10. Supervising production.

 11. Maintaining and repairing machinery and equipment.

 12. Painting and packaging finished appliances.

 

Having analyzed its Mesa plant operations for purposes of installing activity-based costing, Wilmington, Inc. identified its activity cost centers. It now needs to identify relevant activity cost drivers in order to assign overhead costs to its products.

 

Instructions

Using the activities listed above, identify for each activity one or more cost drivers that might be used to assign overhead to Wilmington’s five products.

Activities

Cost driver(s)

1. Designing new models.

 

2. Purchasing raw materials and parts.

 

3. Storing and managing inventory.

 

4. Receiving and inspecting raw materials and parts.

 

5. Interviewing and hiring new personnel.

 

6. Machine forming sheet steel into appliance parts.

 

7. Manually assembling parts into appliances.

 

8. Training all employees of the company.

 

9. Insuring all tangible fixed assets.

 

10. Supervising production.

 

11. Maintaining and repairing machinery and equipment.

 

12. Painting and packaging finished appliances.

 

 

 

 

Quantitative analysis for business | Management homework help

HOMEWORKMARKET.COM – YOUR HOMEWORK ANSWERS

HomeworkMarket

profilemarcus3313
Home>Business & Finance homework help>Management homework help

See attachment

  • attachment

    trudy_green.docx

  • 5 years ago
  • 10
Report Issue
Answer(0)

Bids(0)

other Questions(10)

  • Ecological Services
  • OPS 571 Week 5 How TQM and ISO Could Be Used To Improve an Organization – Learning Team Reflection
  • due 4/30
  • HONESTYWORK
  • How useful is the past?
  • Business Government and Society
  • FSA ph 4 indiv projct
  • legal marketing
  • BSHS 373 Week 1 Assignment (Individual) – Magnolia Therapeutic Solutions Case Study
  • Microeconomics essay

  1. Applied Sciences
  2. Architecture and Design
  3. Biology
  4. Business & Finance
  5. Chemistry
  6. Computer Science
  7. Geography
  8. Geology
  9. Education
  10. Engineering
  11. English
  12. Environmental science
  13. Spanish
  14. Government
  15. History
  16. Human Resource Management
  17. Information Systems
  18. Law
  19. Literature
  20. Mathematics
  21. Nursing
  22. Physics
  23. Political Science
  24. Psychology
  25. Reading
  26. Science
  27. Social Science
  • Home
  • Blog
  • Archive
  • Essay
  • Reviews
  • Contact
Copyright © 2019 HomeworkMarket.com