Bright Academic Experts

Category: Databases

  • Healthcare Databases Designe

    Short Essay:

    Designing a Healthcare Database

    Objective:

    You will apply concepts from Chapter 9 Database Design by writing a short essay (34 well-developed paragraphs) on designing a database for an Electronic Health Record (EHR) system in a multi-site healthcare organization.

    Assignment Prompt:

    A large healthcare system with multiple hospitals and outpatient clinics is transitioning from a paper-based system to a modern Electronic Health Record (EHR) system. As a database designer, you must determine the best approach for structuring the database to ensure data consistency, accessibility, security, and efficiency.

    In your essay, address the following:

    1. Database Design Approach: Would you use a top-down or bottom-up approach for designing the database? Explain your choice and its benefits.

    2. Database Structure: Should the system use a centralized or decentralized database? Justify your decision based on data integrity, accessibility, and performance.

    3. Implementation Considerations: Briefly explain how the Systems Development Life Cycle (SDLC) and Database Life Cycle (DBLC) would guide the successful design, implementation, and maintenance of the database.

    Formatting Requirements:

  • Length: 34 well-developed paragraphs
  • Font: 12-point Times New Roman or Arial
  • Spacing: Double-spaced
  • Citations: Include references if applicable

    • Grading Criteria:

  • Clarity & Organization (30%) Essay is well-structured, with logical flow between ideas.
  • Application of Concepts (40%) Demonstrates understanding of database design, SDLC, and DBLC.
  • Justification & Critical Thinking (30%) Provides strong reasoning for design choices

  • Databases Question

    check the file

    Requirements: as long as the answer

  • Lab 4: Student Information System (SIS) – database

    Lab 4: Student Information System (SIS) – database

    Student Information System (SIS) – Database

    Tasks

    Scenario (People / Tech / Process / Data)

    • People: students, faculty, registrar, IT support
    • Tech: simple web portal + SQLite database (Software DB Browser for SQLite )
    • Process: enroll, drop, grade submission
    • Data: student profiles, faculty profiles, courses, seats/capacity, enrollments, grades

    What your SIS must do

    • Add Students
    • Add Faculty
    • Add Courses (with a capacity and a faculty teacher)
    • Student can Enroll in a course
    • Student can Drop a course
    • Faculty can Submit Grades
    • Reports:
      • Seats remaining per course
      • Student transcript (courses + grades)

    Constraints

    • Use a primary key for each table
    • Use foreign keys to connect tables
    • Students Courses is many-to-many, so you must use a bridge table (Enrollments)
    • Prevent duplicate enrollments in the same term

    Tips

    Step 1) Identify Entities (Tables)

    Step 2) Relationship Types (1:M and M:N)

    Step 3) Choose Primary Keys + Foreign Keys

    Step 4) Add a Rule to Prevent Duplicate Enrollment

    Requirements: database

  • you can expect: A high quality explanation and answer with i…

    You can expect a high-quality explanation and answer within your time limit, along with quick and responsive communication. All responses will be original, clearly explained, and supported with cited resources when needed. To receive the best help, provide detailed information about your question. If it involves coding, include the programming language, version, compiler, and any libraries or tools you are using.

    Requirements:

  • EXCEL WORK

    Requirements: 2 PAGES | Assembly Language

  • DATANALTICS

    Download the attached test file WITHOUT changing the file name. [To download, click on the 3 horizontal dots to the right of the file name.] Using File Explorer, right click on the file name, select Properties and Unblock it.

    • Open the file in Excel
    • The password to open the file is start (lowercase letters).
    • Click Enable Editing and then Enable Content to allow the macro to run.
    • Click the Click Here button to start your test.
    • SAVE your test file often WITHOUT changing the file name, preferably after the completion of each of the 10 questions. The questions are shown on the INSTRUCTIONS worksheet.
    • Do NOT CLOSE your file until you are finished the test; once you close your file you will be unable to open it again.
    • Upload your completed file in the space below called Additional Content by clicking on the paper clip icon. The test will AutoSubmit after 90 minutes, with or without your attached test file, so budget your time to allow time for uploading.

    Requirements: 11

  • Generate Multi-Table Query Statements to Address Health-Rela…

    Assignment Instructions

  • You must incorporate confirmatory work screenshots into a Microsoft Word assignment document (or equivalent). The following image illustrates an example problem screenshot showing both the SQL statement and confirmatory execution results:

    Confirmatory screenshots are needed to show that the required coursework was performed.

    Problem 1: List the active ingredients for each of the vaccines. Show the full vaccine name in the query output in alphabetical order. (Hint: The IngredientType attribute denotes whether an ingredient is active or inactive.)

    Expected Output:

    Image presents the expected output for the Problem 1 query.

    Problem 2: List the states/jurisdictions and reported COVID deaths on October 31, 2020 for states/jurisdictions with a population exceeding 10,000,000. The output needs to show the full state/jurisdiction names (not the abbreviations).

    Expected Output:

    Image presents the expected output for the Problem 2 query.

    Problem 3: Which states/jurisdictions had one or more reported COVID cases on February 29, 2020? Show the full state/jurisdiction names and number of reported COVID cases in the query output. Show the output in alphabetical order by full state/jurisdiction name (not the abbreviations).

    Expected Output:

    Image presents the expected output for the Problem 3 query.

    Problem 4: Show the calendar dates and reported daily COVID-19 deaths exceeding 100 for New York and California in the month of March 2020. Display the full state/jurisdiction names in the query output. Present the query results in chronological order (i.e., oldest to latest calendar dates).

    Expected Output:

    Image presents the expected output for the Problem 4 query.

    Problem 5: List the average daily reported COVID case values for Georgia, Florida, and Alabama for the time period between December 1, 2020 and December 31, 2020. Present the full state name and average values in the query output. Group the results by full state name in alphabetical order.

    Expected Output:

    Image presents the expected output for the Problem 5 query.

    Problem 6: List the full vaccine and state/jurisdiction names for vaccines administered on December 30, 2020. Show the reported number of doses administered in the query output. Sort the output in alphabetical order by full vaccine name and then by full state/jurisdiction name.

    Expected Output:

    Image presents the expected output for the Problem 6 query.

    Problem 7: Show the total reported COVID-19 cases exceeding 2,000,000 per state/jurisdiction in the 2021 calendar year. Display the full state/jurisdiction names in the query output. Group the results by full state/jurisdiction name. Present the results in alphabetical order by full state/jurisdiction name. (Hint: GROUP BY and HAVING clauses are required for this query.)

    Expected Output:

    Image presents the expected output for the Problem 7 query.

    Problem 8: Show the full vaccine names and dose volumes for the adult second dose series. Display the results in alphabetical order by full vaccine name. (Hint: Permissible attribute values for BIT data types are ‘TRUE’ and ‘FALSE’.)

    Expected Output:

    Image presents the expected output for the Problem 8 query.

    Problem 9: Show the full vaccine names and dose volumes for the adult second dose series. Display the results in alphabetical order by full vaccine name. (Hint: Permissible attribute values for BIT data types are ‘TRUE’ and ‘FALSE’.)

    Expected Output:

    Image presents the expected output for the Problem 9 query.

    Problem 10: Estimate the number of reported COVID-19 cases per 1,000 people in 2021 for Florida, New York, California, Texas, and Michigan. Group and sort the results by full state/jurisdiction name in alphabetical order. The calculation is performed via the following equation:

    COVID-19 Cases/1,000 people = SUM(Daily Reported COVID-19 Cases * 1000 / Population)

    Expected Output:

    Image presents the expected output for the Problem 10 query.

    Requirements: few pages

  • Data anltics

    Case 5 Assignment

    1. Municipal budgets are required by provincial law to balance cities must take in enough revenue through property taxes and other sources, like fees for services, to finance all of the citys operations in any given year. You have been hired by the to help prepare next year’s 2020 operating budget. Your starting point is to review the , conveniently in the format of an Excel worksheet, and review the revenues and expenses of each city program. The proposed increases are outlined in the Excel case file.When finished reading the case background, select True and move to the next question.

      True or

      False

    Case 6 Assignment

    Question 2

    0 Points

    Question 2

    As recreational and medicinal marijuana use becomes increasingly legal and destigmatized worldwide, many growers of cannabis are prioritizing ways to make their operations more efficient.

    Large-scale indoor marijuana cultivation puts a tremendous strain on the energy grid, requiring power-hungry equipment such as indoor lighting, irrigation, fans, humidifiers and more, often running around the clock. Solar panels, therefore, can be a valuable investment for marijuana growers. Though solar energy can represent a significant upfront investment for your business, it can pay for itself in both the short-term and the long run by allowing you to reduce or even eliminate some of your energy consumption.

    This case is about a cannibus business considering the purchase of solar panels to replace 100% of their it’s hydro usage. Details related to costs are presented in the Excel case file.

    When finished reading the case background, select True and move to the next question.

    True

    False

    These Assigment has Case 5 and Case 6 there are Both files do the diffrent and both of them have marcos enabled so write My name both Files Maaz Hafeji

    Requirements: 11

  • Data Naltics

    Case 5 Assignment

    1. Municipal budgets are required by provincial law to balance cities must take in enough revenue through property taxes and other sources, like fees for services, to finance all of the citys operations in any given year. You have been hired by the to help prepare next year’s 2020 operating budget. Your starting point is to review the , conveniently in the format of an Excel worksheet, and review the revenues and expenses of each city program. The proposed increases are outlined in the Excel case file.When finished reading the case background, select True and move to the next question.

      True or

      False

    Case 6 Assignment

    Question 2

    0 Points

    Question 2

    As recreational and medicinal marijuana use becomes increasingly legal and destigmatized worldwide, many growers of cannabis are prioritizing ways to make their operations more efficient.

    Large-scale indoor marijuana cultivation puts a tremendous strain on the energy grid, requiring power-hungry equipment such as indoor lighting, irrigation, fans, humidifiers and more, often running around the clock. Solar panels, therefore, can be a valuable investment for marijuana growers. Though solar energy can represent a significant upfront investment for your business, it can pay for itself in both the short-term and the long run by allowing you to reduce or even eliminate some of your energy consumption.

    This case is about a cannibus business considering the purchase of solar panels to replace 100% of their it’s hydro usage. Details related to costs are presented in the Excel case file.

    When finished reading the case background, select True and move to the next question.

    True

    False

    These Assigment has Case 5 and Case 6 there are Both files do the diffrent and both of them have marcos enabled so write My name both Files Maaz Hafeji

    Requirements: 11

  • Databases Question

    Case 5 Assigment and

    Case 6 Assignment

    Requirements: 11