Description
Unformatted Attachment Preview
SQL Database Lab
Page 1
Lab 1
This lab introduces some common SQL commands with examples.
Required Software and database
1. mysql
2. HeidiSql: GUI-based, Visual query tool for MySQL.
2. World database (to be created from a script).
The World Database
World is a sample database provided by MySQL. The data is from the 1990s, but it's still useful.
There are three tables in the database. It's not a great database design: the Continent attribute is
an enumeration of Strings, the Region is a String, and Language is a String.
The database is created using the SQL script provided (WorldDbCreation.sql).
Format of Exercises
Write the SQL command you use to get the data. If the result is requested, write that, too.
1 What Tables are in the Database?
Connect to the world database. What tables are in the database?
Answer:
2 What columns are in the City table?
There are two commands to show the columns in a table. Show both:
[The is a list of data types in the last page]
SQL Database Lab
Page 2
Table: City
Complete the table. For INT(n) just write integer, for FLOAT(n) just write float.
Field Name
Type
Can be Null?
Key?
Default
Type
Can be Null?
Key?
Default
char(2)
NO
Key?
Default
Table: Country
Field Name
Code2
Table: CountryLanguage
Field Name
CountryCode
Language
IsOfficial
Percentage
Type
Can be Null?
2.1 Are SQL commands case sensitive?
Answer: NO
2.2 In MySQL are names case sensitive?
Write the answer that you experimentally observe.
Database names? NO
Table names? NO
Field (column) names? NO
Note: The answer for Database and Table names depends on the operating system and
configuration of MySQL. It may be case sensitive or not. Write what you observe using our
server
SQL Database Lab
Page 3
3 Primary Key and Foreign Key
In this database, the primary key in one table is used as a foreign key in the other two tables.
What is this key’s name as a primary and as a foreign key? (HINT: This database uses one
name for the primary key and another for the foreign keys which is typical. If you examine the
columns in all three tables, you should have no problem figuring out which column links the
uerying Data
The SELECT command returns data from tables.
SELECT * FROM tablename
SELECT * FROM tablename LIMIT n
(only return n results)
SELECT field1, field2, field3 FROM tablename WHERE condition [ LIMIT n ]
SELECT fields FROM tablename WHERE condition ORDER BY field [ASC|DESC]
3.1 What are the first 3 Cities in Database?
Answer:
3.2 What are the 3 most populous countries in the World?
SELECT ... ORDER BY fieldname ASC (ascending)
SELECT ... ORDER BY fieldname DESC (descending - largest value first))
What are the 3 most populous countries in the world? Write their name and population.
sql> SELECT Name FROM country ORDER BY population DESC limit 3;
Answer:
What is the smallest country in the world?
Answer: (name and size)
3.3 Select with WHERE
SELECT field1, field2, field3 FROM table WHERE condition
Example:
SELECT * FROM Country WHERE Name='Japan'
What is the CountryCode for Thailand?
Answer:
Answer: (at least 3 cities)
3.4 SELECT using WHERE, ORDER, and LIMIT
SELECT fields FROM table
WHERE condition
ORDER BY field [ASC|DESC]
LIMIT n
What Country has the largest population in Europe? What is its population?
Answer:
SQL Database Lab
Page 4
What is the country code used for Puerto Rico in this database?
Answer:
PRI
What is(are) the language spoken in Puerto Rico as shown in this database?
Answer:
According to this database what is the capital of Puerto Rico? (HINT: You may want to use two
commands to get the answer to this question)Which City(s) in Puerto Rico have a population of
more than 200,000 but less than 400,000?
Answer:
3.5 UPDATE
Update the names of presidents of the East African Countries.
4 ENTITY RELATION DIAGRAM
Draw the ERD of the database (only one diagram like the one we drew under normalization).
Show the cardinality of the relationships.
SQL Database Lab
Page 5
SQL Data Types
SQL has many data types, and some are not recognized by all databases. For example, every SQL
datatype recognizes INTEGER and SMALLINT, but may not allow INT(11).
Data Type
INTEGER
BIGINT
SMALLINT
TINYINT
INT(n)
BOOLEAN
DATE
DATETIME
CHAR(m)
BLOB
BLOB(length)
ENUM('apple','grape'...)
Description
Data Type
Description
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Nice! Really impressed with the quality.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
CSIA 300 UMGC W7 PCI Mobile Payment Acceptance Discussion
This week your rotation assignment takes you to the Office of the Chief Financial Officer (CFO).An external audit of the c ...
CSIA 300 UMGC W7 PCI Mobile Payment Acceptance Discussion
This week your rotation assignment takes you to the Office of the Chief Financial Officer (CFO).An external audit of the company's financial operations has just been completed. Last week, an "early look" copy of the audit was sent to the CFO with a request for a formal written response for each of the findings. Some of the problem areas were known to the CFO's staff and they were already working on the required responses. But, there is one set of findings that came as a complete surprise -- Shadow IT -- the unauthorized / unapproved use of cashless payment technologies by certain locations and offices within the company. These technologies included:1. Micro payments using a payment card issued by guest services to hotel guests and via unattended vending machines to visitors. These payment cards are loaded with a cash value deposited to the card's account via a credit card charge. Guest services also credits some of these payment card accounts with "reward dollars" for guests who belong to the hotel's affinity program. The payment cards are used at service locations which do not have a cashier station. e.g. game arcade, self-service laundry or sales kiosk, etc. The payments are processed by a third party service provider which then uses an electronic funds transfer to pay the hotel its share of the income.2. Mobile Payments for services booked through the concierge desk with an authorized but independent provider (not a hotel employee). These services include: private lessons with a tennis or golf pro, childcare, tours and tour guides, interpreters, etc. These payments are made by cell phone either as a mobile payment using a contactless payment system such as Apple Pay or by swiping a credit card through a magnetic stripe reader connected to the provider's cell phone. The payment accounts which receive the guests' payments are connected to the hotel's merchant card accounts. The hotel pays the providers monthly via electronic deposit and issues an IRS Form 1099 to record the income.The CFO must make a presentation to the IT Governance board about these payment systems as a first step towards either getting approval for continued use or issuing a "cease and desist" directive to force the rogue offices and locations to stop using the unapproved payment systems. The presentation must include information about known or suspected compliance issues for PCI-DSS. The IT Governance board has previously asked project sponsors for information about potential privacy and security issues.Due to the size and complexity of the problem, the CFO has split the available staff into two teams. Team #1 will focus on the micro payment cards. Team #2 will focus on the mobile payment systems. You have been asked to join one of these two teams and assist with their research. (Note: you *must* pick one and only one of the two technologies to focus on for your discussion paper this week.)Your team leader has asked you to read the provided background information (see the Week 7 readings) and then put together a 2 page summary of the important points from your readings. You have also been asked to help identify and describe / explain 5 or more privacy and security issues that could arise in conjunction with the use of the technology being studied by your team. Remember to keep your focus on the financial aspects of the technology implementation since you are contributing to the CFO's effort. (Financial aspects include how payments are made, what types of information are exchanged and with whom, how that information is protected, etc.)Provide in-text citations and a reference list at the end of your summary paper (APA format recommended).Use the following links for the references:Corporate Financial Operations1. https://www.toptal.com/finance/interim-cfos/role-of-the-cfo2. https://www.myaccountingcourse.com/accounting-dictionary/income3. https://www.inc.com/young-entrepreneur-council/the-importance-of-placing-cash-flow-first.html4. https://corporatefinanceinstitute.com/resources/knowledge/accounting/credit-sales/5. https://ecommerceguide.com/guides/what-is-ecommerce/6. https://www.accountingedu.org/accounting-information-systems/7. https://www.oracle.com/applications/erp/what-is-financial-management-system/8. https://digitalguardian.com/blog/what-sox-complianceCredit Cards & PCI DSS9. https://www.usa.gov/credit-cards10. https://www.creditcards.com/credit-card-news/emv-faq-chip-cards-answers-1264/11. https://www.pcicomplianceguide.org/2019-pci-compliance-annual-plan/12. https://www.americanbar.org/groups/litigation/committees/minority-trial-lawyer/practice/2019/the-payment-card-industry-data-security-standard/Mobile Payments13. https://squareup.com/guides/mobile-payments14. Attached pdf file(Customer acceptance)15. Attached pdf file(Mobile payments)16. https://www.creditcards.com/credit-card-news/mobile-payment-security-risks/17. https://squareup.com/us/en/point-of-sale18. https://squareup.com/us/en/payments/payment-platform19. https://www.cardfellow.com/blog/pci-compliance-for-mobile-devices/20. Attached pdf file (pci mobile payments)RFID Wristbands & Nearfield Communications Devices21. https://www.gettoken.com/beginners-guide-rfid-technology-events/22. https://www.idcband.com/en-us/blog-us/8-benefits-of-using-rfid-wristbands-resorts-attractions/23. https://tappit.com/rfid-wristband-safety/24. https://www.techradar.com/news/world-of-tech/rfid-wristbands-vs-nfc-smartphones-what-s-winning-the-contactless-battle-116713525. https://www.universalrfid.com/rfid-trade-shows26. https://blog.printsome.com/rfid-wristbands-good-bad/
4 pages
Defining Information Systems
Explain the five key lessons and note the importance of each key lesson Throughout the study of Information Systems I have ...
Defining Information Systems
Explain the five key lessons and note the importance of each key lesson Throughout the study of Information Systems I have been introduced to the ...
DeVry University Modern Robotic Applications in the Pharmaceutical Sector Essay
Using Project Management and Systems Development Methodologies
Innovation in the Pharmaceutical Industry
Name
Institutiona ...
DeVry University Modern Robotic Applications in the Pharmaceutical Sector Essay
Using Project Management and Systems Development Methodologies
Innovation in the Pharmaceutical Industry
Name
Institutional Affiliation
Description
The last years have seen increased challenges in the drug supply chain following global pandemics and natural disasters that have facilitated the necessity for having modernized pharmaceutical manufacturing (Bhatnagar, 2019). The current coronavirus pandemic has proven how vulnerable the pharmaceutical supply chain can get if things remained the same. The inadequacy in redundancy in manufacturing avenues, the lack of flow in volume, and complications in the supply chain lead to significant difficulties in the drug supply chain (Bhatnagar, 2019). Hence, to continually ensure drug quality and supply, it has become paramount for the pharmaceutical industry to embrace advanced technology to reinforce its activities. One of the technology pharmacies could embrace the application of intelligent robotics. The pharmaceutical supply chain has an aspect for repetitive movements cumbersome, and others involve preparing test tubes for research and delivery of medication orders. Some of the medications require proper mixing at the manufacturing stage and hence the implementation of intelligent techniques such as robotic arms. The integration of mechanical mechanics will assist manufacturers in completing simple tasks. Automated integration facilitates productivity by working constantly and allows humans to concentrate on more complex and high-value work.
Integration components
The modern robotic application will allow the pharmaceutical industry with aspects such as cost-effective and easy application. Automation is one component of contemporary robotics. The component allows for efficiency and will assist pharmaceutical manufacturers in reducing costs, reflecting on the price of drug commodities (Bhatnagar, 2019). In addition, automation promotes affordability and quality. Hence, promoting health has become a primary approach towards the reinforcement of evidence-based practices.
Secondly, production is the other component emerging from modern robotics. Production begins from raw materials to finished products, packaging, storage, and distribution. Modern robotics will assist in fostering these processes as the robotic arms will provide significant assistance in ensuring they attend to those processes not prioritized by the human hand (Baltzan, 2020). It will also reduce cost and time, which are significant elements in on-time drug supply. Under production, specific requirements also get reinforced as the technology works to enhance usability, safety, reliability, amongst others. In previous years many errors emerged as a result of not following safety measures. The same has costed lives and resulted in a disability that could have avoided if the correct standards on drug administration emerged (Bhatnagar, 2019). Eliminating these challenges starts from production as manufacturers could go wrong with their mixing of drugs. Thus, the automated robotic application appears as a means of addressing these errors. Hence enhancing safety in drug administration is essential in promoting health.
Product or solutions exemplified
Time has continually increased customer expectations when it comes to pharmaceutical drugs. Hence, to keep up with the market quality of products and continuous delivery, modern robotics helps to promote these significant aspects. It has become a means of producing high-quality products with increased flexibility within a short period. Further, automation will encourage transportation material and in a highly efficient way. In pharmaceutical industries, production emerges as dynamic and agile (Baltzan, 2020). Transportation of materials and finished goods takes place in a semi-finished way from warehouse to production lines. The workers handling these transportations spend a lot of time as they have to break from the actual duties to attend to the same which contributes to inefficiency as machines are left unattended during this break. It is also a deployable option. Features such as software and cameras enable a robot to take note of its surroundings and identify the most efficient route to take, which promotes safety by keeping away from obstacles and people. Hence, the robot works safely around humans.
End-User
Besides, modern robotics will assist in eliminating counterfeit drugs, which is an essential aspect amongst end-users. Supply chain design decisions significantly rely on the product that reaches a patient (Bhatnagar, 2019). With an increased need to have a safe and effective therapeutic framework for end-users, pharmaceutical distribution chain costs have increased significantly. Product nature also affects the distribution and storage elements which emerge as challenges. The pharmaceutical industry has a global component, and the supply chain comprises a framework of manufacturers that are both secondary and primary. There is large-scale production of off-the-shelf prescriptions and vaccines with single manufactured portions delivered to various patients with non-specific doses (Bhatnagar, 2019). Robotic modernization promotes the distribution of personalized medication for those patients with specific health conditions as some approaches, such as allogenic, pose challenges such as various donor-patient matching challenges (Bhatnagar, 2019). The pharmaceutical industry comprises R&D multinationals, local companies, amongst other manufacturing organizations. The aspect will also allow manufacturers to maintain product stability that gets recommended throughout the whole supply chain. Temperature is one of the things that compromise bio-products. Automated supply strategies thus enhance transportation of these products and, if not protected, could result in damages.
In conclusion, the last years have seen an evolvement in products involving advanced manufacturing steps. The use of robotics will offer an off-the-shelf solution. Custom-built production is another provision of modern robotics. Moreover, modern robotics promote standard resolution that proves rewarding to suppliers and significantly attractive to the applying industry in terms of execution (Bhatnagar, 2019). Hence, modern robotics will promote the supply chain within the pharmaceutical industry, which is a significant way of promoting healthcare outcomes and eliminating or reducing errors that have continued to emerge within the health sector.
References
Baltzan, P. (2020). Business-driven technology. McGraw-Hill/Irwin.
Bhatnagar, N. (2019, March). Role of robotic process automation in pharmaceutical industries. In International Conference on Advanced Machine Learning Technologies and Applications (pp. 497-504). Springer, Cham.
Creating a website
NGO Website ProjectObjectivesUpon completing this assignment, you will be able to:design and build a multi-page HTML websi ...
Creating a website
NGO Website ProjectObjectivesUpon completing this assignment, you will be able to:design and build a multi-page HTML website with a consistent look and style;describe how hyperlinked documents use URLs to form connections between them;Create internal and external hyperlinks;use HTML tags to create semantic structure in a web document;integrate images and other multimedia elements into a web document;use lists and tables to organize and layout the elements of a web document;create a blog or micro-blog using a free hosted service.OverviewIn this project you will design and implement a simple, small web site and blog for a fictitious Non-Governmental Organization (NGO). The focus will be on creating a well-structured, consistent design, with good connections to related sites on the WWW.You will work in a small team of 2 - 3 students to complete this project and must learn to participate and share in all aspects of the project, from design and research, to implementation and testing.The ScenarioYou have been asked to design a website and blog for an NGO (e.g., an environmental, advocacy, health-watch, community group, or other non-profit organization) to help them promote their work on a particular issue. The goal of this web site is to inform people about the issue and to attract new supporters.People visiting the site should get a balanced, well informed understanding of the issue, in addition to some information about the organization, its mission, and the actions it is taking. Since the NGO hopes to attract new members (and thus more funding!) with their on-line presence, you need to make the web site attractive to your potential members. It should be informative and easy to browse, allowing the user quick access to the information and features he or she needs, and providing links to related web sites.Important Note: do not try to cram a lot of information about your topic onto your site. Rather concentrate on creating a nice design with basic information and links to web sites where related and more detailed information can be found. Your focus should be on layout and design, rather than packing in a ton of content!Getting Started TasksSelect a team.You should work on this project in a team of 2 - 3 students. Be sure to choose a partner with similar interests and a compatible schedule!Select an environmental or social issue.Choose an issue that you feel is interesting, overly exaggerated, or urgently pressing. Use your imagination, and choose something that interests you. Be creative - make something up - use humour if you like. Some examples might include air pollution, homelessness, oil spills, drug addiction, climate change, nuclear waste, endangered species, alternative energy, poverty, sustainability, etc. The issue may be very general or quite specific. For example, one might choose "endangered species" in general, or focus specifically on "Mountain Gorillas"; or "animal cruelty" vs. "cruelty to slugs".Select a name and a mission for your organization.Make-up an imaginary organization whose objective is to either to dismiss or raise awareness about this issue. Note that the organization may advocate any viewpoint on the issue, from "de-bunking a myth" to conservation and activism -- it is up to you to decide on their "mission statement".Research your issue.Research the issue with an aim of trying to understand the different viewpoints that exist. For example, what does this issue mean for individuals living in North America as opposed to Africa? What are the alternatives? What are the costs of dealing with it? What are the benefits of leaving the status quo? How will our actions affect future generations? etc.Be sure to "bookmark" useful sites or write down their URL's so you can return to them later.Develop a basic outline that summarizes your research findings. This will help you to organize your thinking and select the most important pieces of information to use for your website.Designing the websiteLike you would in any real life web project, start by designing the overall structure and look of your website. No knowledge of HTML is required as this stage is done on paper.Decide on the overall site "architecture"How are you going to organize your site? What pages will it have? How will they be linked together? This is the initial phase of your web site design. Draw a diagram - a "site map" - of your overall design to show the main pages and the relationships and links between them.Design the look and feel for pages on your site.It is important that all the pages on your site have a consistent "look and feel". Create a design theme for pages on your site -- will they have a banner or a sidebar or a background image? what will the colour scheme be? will they have a navigation menu? will there be a logo on each page, and if so, where? will there be a footer? Have a look around the web for sites that you like and find attractive -- what are the design elements being used?Draw a sketch of a typical page to show how it will be laid out (e.g., show the locations of titles, graphics, text areas, navigation bars, etc.). While you are encouraged to be creative when designing your website, the web is primarily a communication tool and you must make sure that your site is usable and friendly. The guidelines established at http://usability.gov/guidelines/index.html will help, and the HTML hell page will identify some things you should really avoid!Features of your siteYour site must include the following pages :An "introduction" page to describing the general purpose of the site (your organization's "mission"), in a file named index.htmlA blog that will serve to keep your readers up to date with the latest news.Details on the various activities/services/topics etc. (will vary based on site, but keep it simple!)A "contact" page with your contact information, including the e-mail address of the person managing the site and the date that the site was last revisedTo attract potential members, your site could implement a feature, such as:
a current top 10 list of corporate polluters,tips for energy efficient living,a simple game,an annotated photo-galleryUse your imagination to choose something that will appeal to your potential members.You must use appropriate images, graphics, and media to enhance the look of your site. Since these sites will be private, you do not need to worry about obtaining copyrights for any images you download from the WWW. However, at least one of the images used on your site must be an original - a photo taken by someone on your team.You must provide links to at least 5 other relevant sites, such as home pages of other NGO's and related government, university research sites, blogs, etc.Select a Blog PlatformDo some research on the various free blog hosting, or micro-blogging services available. Decide on one to use for this project - make some notes about the criteria you used and the reasons why you choose it.Create a blog on that service for your organization. During implementation, you will customize this blog and link it to your website!mplementing Your NGO Website and BlogNow that we have completed the website design on paper, we are ready to code! Your website must conform to these technical requirements.The homepage for your website must be in a file named "index.html ".The website must incorporate all of the the following HTML elements:Different paragraph / heading styles (don't go crazy, refer to the guidelines)Links: both internal or externalImages (IMG) - at least one original image (e.g., taken with your phone or camera)Your website must be free of HTML errors. You can tidy up your webpage using HTML Tidy.Your website MUST validate correctly - be sure to pass each page through the HTML validator:https://validator.w3.org/nu/Finally, of course, your site must use correct Canadian English spelling and grammar, to a standard appropriate for 100 level English at Capilano University.Implement your blogCreate a blog or micro-blog on the hosting service on your choice, make sure that the theme is similar in style to your website (select a template with similar colours and/or layout, possibly customize the theme with your logo or other identifying images).As your first blog post, provide a 1-2 paragraph explanation on why you chose that particular blogging service - what criteria did you use, why this service over the others?Create at least one additional blog entry per person in your group.This blog post should provide feedback for team members and your instructor about how the project went for you.Add a link from your website to the blog (ideally as a menu item)Add a link from your blog back to your websiteEvaluation CriteriaTo complete this assignment, you must upload your complete website to the WWW for grading and public viewing. Submit the URL of your website on Moodle.The work must be of a reasonable standard to be acceptable for grading.Acceptable work will be evaluated on the following characteristics:CriteriaEvaluationLayout, Design & Organisation :- multi-page site with suitable layout– consistency, structure, ease of browsing- aesthetics (appropriate use of colour, fonts, formatting, etc).30Requirements- site has all required components- site uses required HTML tags- site validates correctly10Media– inclusion of appropriate media- at least one original photo10Content:- originality & quality of information (not quantity!)- links are relevant and function correctly- administrative & contact info, all team members clearly identified10Blog :- successful setup of the blog site- consistent style and theme- linked with website- required blog entries30Technical Requirements :- homepage is named index.html- spelling and grammar10Total100
6 pages
Equifax Data Breach.edited 1
Equifax company serves as one of the most significant credit reporting firms in the world. They track and analyze the hist ...
Equifax Data Breach.edited 1
Equifax company serves as one of the most significant credit reporting firms in the world. They track and analyze the history of all their customers ...
Similar Content
Texas Womens University Running Case Computer Science Worksheet
The semester project S1 consists of the Running Case tasks from Chapter 4 & Chapter 5.1. Complete Task 4 as described in t...
Clayton State University Cloud Computing Risk Management Assessment Report
Reference:https://www.isaca.org/resources/isaca-journal/past...Describe and discuss each of the following important elemen...
University of the Cumberlands Security Architecture Discussion
Since it is so dangerous, why would designers install software into the kernel at all (or make use of
kernel software)? If...
2-3 pages IT report
Description: Case Point Paper. You are to analyze your assigned case study to prepare a two- to three- page, dou...
Discussion
Discussion...................................................................................................................
ITEC 6040 Walden University Week 5 System Modelling Question
Process modeling is a different view of the same system that you analyzed from a functional perspective. This model shows ...
Domain Controllers
Determination of the number of domain controllers in an environment is very useful especially in the scenario where the us...
Data Mining
Data mining is an approach of organizing tendencies via huge quantities of information and founding relations by use of in...
Cloud Security Ed.
• Cloud security ensures the safety of data and information stored on the internet through cloud computing platforms fro...
Related Tags
Book Guides
The 5 Love Languages
by Gary Chapman
Fences
by August Wilson
Ezperanza Rising
by Pam Muñoz Ryan
The Life-Changing Magic of Tidying Up
by Marie Kondo
Epic of Gilgamesh
by Unknown
Where'd You Go Bernadette
by Maria Semple
The Knife of Never Letting Go
by Patrick Ness
Crime and Punishment
by Fyodor Dostoyevsky
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
CSIA 300 UMGC W7 PCI Mobile Payment Acceptance Discussion
This week your rotation assignment takes you to the Office of the Chief Financial Officer (CFO).An external audit of the c ...
CSIA 300 UMGC W7 PCI Mobile Payment Acceptance Discussion
This week your rotation assignment takes you to the Office of the Chief Financial Officer (CFO).An external audit of the company's financial operations has just been completed. Last week, an "early look" copy of the audit was sent to the CFO with a request for a formal written response for each of the findings. Some of the problem areas were known to the CFO's staff and they were already working on the required responses. But, there is one set of findings that came as a complete surprise -- Shadow IT -- the unauthorized / unapproved use of cashless payment technologies by certain locations and offices within the company. These technologies included:1. Micro payments using a payment card issued by guest services to hotel guests and via unattended vending machines to visitors. These payment cards are loaded with a cash value deposited to the card's account via a credit card charge. Guest services also credits some of these payment card accounts with "reward dollars" for guests who belong to the hotel's affinity program. The payment cards are used at service locations which do not have a cashier station. e.g. game arcade, self-service laundry or sales kiosk, etc. The payments are processed by a third party service provider which then uses an electronic funds transfer to pay the hotel its share of the income.2. Mobile Payments for services booked through the concierge desk with an authorized but independent provider (not a hotel employee). These services include: private lessons with a tennis or golf pro, childcare, tours and tour guides, interpreters, etc. These payments are made by cell phone either as a mobile payment using a contactless payment system such as Apple Pay or by swiping a credit card through a magnetic stripe reader connected to the provider's cell phone. The payment accounts which receive the guests' payments are connected to the hotel's merchant card accounts. The hotel pays the providers monthly via electronic deposit and issues an IRS Form 1099 to record the income.The CFO must make a presentation to the IT Governance board about these payment systems as a first step towards either getting approval for continued use or issuing a "cease and desist" directive to force the rogue offices and locations to stop using the unapproved payment systems. The presentation must include information about known or suspected compliance issues for PCI-DSS. The IT Governance board has previously asked project sponsors for information about potential privacy and security issues.Due to the size and complexity of the problem, the CFO has split the available staff into two teams. Team #1 will focus on the micro payment cards. Team #2 will focus on the mobile payment systems. You have been asked to join one of these two teams and assist with their research. (Note: you *must* pick one and only one of the two technologies to focus on for your discussion paper this week.)Your team leader has asked you to read the provided background information (see the Week 7 readings) and then put together a 2 page summary of the important points from your readings. You have also been asked to help identify and describe / explain 5 or more privacy and security issues that could arise in conjunction with the use of the technology being studied by your team. Remember to keep your focus on the financial aspects of the technology implementation since you are contributing to the CFO's effort. (Financial aspects include how payments are made, what types of information are exchanged and with whom, how that information is protected, etc.)Provide in-text citations and a reference list at the end of your summary paper (APA format recommended).Use the following links for the references:Corporate Financial Operations1. https://www.toptal.com/finance/interim-cfos/role-of-the-cfo2. https://www.myaccountingcourse.com/accounting-dictionary/income3. https://www.inc.com/young-entrepreneur-council/the-importance-of-placing-cash-flow-first.html4. https://corporatefinanceinstitute.com/resources/knowledge/accounting/credit-sales/5. https://ecommerceguide.com/guides/what-is-ecommerce/6. https://www.accountingedu.org/accounting-information-systems/7. https://www.oracle.com/applications/erp/what-is-financial-management-system/8. https://digitalguardian.com/blog/what-sox-complianceCredit Cards & PCI DSS9. https://www.usa.gov/credit-cards10. https://www.creditcards.com/credit-card-news/emv-faq-chip-cards-answers-1264/11. https://www.pcicomplianceguide.org/2019-pci-compliance-annual-plan/12. https://www.americanbar.org/groups/litigation/committees/minority-trial-lawyer/practice/2019/the-payment-card-industry-data-security-standard/Mobile Payments13. https://squareup.com/guides/mobile-payments14. Attached pdf file(Customer acceptance)15. Attached pdf file(Mobile payments)16. https://www.creditcards.com/credit-card-news/mobile-payment-security-risks/17. https://squareup.com/us/en/point-of-sale18. https://squareup.com/us/en/payments/payment-platform19. https://www.cardfellow.com/blog/pci-compliance-for-mobile-devices/20. Attached pdf file (pci mobile payments)RFID Wristbands & Nearfield Communications Devices21. https://www.gettoken.com/beginners-guide-rfid-technology-events/22. https://www.idcband.com/en-us/blog-us/8-benefits-of-using-rfid-wristbands-resorts-attractions/23. https://tappit.com/rfid-wristband-safety/24. https://www.techradar.com/news/world-of-tech/rfid-wristbands-vs-nfc-smartphones-what-s-winning-the-contactless-battle-116713525. https://www.universalrfid.com/rfid-trade-shows26. https://blog.printsome.com/rfid-wristbands-good-bad/
4 pages
Defining Information Systems
Explain the five key lessons and note the importance of each key lesson Throughout the study of Information Systems I have ...
Defining Information Systems
Explain the five key lessons and note the importance of each key lesson Throughout the study of Information Systems I have been introduced to the ...
DeVry University Modern Robotic Applications in the Pharmaceutical Sector Essay
Using Project Management and Systems Development Methodologies
Innovation in the Pharmaceutical Industry
Name
Institutiona ...
DeVry University Modern Robotic Applications in the Pharmaceutical Sector Essay
Using Project Management and Systems Development Methodologies
Innovation in the Pharmaceutical Industry
Name
Institutional Affiliation
Description
The last years have seen increased challenges in the drug supply chain following global pandemics and natural disasters that have facilitated the necessity for having modernized pharmaceutical manufacturing (Bhatnagar, 2019). The current coronavirus pandemic has proven how vulnerable the pharmaceutical supply chain can get if things remained the same. The inadequacy in redundancy in manufacturing avenues, the lack of flow in volume, and complications in the supply chain lead to significant difficulties in the drug supply chain (Bhatnagar, 2019). Hence, to continually ensure drug quality and supply, it has become paramount for the pharmaceutical industry to embrace advanced technology to reinforce its activities. One of the technology pharmacies could embrace the application of intelligent robotics. The pharmaceutical supply chain has an aspect for repetitive movements cumbersome, and others involve preparing test tubes for research and delivery of medication orders. Some of the medications require proper mixing at the manufacturing stage and hence the implementation of intelligent techniques such as robotic arms. The integration of mechanical mechanics will assist manufacturers in completing simple tasks. Automated integration facilitates productivity by working constantly and allows humans to concentrate on more complex and high-value work.
Integration components
The modern robotic application will allow the pharmaceutical industry with aspects such as cost-effective and easy application. Automation is one component of contemporary robotics. The component allows for efficiency and will assist pharmaceutical manufacturers in reducing costs, reflecting on the price of drug commodities (Bhatnagar, 2019). In addition, automation promotes affordability and quality. Hence, promoting health has become a primary approach towards the reinforcement of evidence-based practices.
Secondly, production is the other component emerging from modern robotics. Production begins from raw materials to finished products, packaging, storage, and distribution. Modern robotics will assist in fostering these processes as the robotic arms will provide significant assistance in ensuring they attend to those processes not prioritized by the human hand (Baltzan, 2020). It will also reduce cost and time, which are significant elements in on-time drug supply. Under production, specific requirements also get reinforced as the technology works to enhance usability, safety, reliability, amongst others. In previous years many errors emerged as a result of not following safety measures. The same has costed lives and resulted in a disability that could have avoided if the correct standards on drug administration emerged (Bhatnagar, 2019). Eliminating these challenges starts from production as manufacturers could go wrong with their mixing of drugs. Thus, the automated robotic application appears as a means of addressing these errors. Hence enhancing safety in drug administration is essential in promoting health.
Product or solutions exemplified
Time has continually increased customer expectations when it comes to pharmaceutical drugs. Hence, to keep up with the market quality of products and continuous delivery, modern robotics helps to promote these significant aspects. It has become a means of producing high-quality products with increased flexibility within a short period. Further, automation will encourage transportation material and in a highly efficient way. In pharmaceutical industries, production emerges as dynamic and agile (Baltzan, 2020). Transportation of materials and finished goods takes place in a semi-finished way from warehouse to production lines. The workers handling these transportations spend a lot of time as they have to break from the actual duties to attend to the same which contributes to inefficiency as machines are left unattended during this break. It is also a deployable option. Features such as software and cameras enable a robot to take note of its surroundings and identify the most efficient route to take, which promotes safety by keeping away from obstacles and people. Hence, the robot works safely around humans.
End-User
Besides, modern robotics will assist in eliminating counterfeit drugs, which is an essential aspect amongst end-users. Supply chain design decisions significantly rely on the product that reaches a patient (Bhatnagar, 2019). With an increased need to have a safe and effective therapeutic framework for end-users, pharmaceutical distribution chain costs have increased significantly. Product nature also affects the distribution and storage elements which emerge as challenges. The pharmaceutical industry has a global component, and the supply chain comprises a framework of manufacturers that are both secondary and primary. There is large-scale production of off-the-shelf prescriptions and vaccines with single manufactured portions delivered to various patients with non-specific doses (Bhatnagar, 2019). Robotic modernization promotes the distribution of personalized medication for those patients with specific health conditions as some approaches, such as allogenic, pose challenges such as various donor-patient matching challenges (Bhatnagar, 2019). The pharmaceutical industry comprises R&D multinationals, local companies, amongst other manufacturing organizations. The aspect will also allow manufacturers to maintain product stability that gets recommended throughout the whole supply chain. Temperature is one of the things that compromise bio-products. Automated supply strategies thus enhance transportation of these products and, if not protected, could result in damages.
In conclusion, the last years have seen an evolvement in products involving advanced manufacturing steps. The use of robotics will offer an off-the-shelf solution. Custom-built production is another provision of modern robotics. Moreover, modern robotics promote standard resolution that proves rewarding to suppliers and significantly attractive to the applying industry in terms of execution (Bhatnagar, 2019). Hence, modern robotics will promote the supply chain within the pharmaceutical industry, which is a significant way of promoting healthcare outcomes and eliminating or reducing errors that have continued to emerge within the health sector.
References
Baltzan, P. (2020). Business-driven technology. McGraw-Hill/Irwin.
Bhatnagar, N. (2019, March). Role of robotic process automation in pharmaceutical industries. In International Conference on Advanced Machine Learning Technologies and Applications (pp. 497-504). Springer, Cham.
Creating a website
NGO Website ProjectObjectivesUpon completing this assignment, you will be able to:design and build a multi-page HTML websi ...
Creating a website
NGO Website ProjectObjectivesUpon completing this assignment, you will be able to:design and build a multi-page HTML website with a consistent look and style;describe how hyperlinked documents use URLs to form connections between them;Create internal and external hyperlinks;use HTML tags to create semantic structure in a web document;integrate images and other multimedia elements into a web document;use lists and tables to organize and layout the elements of a web document;create a blog or micro-blog using a free hosted service.OverviewIn this project you will design and implement a simple, small web site and blog for a fictitious Non-Governmental Organization (NGO). The focus will be on creating a well-structured, consistent design, with good connections to related sites on the WWW.You will work in a small team of 2 - 3 students to complete this project and must learn to participate and share in all aspects of the project, from design and research, to implementation and testing.The ScenarioYou have been asked to design a website and blog for an NGO (e.g., an environmental, advocacy, health-watch, community group, or other non-profit organization) to help them promote their work on a particular issue. The goal of this web site is to inform people about the issue and to attract new supporters.People visiting the site should get a balanced, well informed understanding of the issue, in addition to some information about the organization, its mission, and the actions it is taking. Since the NGO hopes to attract new members (and thus more funding!) with their on-line presence, you need to make the web site attractive to your potential members. It should be informative and easy to browse, allowing the user quick access to the information and features he or she needs, and providing links to related web sites.Important Note: do not try to cram a lot of information about your topic onto your site. Rather concentrate on creating a nice design with basic information and links to web sites where related and more detailed information can be found. Your focus should be on layout and design, rather than packing in a ton of content!Getting Started TasksSelect a team.You should work on this project in a team of 2 - 3 students. Be sure to choose a partner with similar interests and a compatible schedule!Select an environmental or social issue.Choose an issue that you feel is interesting, overly exaggerated, or urgently pressing. Use your imagination, and choose something that interests you. Be creative - make something up - use humour if you like. Some examples might include air pollution, homelessness, oil spills, drug addiction, climate change, nuclear waste, endangered species, alternative energy, poverty, sustainability, etc. The issue may be very general or quite specific. For example, one might choose "endangered species" in general, or focus specifically on "Mountain Gorillas"; or "animal cruelty" vs. "cruelty to slugs".Select a name and a mission for your organization.Make-up an imaginary organization whose objective is to either to dismiss or raise awareness about this issue. Note that the organization may advocate any viewpoint on the issue, from "de-bunking a myth" to conservation and activism -- it is up to you to decide on their "mission statement".Research your issue.Research the issue with an aim of trying to understand the different viewpoints that exist. For example, what does this issue mean for individuals living in North America as opposed to Africa? What are the alternatives? What are the costs of dealing with it? What are the benefits of leaving the status quo? How will our actions affect future generations? etc.Be sure to "bookmark" useful sites or write down their URL's so you can return to them later.Develop a basic outline that summarizes your research findings. This will help you to organize your thinking and select the most important pieces of information to use for your website.Designing the websiteLike you would in any real life web project, start by designing the overall structure and look of your website. No knowledge of HTML is required as this stage is done on paper.Decide on the overall site "architecture"How are you going to organize your site? What pages will it have? How will they be linked together? This is the initial phase of your web site design. Draw a diagram - a "site map" - of your overall design to show the main pages and the relationships and links between them.Design the look and feel for pages on your site.It is important that all the pages on your site have a consistent "look and feel". Create a design theme for pages on your site -- will they have a banner or a sidebar or a background image? what will the colour scheme be? will they have a navigation menu? will there be a logo on each page, and if so, where? will there be a footer? Have a look around the web for sites that you like and find attractive -- what are the design elements being used?Draw a sketch of a typical page to show how it will be laid out (e.g., show the locations of titles, graphics, text areas, navigation bars, etc.). While you are encouraged to be creative when designing your website, the web is primarily a communication tool and you must make sure that your site is usable and friendly. The guidelines established at http://usability.gov/guidelines/index.html will help, and the HTML hell page will identify some things you should really avoid!Features of your siteYour site must include the following pages :An "introduction" page to describing the general purpose of the site (your organization's "mission"), in a file named index.htmlA blog that will serve to keep your readers up to date with the latest news.Details on the various activities/services/topics etc. (will vary based on site, but keep it simple!)A "contact" page with your contact information, including the e-mail address of the person managing the site and the date that the site was last revisedTo attract potential members, your site could implement a feature, such as:
a current top 10 list of corporate polluters,tips for energy efficient living,a simple game,an annotated photo-galleryUse your imagination to choose something that will appeal to your potential members.You must use appropriate images, graphics, and media to enhance the look of your site. Since these sites will be private, you do not need to worry about obtaining copyrights for any images you download from the WWW. However, at least one of the images used on your site must be an original - a photo taken by someone on your team.You must provide links to at least 5 other relevant sites, such as home pages of other NGO's and related government, university research sites, blogs, etc.Select a Blog PlatformDo some research on the various free blog hosting, or micro-blogging services available. Decide on one to use for this project - make some notes about the criteria you used and the reasons why you choose it.Create a blog on that service for your organization. During implementation, you will customize this blog and link it to your website!mplementing Your NGO Website and BlogNow that we have completed the website design on paper, we are ready to code! Your website must conform to these technical requirements.The homepage for your website must be in a file named "index.html ".The website must incorporate all of the the following HTML elements:Different paragraph / heading styles (don't go crazy, refer to the guidelines)Links: both internal or externalImages (IMG) - at least one original image (e.g., taken with your phone or camera)Your website must be free of HTML errors. You can tidy up your webpage using HTML Tidy.Your website MUST validate correctly - be sure to pass each page through the HTML validator:https://validator.w3.org/nu/Finally, of course, your site must use correct Canadian English spelling and grammar, to a standard appropriate for 100 level English at Capilano University.Implement your blogCreate a blog or micro-blog on the hosting service on your choice, make sure that the theme is similar in style to your website (select a template with similar colours and/or layout, possibly customize the theme with your logo or other identifying images).As your first blog post, provide a 1-2 paragraph explanation on why you chose that particular blogging service - what criteria did you use, why this service over the others?Create at least one additional blog entry per person in your group.This blog post should provide feedback for team members and your instructor about how the project went for you.Add a link from your website to the blog (ideally as a menu item)Add a link from your blog back to your websiteEvaluation CriteriaTo complete this assignment, you must upload your complete website to the WWW for grading and public viewing. Submit the URL of your website on Moodle.The work must be of a reasonable standard to be acceptable for grading.Acceptable work will be evaluated on the following characteristics:CriteriaEvaluationLayout, Design & Organisation :- multi-page site with suitable layout– consistency, structure, ease of browsing- aesthetics (appropriate use of colour, fonts, formatting, etc).30Requirements- site has all required components- site uses required HTML tags- site validates correctly10Media– inclusion of appropriate media- at least one original photo10Content:- originality & quality of information (not quantity!)- links are relevant and function correctly- administrative & contact info, all team members clearly identified10Blog :- successful setup of the blog site- consistent style and theme- linked with website- required blog entries30Technical Requirements :- homepage is named index.html- spelling and grammar10Total100
6 pages
Equifax Data Breach.edited 1
Equifax company serves as one of the most significant credit reporting firms in the world. They track and analyze the hist ...
Equifax Data Breach.edited 1
Equifax company serves as one of the most significant credit reporting firms in the world. They track and analyze the history of all their customers ...
Earn money selling
your Study Documents