There are 2 parts to this week’s assignment. (The detailed instructions are attached) Part A you will use a Web site to build and execute SQL commands. The Web site provides descriptions and examples of the SQL commands. You will create a table, enter data into that table, and use Select commands to create queries. I suggest you use Notepad to develop the SQL commands AND then a Word document for the submission. For Part 1 - you need to submit ONE Word document, which includes the SQL commands, and display captures of the Web site’s feedback. Hints and Common errors when using the SQL Web site can be found in the Terms and Concepts Forum. Part B – use MS Access to create the same tables, content and QueriesPart A SQL Commands (70%) Read all of the Part 1 instructions before beginning – you need to perform several SQL commands and capture several display images in this exercise – ensure you capture the entire display and paste it into a Word document, NOT just the SQL Web site “window” – contact the instructor if you do not understand these instructions or need guidance on how to capture the entire screen. Typically, all you need to do is to press the PRTSC key to capture the entire screen, then use Paste to paste the captured screen into a Word document. Failure to include entire screen displays will result in a minimum 10-point deduction. Go to http://sqlcourse.com/create.html , use the links on the left side of the Web site to review Table Basics, Creating Tables, Inserting into a table, and Drop a table, for the command syntax used by the Web site. You should also review the Select command instructions (which includes the “Where” clause) at http://www.sqlcourse2.com/select2.html . Then use the Standalone SQL interpreter (the link is on the left site of the Web site page) to enter and submit each SQL command. Use the Interpreter on the sqlcourse.com page – the SQL interpreter on the sqlcourse2.com page does not seem to work! The site executes one SQL command at a time. Create a table with the following columns – we are tracking properties that have been rented: PropertyNum 5 maximum numeric digits (no decimal points) Street up to 15 characters City up to 12 characters State 2 characters Zip 5 characters WeeklyRental 6 maximum numeric digits (2 decimal digits) MonthlyRental 6 maximum numeric digits (2 decimal digits) AgentNum 5 characters Tenant up to 14 characters. The table name should be your last name, plus your student number or another “unique” number. Insert the following four records into the table: (ensure the format agrees with the field type) (40011, 8215 Main St, Denver, CO, 33331, 650.75, 1200, ID102, Jones) (50112, 4711 Beacon St, Boston, MA, 60644, 700.50, 1300, ID103, Jones) (60213, 925 Myrtle Rd, Sarasota, FL, 33385, 450.50, 1100, ID103, Doe) include another record with different content – you determine the content, EXCEPT it must use ID103 for the AgentNum, and your last name for the Tenant. NOTE: The SQL INSERT Command syntax on the Web site differs from the text. The SQL Interpreter requires identification of the columns in the Insert Command to properly execute. Review this webpage for more specifics of the online SQL Interpreter INSERT Command. http://sqlcourse.com/insert.html . Create and Submit SQL commands to accomplish the following: A) Submit the SQL Create command used to create the table (you also were asked to capture and include the feedback from the Create table command). B) Use the Insert command to load the above records (one record at a time is recommended). C) Use the Select * command to list all fields for all records in the table. INFO321 Week 3 Assignment Page 2 of 2 D) List the PropertyNum, Street, City, WeeklyRental, AgentNum, and Tenant fields for all properties with a weekly rental less than 700 E) List the PropertyNum, Street, City, WeeklyRental, MonthlyRental, and Tenant fields for all properties assigned to agent ID102. Submit the assignment in a word document under the week's Assignment. Name your document Last_Name_SQLWeb (i.e. Smith_SQLWeb). The submission must include screen captures for: 1) The “create table” feedback display, this will confirm the Table Name and Field Names (A above) 2) The display after submitting one of the Insert commands in B above 3) The display after submitting C above 4) The display after submitting D above 5) The display after submitting E above, also (For each command, lnclude the SQL statements as text – above each screen capture). I suggest you use Notepad to create the SQL commands for use with the SQL Interpreter – then copy the commands into the Word document and include the screen captures for submission. MS Word may insert control characters that are not visible – they can cause errors. The SQL interpreter Web site does not provide much error feedback. The most common error is “Invalid character used in command” – this generally means you have an incorrect character in the statement; in many cases, you have used an incorrect single quote ‘(typing a single quote in Notepad seems to work, or copying a single quote from an example on the Web site works). If the command errors, you may have a syntax error. Also note that table and field names are case sensitive on this site and should not include spaces. If you run into trouble, start over by using the Drop Table command to delete your table, and begin again with the Create Table command. Part B Access Database (30%) Create the same table and Queries using MS Access – ensure you create a “new” Access database for this exercise. A Create the table (same fields as in Part A) B Insert the same data as in Part A C Create and Save the Query created for Item C above with the name Item C D Create and Save the Query created for Item D above with the name Item D E Create and Save the Query created for Item E above with the name Item E Hint – notice that there is no primary key identified – in other assignments we have primary keys – but for this exercise we do not need to specify a primary key Name the Access database Last Name_Assignment3 (i.e. Smith_ Assignment3).

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.