Author: admin

  • Week 4 Assignment – Leadership, Inclusive Excellence, and So…

    The purpose of this assignment is to assist you in meeting the following unit objectives:

    • Develop a foundational understanding of effective healthcare leadership and communication by applying diversity, equity, inclusion, and cultural competencies. (CLO 4)
    • Demonstrate the ability to use complexity science and systems theory in designing, delivering, and evaluating healthcare. (CLO 5)
    • Design and implement systems change strategies that improve the care environment. (CLO 5)

    Instructions:

    Step 1: Consider your future career path; your position’s role in addressing diversity, equity, and inclusion; belonging; and the Social Determinants of Health.

    • Analyze the structural and social drivers of health (Wilensky & Teitelbaum, p. 140) and the Social Determinants of Health categories (pictured below) as they apply to this role.

    Step 2: Using two of Deloittes Six Signature Traits of Inclusive Leadership (Helm-Murtagh & Erwin, p. 230), align a key Social Determinant of Health (SDOH) topic with each selected leadership trait. The same SDOH topic should be used across all three traits to demonstrate how different leadership approaches can address the issue from various perspectives.

    • At least one of the selected traits must be Cognizance of Bias.
    • Each trait section should be supported by a scholarly, peer-reviewed source relevant to the SDOH topic.

    Step 3: Now, reflect on your approved policy topic from Week 2. Conduct brief research to identify potential allies who could help drive change related to your topic.

    • Describe a key stakeholder or policymakerby name and positionwho has the ability to influence change at the local, regional, state, or federal level.
    • Then, analyze which of Deloittes Traits of Inclusive Leadership this individual demonstrates that could help move your policy topic forward.

    Submission Outline (Include Headers in Paper)

    • Title Page
    • Introduction
    • Step 1 Inclusive Excellence
    • Step 2 Deloittes Traits
    • Step 3 Stakeholder Identification
    • Conclusion
    • References

    Additional sources can be used besides scholarly peer-reviewed sources.

    • Scholarly, peer-reviewed sources should be within five years of publication.
    • Include an APA-style formatted reference list of your sources.
    • At least one of the traits should be cognizance of bias.
    • Submit in an APA-style formatted paper. The paper should be 5-7 pages long, excluding the title/reference page.
    • Use headers in the paper to identify the leadership traits addressed.

    Other Sources:

    • Wilensky & Teitelbaum, pp. 141-142
    • Types of Social Drivers of Health (similar to SDOH)
    • Helm-Murtagh & Erwin, p. 230
    • Deloitte’s Six Signature Traits of Inclusive Leadership
    • Dillon, B., & Bourke, J. (2016, April 13). . Deloitte University Press. https://www.deloitte.com/us/en/insights/topics/talent/six-signature-traits-of-inclusive-leadership.html

    Social Determinants of Health

    Source: Ndugga, N., & Artiga, S. (2023, May 24). Disparities in health and health care: 5 key questions and answers. KFF. https://www.kff.org/racial-equity-and-health-policy/issue-brief/disparities-in-health-and-health-care-5-key-question-and-answers/

    Deloittes Six Signature Traits of an Inclusive Leader

    Source: Dillon, B., & Bourke, J. (2016). The six signature traits of inclusive leadership: Thriving in a diverse new world. Deloitte University Press.

    maternal mortality nurse practitioner student

  • DIGITAL PRODUCT

    Digital products are a tool for additional online income. Many YouTubers and streamers use them as a side hustle. Digital products have been around for a long time and are now widely used. The advantage is that they can be used in all countries. However, digital products require consistent work and focus on a single goal.

    Want to know more about what a digital product is?

    Okay Okay, let’s go Okay let’s goOkay let’s discuss it Okay, let’s discuss it together !!!

    Digital Products: A Comprehensive and Complex Exposition

    Definition and Core Characteristics

    A digital product is an intangible good or service that exists in electronic form, delivered and consumed through digital infrastructure such as computers, mobile devices, networks, and cloud systems. Unlike physical products, it has no tangible substance, does not occupy physical space, and its production, distribution, and consumption processes are fundamentally mediated by digital technologies.

    Key defining attributes include:

    1. Non-rivalrous consumption: One users consumption does not diminish availability for others (e.g., a software license can be used by multiple users simultaneously without depleting the product itself, though licensing agreements may restrict this).

    2. Zero marginal cost of reproduction and distribution: Once the original version is created, producing additional units or delivering them to new users incurs negligible to no costdistinct from physical goods where each unit requires materials, manufacturing, and shipping.

    3. Modularity and interoperability: Digital products can often be decomposed into smaller components, modified, or integrated with other digital systems (e.g., application programming interfaces (APIs) enabling software to interact with third-party tools).

    4. Perpetual evolvability: Unlike physical goods that degrade or remain static once produced, digital products can be updated, patched, or enhanced indefinitely (e.g., operating systems receiving regular security and feature updates).

    5. Dual nature as good and service: Many digital products blur boundaries between goods and servicesfor example, a subscription-based project management platform functions as a good (providing a tool) and a service (offering ongoing support, maintenance, and hosting).

    Classification Framework: A Multi-Dimensional Taxonomy

    Digital products cannot be categorized by a single metric; a nuanced classification requires consideration of purpose, delivery model, revenue mechanism, and technical architecture:

    By Functional Purpose

    – Informational products: Designed to convey knowledge or data (e.g., e-books, research reports, online courses, digital databases). These rely on structured information organization and may incorporate interactive elements like quizzes or search functionality.

    – Software products: Engineered to perform specific tasks or enable computing operations (e.g., operating systems, productivity suites, mobile applications, enterprise resource planning (ERP) systems). They are built on programming languages, algorithms, and hardware abstraction layers.

    – Media and entertainment products: Created for aesthetic, recreational, or cultural consumption (e.g., digital music, streaming video, video games, digital art, virtual reality experiences). These often leverage compression technologies, content delivery networks (CDNs), and immersive interface design.

    – Platform products: Facilitate interactions between multiple user groups (e.g., social media platforms, e-commerce marketplaces, payment gateways). Their value is derived from network effects, where utility increases as more users join the ecosystem.

    – Infrastructure products: Provide foundational digital capabilities to support other products or services (e.g., cloud computing resources, data storage solutions, network security tools, application development frameworks). These are critical for enabling scalability and reliability across digital ecosystems.

    By Delivery and Access Model

    – Downloadable products: Distributed as files that users store locally on their devices (e.g., desktop software, e-books in PDF/EPUB format, digital music files). This model requires users to manage storage and updates manually.

    – Streaming/access-based products: Delivered on-demand over networks, with content or functionality accessed in real time without local storage (e.g., Netflix video streams, Spotify music, cloud-based software as a service (SaaS) tools). This relies on stable internet connectivity and centralized hosting infrastructure.

    – Embedded products: Integrated into physical devices or other digital systems (e.g., firmware in smart appliances, operating systems in smartphones, algorithms in autonomous vehicles). These are often designed for specific hardware environments and require specialized development processes.

    – Token-based products: Represented as digital assets on distributed ledger technologies (blockchains) (e.g., cryptocurrencies, non-fungible tokens (NFTs), decentralized finance (DeFi) protocols). These leverage cryptographic mechanisms for security, ownership verification, and transaction management.

    Economic and Market Dynamics: Complex Interactions

    The economics of digital products diverge dramatically from traditional physical markets, driven by unique cost structures, value drivers, and competitive forces:

    Cost Structure

    – Fixed costs dominate: Development, research, and intellectual property (IP) creation account for the vast majority of total costs, while variable costs for reproduction and distribution are minimal. For example, developing a mobile game may cost millions of dollars in design, coding, and testing, but each additional download incurs only fractions of a cent in server and bandwidth expenses.

    – Sunk costs are irreversible: Investments in digital product development are typically non-recoverable if the product fails, creating high barriers to entry and significant risk for new market participants.

    – Scale economies are extreme: As user volume increases, average total cost declines sharply, enabling dominant firms to achieve substantial cost advantages over competitors.

    Value Creation and Pricing

    – Network effects: The value of many digital products increases exponentially with the number of users (direct network effects) or complementary products/services (indirect network effects). For instance, a social media platform becomes more useful as more people join, and a smartphone operating system gains value as more developers create compatible apps.

    – Versioning and differentiation: Firms often offer multiple tiers of the same product (e.g., free basic versions vs. premium paid versions) to capture different segments of the market and maximize revenue. This requires sophisticated segmentation analysis and pricing strategy.

    – Data as a complementary asset: Many digital products generate or leverage user data to enhance functionality, personalize experiences, or create additional revenue streams (e.g., targeted advertising, market research). This creates complex trade-offs between value creation, user privacy, and regulatory compliance.

    Competitive Landscape

    – Winner-takes-most markets: Due to network effects and scale economies, a small number of firms often dominate digital product categories (e.g., Google in search engines, Microsoft in productivity software). This can lead to concerns about market power and anti-competitive behavior.

    – Rapid innovation cycles: Technological advancement and changing user preferences drive frequent product updates and new entrants, creating constant pressure for firms to invest in research and development.

    – Global reach and local adaptation: Digital products can be distributed globally instantly, but success often requires adaptation to local languages, regulations, cultural norms, and infrastructure conditions.

    Technical and Operational Challenges

    Developing, delivering, and managing digital products involves a complex set of technical and operational considerations:

    Technical Complexity

    – Interoperability standards: Ensuring compatibility across different devices, operating systems, and networks requires adherence to technical standards, which may be fragmented or evolving (e.g., video compression standards, API protocols).

    – Security and privacy: Digital products are vulnerable to cyberattacks, data breaches, and privacy violations, requiring robust encryption, authentication, and compliance with regulations such as the General Data Protection Regulation (GDPR) and the California Consumer Privacy Act (CCPA).

    – Scalability and reliability: As user volume grows, digital products must be able to handle increased demand without degradation in performance or availability. This requires scalable architecture, load balancing, and disaster recovery planning.

    – Legacy system integration: Many organizations need to integrate new digital products with existing legacy systems, which may use outdated technologies or have limited compatibilitycreating significant technical and operational hurdles.

    Operational Management

    – Lifecycle management: Digital products require ongoing maintenance, updates, and end-of-life planning. Unlike physical goods that are sold and then discarded, digital products may need to be supported for years or decades, requiring long-term resource commitment.

    – User experience (UX) optimization: Success depends on delivering intuitive, responsive, and engaging experiences. This requires continuous testing, user feedback analysis, and iterative design improvements.

    – Supply chain and distribution: While digital products do not have physical supply chains, they rely on complex networks of infrastructure providers, content creators, distributors, and partners. Managing these relationships and ensuring reliable delivery is critical.

    – Intellectual property protection: Digital products are easy to copy and distribute without authorization, making IP protection a major challenge. Strategies include copyright, patents, trademarks, digital rights management (DRM) technologies, and legal enforcement.

    Regulatory and Ethical Considerations

    The growth of digital products has raised a wide range of regulatory and ethical issues that vary by jurisdiction and product type:

    Regulatory Frameworks

    – Intellectual property laws: Govern ownership, reproduction, and distribution of digital content and software. These laws are constantly evolving to address new technologies such as blockchain and artificial intelligence.

    – Consumer protection regulations: Ensure fair pricing, transparent terms of service, and protection from fraud or misleading practices. For example, regulations may require clear disclosure of subscription renewal terms or data collection practices.

    – Competition laws: Aim to prevent anti-competitive behavior such as monopolization, price fixing, or exclusionary practices. Regulators are increasingly focusing on digital markets due to concerns about market concentration.

    – Data protection and privacy regulations: Govern how user data is collected, used, stored, and shared. These regulations vary significantly globally and can have major implications for digital product design and operation.

    – Content regulations: Govern the distribution of digital content, including restrictions on harmful or illegal material, age verification requirements, and cultural or religious sensitivities.

    Ethical Dilemmas

    – Digital divide: While digital products have the potential to increase access to information and services, disparities in internet connectivity, device ownership, and digital literacy can create or exacerbate inequalities.

    – Algorithmic bias: Many digital products use algorithms to make decisions or personalize experiences, which can perpetuate or amplify biases based on race, gender, age, or other characteristics.

    – Addiction and mental health: Some digital products (e.g., social media, video games) are designed to be highly engaging, raising concerns about their impact on mental health, productivity, and social relationships.

    – Environmental impact: While digital products do not have physical production emissions, the energy consumption of data centers, networks, and devices contributes to climate change. Additionally, electronic waste from obsolete devices is a growing environmental concern.

    Future Trends and Emerging Developments

    The evolution of digital products is being shaped by rapid technological advancement and changing societal needs:

    – Artificial intelligence (AI) integration: AI is being used to enhance functionality, personalize experiences, automate development processes, and enable new product categories (e.g., AI-powered chatbots, predictive analytics tools).

    – Metaverse and immersive technologies: Virtual reality (VR), augmented reality (AR), and mixed reality (MR) are enabling new forms of digital products that blur boundaries between physical and digital worlds (e.g., virtual workspaces, immersive entertainment experiences).

    – Decentralized products: Blockchain and distributed ledger technologies are enabling digital products that operate without centralized control, offering potential benefits in terms of security, transparency, and user ownership (e.g., decentralized social networks, peer-to-peer payment systems).

    – Sustainability-focused design: There is growing emphasis on developing digital products that minimize energy consumption, reduce electronic waste, and support environmental sustainability goals.

    – Human-centric design: Future digital products are likely to prioritize accessibility, inclusivity, and well-being, with a focus on meeting the diverse needs of users across different demographics and contexts. Here are some pictures of digital products:

    Content-Based Products

    – E-books and Premium Articles: Electronic books and written content accessible on digital devices.

    – Online Courses and Webinars: Learning materials presented as videos, texts, or interactive quizzes, plus educational online events.

    – Podcasts: Audio recordings covering diverse topics that can be enjoyed anytime.

    Software and Applications

    – Mobile Apps: Programs designed for smartphones or tablets.

    – Software as a Service (SaaS): Cloud-based services accessed via subscription, like Microsoft 365 or Adobe Creative Cloud.

    – Templates and Plugins: Such as website templates, WordPress themes, or graphic design filters to assist users in content creation or website development.

    Digital Entertainment Products

    – Digital Movies and Music: Content that can be downloaded or streamed through platforms like Netflix and Spotify.

    – Digital Games: Electronic games playable on various devices.

    – NFTs: Blockchain-based digital assets often used in digital art and virtual collections.

    Digital Services

    – Hosting and Domains: Data storage and domain name services for websites.

    – Graphic Design Services: Creation of digital logos, banners, or illustrations.

    – Online Consulting: Advisory services provided virtually via video calls or online chats.

    Requirements:

  • Exploration Discussion

    Part 1 – First, read over this example:

    A sales job offers a weekly base salary of $575 plus a commission of $250 for every sale made that week. The weekly earnings for a salesperson can be modeled:

    y = 250x + 575

    where x (the independent variable) is the number of sales made during the week and y (the dependent variable) is the total earnings of the salesperson for the week.

    Using this example as a model, go online and find another real-world application of a linear equation in 2 variables.

    Share this equation and discuss what is being modeled as well as what the independent and dependent variables represent, in context. If the example you find uses variables other than x and y, be sure to use x and y instead and write the equation in y = mx+b form.

    You may use an example from an educational resource, such as Khan Academy or something similar. Be sure to cite this resource at the bottom of your initial post in proper APA format.

    In addition, graph the linear equation using

    • Part 2
    • Choose a course with an upcoming exam and pick one USLO from your syllabus that will be covered on the exam.
    • Select a study technique listed in and
      • Helpful Hint- Note Cards, 3 Column Notes, or other notes are not a study strategy. Please ensure that you select a strategy listed in the course material.
    • Why did you choose that study strategies? Embed a video, picture, or handout of your chosen study strategy from this unit (cannot be coded text or 3-column notes)

    Requirements: page

  • BUS 530 DISCUSSION POST WK2

    Module 2 Discussion Week 2 Resources

    (2024)

    (2024)

    (2024)

    (2024)

    Research a scenario (not presented in the readings) and explain the relationship between the pandemic and the prices of a particular good. Seek an example from the last 12 months. Focus on economic theory to support the post. (Research Support Required)

    This post should be 2 paragraphs (150-200 words). Since you are engaging in research, in the body of the post and . NOTE: failure to use research with to support content will result in reduced scoring “Level 2-Developing” on the grading rubric.

    WEEK 2 INTERACTIVE RESPONSES TO CLASSMATES

    1st Interactive Response:

    • Analyze one student’s analysis and share your feelings about the scenario presented and assess how well it was connected with economic theory. (See Attachment)

    2nd Interactive Response:

    • Analyze another student’s coverage and share your feelings about the scenario presented and assess how well it was connected with economic theory. (See Attachment)

    Each reply should be one paragraph (or about 75 words) and must be substantive. Do not simply say “I agree” or “That is great.” Specify why and be detailed in your explanation. You may use research in your responses, but it is not required.

    Attached Files (PDF/DOCX): 1st 2nd Interactive Post.docx

    Note: Content extraction from these files is restricted, please review them manually.

  • Retrieving Data Using Advanced Queries & Transactions an…

    Task 1: Retrieving Data Using Advanced Queries

    You will use generative artificial intelligence (GenAI) applications to establish SQL statements retrieving data from the Northwind database for the prompts presented below. You will need to upload a copy of the Northwind physical database design diagram (, , ) to the GenAI application for each prompt. Take a screenshot of the GenAI output showing the SQL statement and paste it into your report document. Copy and paste the GenAI-created SQL statement into an SSMS or ADS query window. Modify, if necessary, the SQL statement to correct for syntax or compatibility errors. Run the query statement in SSMS or ADS. Take screenshots showing each SQL query and the execution results and paste them into the Microsoft Word report document.

    Here is a list of available free public GenAI applications that can be utilized:

    You must scrutinize the output from GenAI applications. The results may be incomplete and/or incorrect. You may need to revise the question posed to the GenAI applications to get an acceptable outcome.

    Here is an example of using Anthropic Claude to generate a query statement:

    A screenshot showing the interface of a generative AI tool. The top of the screen displays a text box where a user has entered a prompt: "Generate a query presenting the list of suppliers with 5

    Here is an example execution of the GenAI-provided SQL statement in Microsoft SSMS:

    SQL query selecting Supplier ID, Company Name, and product count from suppliers and products tables. The query groups by Supplier ID and Company Name, having at least 5 products, and orders by product

    Problem 1: Create a report of seafood and produce products, showing ProductID, ProductName, and CategoryName. Incorporate an inner join condition for this query.

    Expected Output

    alt="The expected query output showing the ProductID, ProductName, and Category Name of 'seafood' and 'produce' products."

    Problem 2: List the last name, first name, title, and salary of company employees with salaries above the company average. Use a non-correlated subquery in the SQL statement.

    Expected Output

    The expected query output showing the last name, first name, title, and salary of company employees with salaries above the company average.

    Problem 3: List the average salaries for employees in Seattle and London. The averages need to be calculated on a per city basis. Use a union operation to generate the results. (Hint: Use one SQL statement to calculate the average salary for one city and another almost identical SQL statement to calculate the average salary for the other city.)

    Expected Output

    The expected query output showing the average salaries of Seattle and London employees.

    Problem 4: Show the product names for products that have been ordered in quantities equal to or exceeding 120. Use a non-correlated subquery in the SQL statement.

    Expected Output

    The expected query output listing the products that have been ordered in quantities equal to or exceeding 120.

    Problem 5: List the supplier names and cities for suppliers that reside in the same cities as Northwind employees. Use a non-correlated subquery in the SQL statement.

    Expected Output

    The expected query output listing the supplier names and cities for suppliers residing in the same cities as Northwind employees.

    Problem 6: Display the names of Northwind employees that manage territories located in the Western region. Use inner joins in the SQL statement linking the Employees, EmployeeTerritories, Territories, and Region tables. Do not show duplicate employee names in the result set.

    Expected Output

    The expected query output listing the names of Northwind employees that manage territories in the Western region.

    Problem 7: Display customer names, cities, and order IDs for customers residing in Madrid or Paris. Show all customers regardless of whether they have placed orders or not. Use an outer join in the SQL statement.

    Expected Output

    The expected query output listing the customer names, cities, and order IDs for customers residing in Madrid or Paris.

    Problem 8: Display a combined list of supplier and shipper names along with their phone numbers. Use a union operation in the SQL statement. Present the results in alphabetical order based on CompanyName.

    Expected Output

    The expected query output displaying a combined list of supplier and shipper names along with their phone numbers.

    Problem 9: Show the employee names, salaries, and countries for employees that have salaries above the average salary within their respective countries. Use a correlated subquery in the SQL statement.

    Expected Output

    The expected query output showing the employee names, salaries, and countries for employees that have salaries above the average salary within their respective countries.

    Problem 10: Display the names of products supplied by vendors in the USA and Norway. Show the product country in the result set. Present the results in alphabetical order by product name. Use an inner join in the SQL statement.

    Expected Output

    The expected query output displaying the names of products supplied by vendors in the USA and Norway.

    To complete this assignment, Microsoft SQL Server Express and either SQL Server Management Studio (SSMS) or Azure Data Studio (ADS) must be installed. The Northwind database must be instantiated within the environment.

    Compose your assessment in a Microsoft Word report document, and be sure to identify yourself, your class, and the module assessment at the top of your paper. Embed the screenshots of your GenAI outputs, SQL statements, and confirmatory output (e.g., table structure definitions, query results, etc.) into the Microsoft Word report document.

    Task 2: Transactions and Security Implementations

    Complete the following problems in either Microsoft SQL Server Management Studio (SSMS) or Azure Data Studio (ADS). Take screenshots of the SQL statements and execution/confirmatory results and place them in a Microsoft Word report document.

    Use the Northwind physical database design diagram (, , ) as a guide for this assignment.

    Problem 1: Create a view called EmployeeDirectory that displays the first name, last name, title, and phone extension of all company employees. Use the CREATE VIEW command to accomplish this task. Then execute a query statement that selects all employees from the EmployeeDirectory view.

    Problem 2: Create a stored procedure that increases an employees salary by a specified raise percentage. The skeleton of the stored procedure is provided below.

    CREATE PROCEDURE GiveEmployeeRaise
    @EmployeeID INT, @RaisePercentage DECIMAL
    AS
    <REPLACE WITH YOUR SQL CODE>

    The equation for computing a new salary is as follows:

    New Salary = Old Salary * (1 + Raise Percentage/100)

    If an employee with EmployeeID = 9 gets a 5% raise, the stored procedure call would be as follows:

    EXEC GiveEmployeeRaise @EmployeeID = 9, @RaisePercentage = 5;

    Problem 3: Create and execute a transaction block that contains two DML statements. The first statement updates the title for all employees to President. The second statement inserts a new region record with a RegionID = 10 and a RegionDescription = Antarctica. Incorporate these statements within the SQL block specified below:

    BEGIN TRANSACTION

    <REPLACE WITH INSERT/UPDATE STATEMENTS>

    SELECT * FROM Employees;
    SELECT * FROM Region;

    ROLLBACK TRANSACTION

    SELECT * FROM Employees;
    SELECT * FROM Region;

    Execute the completed SQL block in a Microsoft SSMS query window.

    Briefly explain what happened with the execution of this transaction. Provide screenshots of the data before and after the ROLLBACK TRANSACTION statement. Please note the query results will appear in 4 separate sections in the Results area of Microsoft SSMS following the execution of the above SQL block.

    Problem 4: You are asked to add three new products to an existing order with OrderID = 11061. The additional records need to be added to the OrderDetails table with the following information:

    Record 1

    OrderID = 11061

    ProductID = 62

    UnitPrice = 45

    Quantity = 10

    Discount = 0

    Record 2

    OrderID = 11061

    ProductID = 70

    UnitPrice = 14

    Quantity = 25

    Discount = 0

    Record 3

    OrderID = 11061

    ProductID = 1000

    UnitPrice = 100

    Quantity = 5

    Discount = 0

    Incorporate the SQL insert statements for the new records into the transaction block specified below and execute in a Microsoft SSMS query window:

    BEGIN TRANSACTION NewOrderDetails

    BEGIN TRY

    <REPLACE WITH INSERT STATEMENTS>

    COMMIT TRANSACTION NewOrderDetails;

    END TRY

    BEGIN CATCH

    ROLLBACK TRANSACTION NewOrderDetails

    END CATCH

    SELECT * FROM OrderDetails
    WHERE OrderID = 11061;

    Briefly explain what happened with the execution of this transaction. Do the new records get inserted into the OrderDetails table? If not, why?

    Problem 5: Create two new roles in the Northwind database:

    • SalesPerson
    • SalesManager

    Use the CREATE ROLE command to complete this task. Execute the following SQL statement to confirm the establishment of the new database roles:

    SELECT name AS “Database Role”
    FROM sys.database_principals
    WHERE type = ‘R’ AND tenant_id IS NOT NULL;

    Problem 6: Use Data Control Language (DCL) statements that manage database user permissions.

    • Grant select, insert, and update permissions for Sales-related tables (Orders & OrderDetails) to the SalesPerson role.
    • Grant select and delete permissions for Sales-related tables (Orders & OrderDetails) to the SalesManager role.
    • Grant select permissions for the EmployeeDirectory view to the SalesManager role.

    Use the GRANT command to complete this task. Execute the following SQL statements to confirm the role permissions:

    EXEC sp_helprotect ‘Orders’;

    EXEC sp_helprotect ‘OrderDetails’;

    EXEC sp_helprotect ‘EmployeeDirectory’;

    Problem 7: Create two new users named Jill and Jack. For this exercise, each established Northwind database user account will not be associated with an SQL Server login account. Use the CREATE USER command to accomplish this task.

    CREATE USER <username> WITHOUT LOGIN;

    Execute the following SQL statement to confirm the addition of the new database users:

    SELECT name AS “Database User”
    FROM sys.database_principals
    WHERE type = ‘S’ AND tenant_id IS NOT NULL;

    Problem 8: Grant the roles specified below to Jane, Joan, Joe, and James.

    • Give Jack the role of SalesPerson.
    • Give Jill the role of SalesManager

    Use the ALTER ROLE command to accomplish the role-granting work.

    ALTER ROLE <role_name> ADD MEMBER <user_name>;

    Execute the following SQL statement to confirm the role memberships:

    SELECT DP1.name AS DatabaseRoleName,
    DP2.name AS DatabaseUserName
    FROM sys.database_role_members AS DRM
    RIGHT OUTER JOIN sys.database_principals AS DP1
    ON DRM.role_principal_id = DP1.principal_id
    LEFT OUTER JOIN sys.database_principals AS DP2
    ON DRM.member_principal_id = DP2.principal_id
    WHERE DP2.name IS NOT NULL
    AND DP2.type = ‘S’
    AND DP1.type = ‘R’
    ORDER BY DP1.name;

    Problem 9: Generate SQL statements as the user Jack in a query window to do the following:

    1. Update the order quantity to 50 for OrderID = 10249 and ProductID = 51.
    2. Delete the record in OrderDetails with OrderID = 10251 and ProductID = 65.
    3. Insert a new order item into the OrderDetails table with the following specifics:

      OrderID = 10251
      ProductID = 48
      UnitPrice = 12.24
      Quantity = 10
      Discount = 0.04

    4. Display all of the records from the EmployeeDirectory view established in Problem 1

    Use the following code block to execute each SQL command as Jack:

    EXECUTE AS USER = ‘Jack’;
    <SQL STATEMENT(S)>
    REVERT;
    GO

    Replace the <SQL Statement(S)> tag with the SQL statement(s) addressing the applicable problem prompt.

    For example, the following query looking for order products with quantities of 120 or more is executed as the user Jack:

    The results of an SQL query executed by the user "Jack."  The results grid below the query displays columns for order ID, product name, and quantity. The data includes several rows with order IDs, pro

    Provide screenshots of the SQL statement outputs. Give a brief explanation for any statement that failed to execute

    Problem 10: Generate SQL statements as the user Jill in a query window to do the following:

    1. Update the order quantity to 60 for OrderID = 10249 and ProductID = 51.
    2. Delete the record in OrderDetails with OrderID = 10251 and ProductID = 65.
    3. Insert a new order item into the OrderDetails table with the following specifics:

      OrderID = 11077
      ProductID = 48
      UnitPrice = 12.24
      Quantity = 20
      Discount = 0.04

    4. Display all of the records from the EmployeeDirectory view established in Problem 1

    Use the following code block to execute each SQL command as Jack:

    EXECUTE AS USER = ‘Jill’;
    <SQL STATEMENT(S)>
    REVERT;
    GO

    Replace the <SQL Statement(S)> tag with the SQL statement(s) addressing the applicable problem prompt.

    For example, the following query looking for the count of order products with a 25% discount is executed as the user Jill:

    The results of an SQL query executed by the user "Jill." The results grid below the query displays a single row with a column labeled "25% Discount Items," showing the total number of order products t

    Provide screenshots of the SQL statement outputs. Provide a brief explanation for any statement that failed to execute.

    Compose your assessment in a Microsoft Word report document, and be sure to identify yourself, your class, and the module assessment at the top of your paper. Embed the screenshots of your GenAI outputs, SQL statements, and confirmatory output (e.g., table structure definitions, query results, etc.) into the Microsoft Word report document.

    Requirements: goog answer all the stepts

  • BUS 530 DISCUSSION POST WK2

    Module 2 Discussion Week 2 Resources

    (2024)

    (2024)

    (2024)

    (2024)

    Research a scenario (not presented in the readings) and explain the relationship between the pandemic and the prices of a particular good. Seek an example from the last 12 months. Focus on economic theory to support the post. (Research Support Required)

    This post should be 2 paragraphs (150-200 words). Since you are engaging in research, in the body of the post and . NOTE: failure to use research with to support content will result in reduced scoring “Level 2-Developing” on the grading rubric.

    WEEK 2 INTERACTIVE RESPONSES TO CLASSMATES

    1st Interactive Response:

    • Analyze one student’s analysis and share your feelings about the scenario presented and assess how well it was connected with economic theory. (See Attachment)

    2nd Interactive Response:

    • Analyze another student’s coverage and share your feelings about the scenario presented and assess how well it was connected with economic theory. (See Attachment)

    Each reply should be one paragraph (or about 75 words) and must be substantive. Do not simply say “I agree” or “That is great.” Specify why and be detailed in your explanation. You may use research in your responses, but it is not required.

  • Assignment #2 – Eye of the Storm

    Video required for the assignment:

    Eye of the Storm Jane Elliot 1970

    Attached Files (PDF/DOCX): Assignment 2 – Eye of the Storm.docx

    Note: Content extraction from these files is restricted, please review them manually.

  • Assignment #2 – Eye of the Storm

    Video required for the assignment:

    Eye of the Storm Jane Elliot 1970

    Attached Files (PDF/DOCX): Assignment 2 – Eye of the Storm.docx

    Note: Content extraction from these files is restricted, please review them manually.

  • Ley Nm. 9-1987 (antigua) vs Ley Nm. 254-2015 (vigente)

    Module #2 Ethical and Legal Aspects Related to the Transition

    Instructions / Evaluative Activity

    Part A Legal Comparison (Table)

    Create a comparative table that includes:

    • Law No. 9 of 1987 (former law) vs. Law No. 254 of 2015 (current law)
    • Purpose
    • Structure
    • Professional categories
    • Licenses / recertification
    • Role of the Board
    • Sanctions, among other relevant aspects

    Part B Short Essay (23 pages)

    Write an analysis in which you:

    • Explain the categories of practice according to Law 254 and what the professional transition (ADNBSN) entails.
    • Describe the continuing education requirements and the recertification/registration process every three (3) years, citing the corresponding regulation.
    • Integrate at least two patient safety goals (for example: patient identifiers, medication safety, communication, etc.) using current references such as Healthy People 2030 and The Joint Commission.

    Part C Presentation of the Assignment

    The paper must include:

    • Cover page
    • Introduction
    • Table (Part A)
    • Development / Analysis (Part B)
    • Conclusion
    • References (APA format)

    Recommended Official Sources (for your bibliography)

    • Law No. 254 of 2015 (revised/compiled version by OGP, Rev. April 15, 2024).
    • General Regulation No. 9104 (2019) Department of State (Online Regulations).
    • Continuing Education Regulation for Recertification (DS/ORCPS).
    • Law No. 11 of 1976 (OGP).
    • Healthy People 2030 (HHS).
    • Joint Commission National Patient Safety Goals 2026.

    Requirements:

  • Shadow Casters in Leadership

    Shadow Casters in Leadership Points: 25 Instructions: Leaders sometimes cast shadows through unhealthy motivations, poor decision-making, or contextual pressures. After reviewing the Chapter 2 slides, complete the following tasks: Short Answer (10 points) Identify and briefly explain two shadow casters (e.g., insecurity, selfishness, faulty decision-making, moral disengagement, etc.). Provide one real-world or historical example (a business leader, politician, or organizational figure) who demonstrated each of these shadow casters. Application (10 points) Choose one type of susceptible follower (conformer or colluder). Explain how this follower type can contribute to destructive leadership. Give an example of how this dynamic could appear in a workplace or organizational setting. Reflection (5 points) Reflect on your own leadership experiences (academic, professional, or personal). Which of the shadow casters do you think leaders are most at risk of facing today, and why? Submission Format: Write your responses in a Word document or directly in the LMS submission box. Your assignment should be 300400 words total.