Categories
Data Analytics

Brief background of the business including organization details (1), purpose (1), and organizational structure (1).

Cisco wiht refrances and own word not copy
in word for only 2 qustion (3-4)
Executive Summary (2.5 Marks).
Organizational Profile (3 Marks).
What does the assignment about (1), The name and field of the chosen company (0.5), and briefly explain the distinct features (1).
Brief background of the business including organization details (1), purpose (1), and organizational structure (1).

Categories
Data Analytics

A2 – submission section1 (get to know your data worksheet

A2 – SUBMISSION section1 (GET TO KNOW YOUR DATA WORKSHEET
The goal for this section is to understand your data and prepare for analysis. Use the Get to Know Your Data Worksheet to list what you know about your 2 data files.
Submit:
Completed Get to Know Your Data Worksheet (all variables in the 2 Excel data files should be included); this is basically a data dictionary
A2 – SUBMISSION section 2 (FINAL DATA FILE)
The goal for this section is to understand your data and prepare for analysis.
Submit:
The final merged Excel data file that resulted from the following process:Clean up each of the 2 initial Excel files according to instructions (see tutorials)
Import the 2 clean Excel files into Access
Merge the 2 tables by Facility ID
Export resulting table as a new, merged Excel file
Screenshot of the Access Dbase–the Relationships window with imported tables visible

Categories
Data Analytics

Select the task

Step 1: Update Project Libre with Resource InputsThe following steps should be followed when adding resource input in Project Libre.Set the resource input
Open Project Libre
Open your project .
Select Resources (Top tool bar)
Add your resources
Enter Resource Name
Enter Resource Type
Enter Rates
Enter Base Calendar
Enter the remaining resources using the same format as above.
Set your resource information
Select Resource
Select information
Enter Cost, Resource availability or additional information
Go back to task to add your resources
Go to task
Click on Gantt
Select the task
Select assign resourceAssign resources and unit percentages
Add remaining resources
Make sure to save your information
Step 2: Update Project Libre with Cost InputsThe following steps should be followed when setting up your Course Project with Project Libre.Set the cost input
Select a column
Insert a column by right clicking
Select cost
Click ok
Cost should be displayed from resource input
Insert new columnSelect total slack
Your total slack should be displayed
Insert new columnSelect Free slack
Your free slack should be displayed
Select FileClick Save Baseline
Select Baseline one
Select Entire project
Click ok
Go print preview
Adjust your scale
Or Fit to one page
Select Printer setting to PDF
Or save image in word and crop
Submit in the dropbox

Categories
Data Analytics

It should include the list of collections, and one sample document (in json format) for each collection to demonstrate the document structure.

Business case: A car-sharing company decided to use a MongoDB NoSQL database to store information about their primary operations, which include recording of all rides, real-time car locations, and users. A ride is defined as a combination of pick-up location, and drop-off locations (if the car has been returned), with the associated timestamps of those events.
Direction: In this assignment, you will propose a database structure for the given business case. It should include the list of collections, and one sample document (in JSON format) for each collection to demonstrate the document structure.
Put the list of the collections with the comments on their role along with the sample documents in JSON format in a single .txt file.
Pls take a look at the attached file for the example of the solution

Categories
Data Analytics

It should include the list of collections, and one sample document (in json format) for each collection to demonstrate the document structure.

Business case: A car-sharing company decided to use a MongoDB NoSQL database to store information about their primary operations, which include recording of all rides, real-time car locations, and users. A ride is defined as a combination of pick-up location, and drop-off locations (if the car has been returned), with the associated timestamps of those events.
Direction: In this assignment, you will propose a database structure for the given business case. It should include the list of collections, and one sample document (in JSON format) for each collection to demonstrate the document structure.
Put the list of the collections with the comments on their role along with the sample documents in JSON format in a single .txt file.
Pls take a look at the attached file for the example of the solution

Categories
Data Analytics

(you can discuss any points that you learned in this course (chapter 3) and link it to your selected organization.

Data Management (2 Marks).
Discuss the methods the organization uses to manage and process data (1), and then give one advantage and one disadvantage of these methods (1).
(You can discuss any points that you learned in this course (chapter 3) and link it to your selected organization.
Executive Summary (2.5 Marks).
What does the assignment about (1), The name and field of the chosen company (0.5), and briefly explain the distinct features (1).

Categories
Data Analytics

We send our decision letter on the manuscript and all peer reviews to our reviewers so that you know what other peer reviewers think about the manuscript.

Dear JMCQ reviewers:
Thank you very much for agreeing to review for us. I would like to introduce to you the mission of JMCQ, which is to advance the scholarship and develop a common core knowledge for the field of journalism and mass communication. Hence, originality and significant contribution to the field of mass communication are the most important criteria in evaluating manuscripts. Manuscripts with interests that are too narrow or simply a minor variation from past publications will not meet the standards for publication. JMCQ is the flagship journal of AEJMC, and the scope of the journal reflects the interests of all 18 divisions and 10 interest groups of AEJMC, providing scholars with a forum for ground-breaking research in those areas. We use a simple rating system for reviewer recommendations to editors: 1) accept, 2) revise and resubmit (minor revision or risky revision) and 3) reject. When you recommend “reject” or “revise and resubmit,” we ask if you would be willing to review a revised manuscript. Please be careful when you mark your choice of willingness to review again. If you indicate you are unwilling to review it again, usually we would consider this as a lack of support for revision even if you mark “revise and resubmit” and your leaning toward rejection. If you have other reasons for not willing to review it again, please let the editor/associate editor know because we need to find another reviewer to review it. If you marked “reject” but indicate willing to review again, we will see this as support for a major revision. “Revise and resubmit» should be used when the topic is significant, the paper/data has good potential and mistakes are fixable. “Reject’ is an appropriate recommendation when manuscripts include fatal mistakes in research design or conceptualization fallacies, or offer minimal contribution to the knowledge in the field. “Accept” is appropriate if the manuscript meets all standards and contains only a few minor errors that can be fixed without the need for re-reading by reviewers. We expect a substantive review from our reviewers. The review should address adequacy in literature review, theoretical conceptualization and methodological shortcomings, how the evidence supports the conclusion and contributions to the field. Usually, reviews are longer than half a page. We ask that you write constructive and courteous reviews to the authors because such reviews are more effective than harsh reviews in helping authors improve their manuscripts. Think of yourself as the recipient of the review when you write the review. JMCO has a tradition of providing courteous reviews, as shown by Brendon Watson and Dan Riffe’s (2014) study, and I hope to maintain and enhance this tradition with our wider pool of reviewers. You can give any brutally honest comments to the editor. We do not accept previously published manuscripts. If you have seen the manuscript before in other publications, please alert the editor/associate editors immediately so we that can investigate it. Offenders will be banned from submitting manuscripts to JMCQ for two years. JMCQ accepts studies that warrant the attention of mass communication scholars at large, and we value innovative and ground-breaking ideas. Of course it is hard to find a perfect manuscript, and we may tolerate some minor limitations. However, accepted manuscripts must meet the academic rigor that we all treasure in refereed scholarly journals. Please reserve your publication recommendation to the editor and do not include it in your review comments. We send our decision letter on the manuscript and all peer reviews to our reviewers so that you know what other peer reviewers think about the manuscript. Finally, to commend our ad hoc reviewers who have turned in two or more timely and thorough reviews within 30 days, or by some other mutually agreed-upon deadlines, I will personally write a commendation letter to you and your supervisor on your review work in recognition of your professional service to the field. Also, all reviewers who turned in their reviews at least one time in the previous year will be acknowledged in the editorial note of the first issue of the journal the following year. Thanks again for your willingness to serve as a reviewer for IMCQ. Your quality review is what makes refereed publications valuable and maintains the research rigor of the field.
Reference
Brendan R. Watson and Daniel Riffe, «Who Submits Work to JMCQ and Why? A Demographic Profile and Belief Summary,’ Journalism & Mass Communication Quarterly 91 (spring 2014):5-16

Categories
Data Analytics

Each sailboat is fully equipped at the time of lease.

A. Short Answers
1. Describe how to represent a multivalued attribute of an entity in deigning logical database table(s). Give an example other than one in this chapter. Show your table(s) with your explanation. Read textbook for the example.
Describe how to represent a M:N recursive relationship in designing database table(s). Give an example other than one in this chapter. Show your tables with explanation. Read textbook for the example
For a one-to-many relationship between tables of Director and Project , if the possible minimal cardinalities are shown in min cardinality and data integrity question sheets.docx , filling in your answers into the 3rd column of the sheets (2,3,4) to show your understanding about how to ensure the referential data integrity when a record is inserted, deleted or modified (key value). (Watch the video lecture on this question. The chapter 6 of text also shows the similar sheets to illustrate how the referential integrity is enforced),
4. What is a trigger ?(read Chapter 6) How can triggers be used to enforce data integrity? Show an example (note, you may use the answer you have for question A (3))
5. (Read beginning of Chapter 3 Functional Dependency)
5.1 What is the Functional Dependency (FD)? Give an example using the notation of FD X-> Y.
5.2) Assuming MSU database has a table such as Student (SSN , name, birthdate, GPA, school_name, dean_of_ the _school, dean_phone). Based on your understanding to the situation of the university, list all Functional Dependencies implied by this table. (using the notation X- > Y).
5.3) (Bonus 1 point) What the problems does above Student table have? What is your solution to the problem you identified.
B. Data Modeling and logical DB design
San Juan Sailboat Charters is an agency that leases sailboats to customers for a fee. San Juan does not own any sailboats; it leases boats on behalf of the owners who wish to earn income when they are not using their boats. San Juan charges boat owners fees for its service. San Juan specializes in boats that can be used for multi-day or weekly charters—the smallest sailboat in its inventory is 28 feet and the largest is 51 feet. For each board, San Juan keeps a contract with its owner which states the fee, duration of the contract, date of sign, etc.).
A customer who leases a boat needs to sign a leasing document that states information about the boat and customer, term of lease, itemize/total charges, destination, etc. Each sailboat is fully equipped at the time of lease. Most of the equipment are provided by the owners, but some are added by San Juan. The owner-provided equipment includes what is fixed on the boat, such as radios, compasses, depth indicators and other instrumentation, stoves, and refrigerators. Other owner-provided equipment is not installed as part of the boat. Such equipment includes sails; lines; anchors; dinghies; life preservers; and (in the cabin) dishes, silverware, bedding, and the like. San Juan provides consumable which can also supplies such as charts, navigation books, soap, dishtowels, toilet paper, and similar items.
An important part of San Juan’s responsibilities is keeping track of the equipment and supplies on the boat. Customers are responsible for all equipment during the period of their charter. San Juan likes to keep accurate records of its customers and their leases, not only for marketing but also for recording the trips that customers have taken. Some itineraries and weather conditions are more dangerous than others, so San Juan likes to know which customers have what experiences.
Most of San Juan’s business is bare-boat chartering, which means that no crew is provided. In some cases, however, customers request the services of crew members, so San Juan hires such personnel on a part-time basis.
Sailboats often need maintenance. San Juan is required by its contracts with the boat owners to keep accurate records of all maintenance activities and costs, including normal activities (for example, cleaning or engine-oil changes) and unscheduled repairs. A boat engine, for example, might fail while the boat is far away from San Juan’s facility. In this case, the customers radio the San Juan dispatcher, who determines the best facility to make the repair and sends the facility’s personnel to the disabled boat. To make these decisions, the dispatchers need information about repair facilities as well as past histories of repair quality and costs.
To promote its business, San Juan Sailboat Charters hosts boat-fishing tournaments a few times a year. Only customers who currently lease its boards are allowed to participate. The management of the company needs to keep track of tournament information such as title of tournament, date, reward type, the boats and customer involved, and the name of gold medalist, etc.
Another promotion activity San Juan Sailboat Charter does is to host the boat show a few time a year. During the show time, the company will display and demonstrate features of some of its boats. The company wants to keep track of information about this type of event, such as show’s location, show time period, the budget and the cost of the show, etc.
1. Create an ER model for above situation.
(Note: Suppose that San Juan has hired you to construct a database for them. To do this, you decide to create a data model. You know you will need to interview users and gather forms, reports, and other requirements. Before you do this, however, you decide to construct a trial data model. You are hoping that this model will help you determine specific questions that you will need to ask San Juan Sailboat personnel.)
2. Convert this E/R model into relational database design with the notation show in chapter 3 (For example: an employee table can be expressed as Employee(ssn, name, address, dept_no) )
please use the example below for the tables!

Categories
Data Analytics

The instructions are all in the doc i attached, there are underlined words in th

The instructions are all in the doc I attached, there are underlined words in the instructions which direct you to links, however, I have screenshotted the pages on the links and have attached them in the same doc. Please let me know if you are able to access the zip file.

Categories
Data Analytics

The instructions are all in the doc i attached, there are underlined words in th

The instructions are all in the doc I attached, there are underlined words in the instructions which direct you to links, however, I have screenshotted the pages on the links and have attached them in the same doc. Please let me know if you are able to access the zip file.