Database

Need Help in Database Assignment?
We can help you if you are having difficulty with your Database Assignment. Just email your Database Assignment at admin@assignmentcache.com.
We provide help for students all over the world in Database Assignment.

Items 11 to 20 of 204 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5

Grid  List 

Set Ascending Direction
  1. DBM 502 Week 2 Huffman Trucking Virtual Organization ERD

    DBM 502 Week 2 Data Architecture ERD

    Regular Price: $15.00

    Special Price: $12.00

    Individual Assignment: ERD and Table Specifications Resources: Huffman Trucking Virtual Organization

    Review the information currently housed in Huffman Trucking’s database, in the Entities and Attributes for Fleet Truck Maintenance file on the virtual Organizations site.

    Create a Microsoft® Visio® Logical ERD, based on the Entities and Attributes for Fleet Truck Maintenance document, and any additional information needed to normalize the database.

    Ensure that your entities are properly normalized. Properly annotate the entities, primary keys, foreign keys, and relationships in your ERD. All relationships should be one-to-many. Use the crow’s feet notation for your ERD. Every entity should be related to at least one other entity.

    Create table design metadata specifications in a Microsoft® Excel® spreadsheet based on your ERD. Indicate primary keys, foreign keys, and new attributes as in the entity relationship diagram.

    For each table in your metadata, indicate the table’s name, the columns in the table, the data types for the columns, the sizes of the columns, the primary keys, the foreign keys, the required/NOT NULL columns, the default values, and the range of legal values for the columns. Learn More
  2. DBM/502 Week 3 sql statements and screenchot

    DBM 502 Week 3 Data Population, Manipulation, and Retrieval

    Regular Price: $15.00

    Special Price: $12.00

    Individual Assignment Database Creation and Reporting

    Resources: The entity relationship diagram and normalized table specifications from the Week Two individual assignment, SQL Server® and Reporting Services on the Toolwire® site, and Beginning Microsoft® SQL Server® 2008 Programming

    Based on your Week #2 IA’s table design metadata, program your own SQL statements using SQL Server’s Management Studio to create, populate, and query a relational database for the Huffman Trucking’s fleet truck maintenance application.

    (3 points) Use CREATE TABLE statements to create a table for each entity for Huffman Trucking’s fleet truck maintenance database.

    (2 points) Use INSERT statements to populate the tables with realistic sample data. Include at least 2 rows for each table.

    (2.5 points; 0.5 point each) Use a separate SELECT statement to create each of the following queries:

    • A simple query for each table that returns all of the columns and all of the rows for each table.

    • A query that displays each part that has been purchased by Huffman Trucking Company. For each part, also retrieve its parts catalog information from the parts catalog table and vendor information from the vendor table.

    • A query that displays all of the rows in the vehicle maintenance table. For each vehicle maintenance row, join the corresponding information from the maintenance descriptions table and vehicles table.

    • A query that displays each row in the maintenance work order table. For each row in the maintenance work order table, join the corresponding information from the maintenance description table.

    • A query that counts the number of maintenance work orders for each vehicle in the maintenance work order table. Display the vehicle column and the corresponding count of work orders for each vehicle.

    (2.5 points) Create a report using the SQL Server Business Intelligence Reporting Services of the parts purchasing history for Huffman Trucking Company. The report should display all parts purchasing history including manufacturer and vendor information, parts catalog information, and associated parts inventory issues, and all parts inventory purchases.

    Format the report to present to senior management at Huffman Trucking.

    Place screen snapshots of all of the above SQL statements as they executed in SQL Server Management Studio showing the SQL statements and the results returned, as well as a screen snapshot of your Reporting Services report, showing your actual data, into a single Word or .pdf file Learn More
  3. DBM 502 Week 4 Data Warehouses BI Presentation

    DBM 502 Week 4 Data Warehouses BI Presentation

    Regular Price: $15.00

    Special Price: $12.00

    Individual Assignment BI Presentation

    Resources: Huffman Trucking in the Virtual Organizations; the entity relationship diagram, tables, and sample database from the Week Two and Week Three individual assignments

    Prepare a Microsoft PowerPoint Presentation for senior management at Huffman Trucking explaining how integrating the fleet truck maintenance information into the corporate data warehouse will support organizational goals.

    Explain how business intelligence may improve efficiencies and fleet performance.

    Provide a detailed example of a data-mining technique or application and how it will provide information useful to management.

    · Describe a data-mining technique from Table 9-4 of Modern Database Management or a data-mining application from Table 9-5 of Modern Database Management.

    · Identify a specific use of this data-mining tool with the information from the sample database from the Week Four individual assignment.

    · Identify the attributes that this data-mining tool will access.

    · Explain how the information gathered using this data-mining tool will support Huffman Trucking’s organizational goals.

    Support your arguments with at least four peer-reviewed or industry publications.

    Present your recommendation in a 6- to 8-slide Microsoft® PowerPoint® presentation. Keep your slides uncluttered with at most 5 bullets and 7 words per bullet. Your must include speaker notes in your presentation. Learn More
  4. DBM381 Week 1 Health Care Paper

    DBM 381 Week 1 Database Architecture in Health Care Paper

    Regular Price: $15.00

    Special Price: $12.00

    Individual Database Paper
    Write a 700- to 1,050-word paper in which you do the following:
    · Define health care database systems. Describe how databases are used across the health care industry.
    · Explain the different database architectures including the relational architecture.
    Describe the needs of database users across the health care continuum.
    Format your paper consistent with APA standards. Learn More
  5. DBM 381 Week 2 Database Design memo

    DBM 381 Week 2 Database Design in Health Care

    Regular Price: $20.00

    Special Price: $15.00

    Individual Paper and Database
    Complete Service Request SR-ta-001: Scheduling System Database.
    Note. This course utilizes the Virtual Organizations, an Apollo Group, Inc. learning tool. The Virtual Organizations portal is accessed from the link on your course materials page.
    Write a 300- to 350-word memo to the Technical Services/Logistics Manager at Taylor Ambulance explaining the following(5 pts)
    · The design you will use
    · How your electronic solution will cover their needs from a management perspective
    Create a Microsoft® Access® database using the Entities and Attributes document provided with the Service Request. Include the following(8 pts):
    · Tables with appropriate data types and keys
    · Descriptions
    · Format
    · Masking
    Submit the memo and Microsoft® Access® database file to your facilitator. Learn More
  6. DBM 381 Week 3 Normalization Memo

    DBM 381 Week 3 Normalization Memo and Relationships

    Regular Price: $20.00

    Special Price: $15.00

    Individual Memo and Relationships

    Update the detailed ERD created during Week Two to normalize it to the third normal form.

    Write a 300- to 350-word memo to your client that explains the level of normalization and explain why that level is sufficient for this system.

    Update the Microsoft® Access® database created during Week Two. Assign appropriate keys and relationships among tables established using the Relationships Tool. Once the database has been created, add relevant data to each table, at least 10 records for each.
    Submit the ERD, memo, and Microsoft® Access® database file to your facilitator. Learn More
  7. DBM 381 Week 4 Data Collection Standards Memo

    DBM 381 Week 4 Database Management in Health Care

    Regular Price: $20.00

    Special Price: $15.00

    Individual Data Collection Standards Memo and Form/Report/Queries

    Write a 700- to 1,050-word memo to Taylor Ambulance explaining data collection standards used in the health care industry(7 pts)

    Create two forms within the Microsoft® Access® database used in Week Three to capture data(4 pts). Please use the most relevant/important tables in the design. One of the forms should include an incorporated sub form.

    Create two reports within the Microsoft® Access® database used in Week Three that shows information that management at Taylor Ambulance might want to see as they manage their business. One of the reports should include an incorporated sub report. (4 pts).
    Submit your memo and Microsoft® Access® database file to your facilitator Learn More
  8. DBM 502 Week 5 Mountain View Community Hospital Case Study

    DBM/502 Week 5 Data and Database Administration

    Regular Price: $20.00

    Special Price: $15.00

    Individual Assignment Database Paper

    Choose one of the following assignment options to complete:

    Option 1: Data Governance, Quality, Integration, and Security in your organization

    Review data management and information security practices where you work or at an organization with which you are familiar.

    Recommend three specific policy changes to improve data governance, quality, integration, and security.

    Support each recommendation with evidence from at least two scholarly or trade publications.

    Option 2: Mountain View Community Hospital Case Study

    Review the Case sections of Ch. 10 and Ch. 11 in Modern Database Management.

    Analyze the data governance, quality, integration, and security at Mountain View Community Hospital.

    Address the strengths and opportunities for improvement in data management and security. Support your arguments with evidence from scholarly or trade publications.

    For either option chosen, write a 1,050- to 1,400-word paper consistent with APA guidelines. Learn More
  9. DBM 380 Week 2 Database Environment Paper

    DBM/380 Week 2 Database Design

    Regular Price: $15.00

    Special Price: $12.00

    Individual Database Environment Paper

    Write a 750- to 1,050-word paper in which you complete the following:

    · Choose a database environment from the following:

    o An appropriate database environment within your workplace (must be approved by your instructor)
    o An Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum
    o Smith Consulting (Virtual Organization) – needs a database to track their consulting staff, each staff member’s skill sets, and what projects they are working on

    · Analyze the database environment.
    · Describe the problems and constraints.
    · Describe the objectives of the database environment.
    · Describe the scope and boundaries.
    · List the data specifications (must include a minimum of three entities with attributes).

    Include 3 to 5 references.

    Format your paper consistent with APA guidelines.

    · Note. The database environment chosen will be used in the Weeks Three and Four Individual Assignments. Learn More
  10. DBM 380 Week 3 Art Museum Access Database

    DBM 380 Week 3 Entity Relationship Diagram

    Regular Price: $15.00

    Special Price: $12.00

    Individual ERD Creation Project

    The following assignment is based on the database environment chosen and discussed in the Week Two Individual Assignment.

    Use a Microsoft® Visio® diagram to create a detailed ERD using the data specifications noted in the Week Two Individual Assignment. Make any necessary changes provided in your faculty’s feedback.

    · Use a Microsoft® Access® database to create the preliminary database tables, columns with data types, primary keys, and relationships. Learn More

Items 11 to 20 of 204 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5

Grid  List 

Set Ascending Direction