All posts by : chebby

MySQL

MySQL is a database management system that allows you to manage relational databases. It is open source software backed by Oracle. It means you can use MySQL without paying a dime. Also, if you want, you can change its source code to suit your needs.

Even though MySQL is open source software, you can buy a commercial license version from Oracle to get premium support services.

MySQL is pretty easy to master in comparison with other database software like Oracle Database, or Microsoft SQL Server.

MySQL can run on various platforms UNIX, Linux, Windows, etc. You can install it on a server or even in a desktop. Besides, MySQL is reliable, scalable, and fast.

ABOUT THE MySQL FINAL

Use screen captures to document each step of the project. 

1.  Describe the requirements for a database that will support a small online business. Makeup a small business scenario or use a real-life scenario familiar to you.  In this section you should also try to formulate the queries that you that you want to write for the database.  

2.  Design the conceptual database behind the described requirements. This is the ER Diagram for the small database. 

3.  Convert the conceptual design to a physical design. This is translating the ER Diagram into the relational schema and metadata describing the tables, attributes and relationships. 

4.  Implement the Physical Database from the physical design. This is transposing the relational schema and metadata into the a series of CREATE TABLE statements with the appropriate CONSTRAINT modifiers. 

Here are some helpful hints to get started with your design 

You need to describe at least the following aspects of the Database:

1.  What products and/or services will the database hold, the categories of products/services, approximate number of product titles in each category, what (approximately) is the product information that the customers will be able to access 

2.  What information is need from the database

1.  Create the ER diagram from the information gathered in parts 1

2.  Write out the schema and metadata of the database, including: a.  All the database tables. 

The Metadata

For each table column please specify: the name and the type of the column, whether the value can be null or not, and whether the values are required to be unique.  

For each table please specify which column (or columns) forms its primary key.  

In the ER Diagram, show all relations between columns, specify the type of the relations (one-­‐to-­‐one or one-­‐to-­‐many), and what is the foreign key by which the tables are related.  You can do this in the diagram by placing an FK suffix at the end of the attribute that is a foreign key.  

A few things to keep in mind when creating and finalizing the design 

1.  Don’t try to be, too ambitious in planning your database.  As much as you would want to have a lot of features in your database, you have to keep in mind that they will be implemented later in the project! So please try to create a minimum design that will be easy to implement and test. 

You may need to reduce the scope of the project to get a working version completed.  In IT, if you cannot deliver a list of features within a given schedule, you have two choices. You can either reduce the features in order to deliver on time, or you can extend the time of the project. We are at the end of the semester, so we cannot extend the time, we can only reduce the activity in the project. In a Database Project, reducing the scope means removing tables, data, and queries from the project.  

1.  Create the database Container

2.  Create Entity Tables

3.  Create Relationship Tables

4.  Insert Test Data 

Designing the ER Diagram, creating the Relational Schema, creating the Metadata and inserting the Test Data is part of the group assignment. Once the database structure is created and the test data has been inserted, the projects turns into individual assignments.  Individually the group members of a group are to write queries to test separate segments of the database 

Project Overview 

As you create a Database to support sometime of business activities, create the ER 

Diagram, Relational Schema, Metadata and Test Data for the Database you have chosen.  Create the physical database in MySQL using the appropriate Create Database and Create Table DDL statements to create the database container and create the tables for the database.  Finally, insert the initial test data representing a current state of the test organization.  

Perform the following types of queries using tables of the segment of the database that you are testing in your database project. Practice Union, Intersection and Difference operations on one entity table in the database. For this part of the assignment, choose a single table from the entity tables of your database project to work with.  Merge two databases, a number of tests have to be performed on similar data sets from both databases.  Create a duplicate table to mirror the entity table you are testing. Insert a few rows from the test data of your entity table into the duplicate table mirroring it. You should then insert one or two unique rows into the duplicate table mirroring your entity table. Once you get this type of environment setup in your database for this assignment, you will be able to perform varying relational algebra operations. You will be able to perform an intersection finding common records in both tables. You will be able to perform a difference operation from both directions. You will be able to perform a Union combining both tables into one result set. That is exactly what you are to do:

Write a query that performs an intersection on you main table and your duplicate mirroring table 

Write a query that performs an Difference on you main table and your duplicate mirroring table 

Write a query that performs an Union on you main table and your duplicate mirroring table 

For the union, difference and intersect query, the other database table is a table structure made from the table that you have chosen to work with in your project.  It represents the data from another company merging with the data in your company.  

You are to write a query using your table and a table that it has a relationship with: 

Remember a relationship is established when two table share a common attribute. One is the primary key table the other is the foreign key table.  For the multi-­‐table select query, use the entity table as the one side of a 1-­‐M relationship.  Use one of the relationship tables created earlier as the many side of a 1-­‐M relationship.  

Create a query that will alter the structure of your entity table: 

Normally when integrating systems, there are a few data type compatibility issues and data alignment issues that need resolution.  To prepare for handling such problems, create an Alter Table command to demonstrate that you can handle these types of situations should they arise 

Write a query that will update a row in your entity table

To demonstrate that you have an understanding of update queries, create an update process to update one or more existing records in your chosen table.  This could be accomplished by populating the new attributes added to the table. The final project 

submission MUST inclue the following documents: 

1.  Copy of the ER Diagram and Schema that was used to develop the table 

2.  The Metadata for the database 

3.  The SQL script file to create the database, tables and insert the data 

4.  The SQL script file containing your individual queries

For help with installing, connecting and using MySQL, see the attached documents or click the following links:

https://www.mysqltutorial.org/install-mysql/
https://www.mysqltutorial.org/mysql-sample-database.aspx
https://www.mysqltutorial.org/how-to-load-sample-database-into-mysql-database-server.aspx

I want a case study research on ELITE EMERGENCY PHYSICIANS (FORMERLY KNOWN AS ELKHART EMERGENCY PHYSICIANS): 550,000 PATIENTS 

Conduct research to capture the organization’s infrastructure and processes and the threats to personal health information (PHI) and to determine a strategy to mitigate the threats you anticipate.

What changes are necessary to support the current times and future times of the uses of operating systems to allow a more consistent model across many different hardware platforms? 

Discussion 1.2

Due: Initial Post due Friday, Replies due Sunday

Discuss the needs for GIS. 

Discussion 2.1

Due: Initial Post due Friday, Replies due Sunday

How is GIS used in public health?

Exp19_Access_Ch09_CapAssessment – National Farm and Agriculture Conference 1.0

Project Description:

Your company handles room registration, speaker coordination, and other functions for national conferences that are held at your campus throughout the year. The sales department mails schedules to speakers and building coordinators. The speaker database was modified by unauthorized personnel, and some of the changes need to be reversed. For example, all of the relationships were deleted; they need to be recreated. You have been asked to analyze the database, fix the relationships, and make the database more secure to avoid this situation in the future. The database tables may already be normalized; however, you need to examine the tables to verify this.

Open   the downloaded Access file named Exp19_Access_Ch09_CapAssessment_National_Farm_and_Agriculture_Conference.accdb.   Grader has automatically added your last name to the beginning of the   filename.

Open   the Relationships window. Add the Presenters, ExhibitPresenter, Exhibits,   and Locations tables to the   layout.

Create   a relationship between the Exhibits   and ExhibitPresenter tables,   ensuring you check the Enforce   Referential Integrity and Cascade   Update Related Fields options.

Create   a relationship between the Exhibits   and Locations tables, ensuring you   check the Enforce Referential   Integrity and Cascade Update   Related Fields options.

Create   a relationship between the Presenters   and ExhibitPresenter tables,   ensuring you check the Enforce   Referential Integrity and Cascade   Update Related Fields options. Save, and close the Relationships window.

Open   the Performance Analyzer dialog   box and select all tables. You   should be given two ideas. You decide not to implement the changes; close the   Performance Analyzer. Open the Database Documenter tool. Check the Exhibits table, and set the options   so Properties, Relationships, and Permissions by User and Group are   set. Include Names, Data Types, and Sizes for fields, and Nothing   for Indexes. Close the Object   Definition report without saving.

Create   a new form using the Form tool   based on the Presenters table.   Save the form as Add or Edit Presenters and   close the form.

Create   a navigation form based on the Vertical   Tabs, Left template.

Add   the Add or Edit Presenters form to   the first position.

Add   the Current Presenter Schedule   report to the second position.

Add   the Locations report to the third   position.

Add   the Presenters report to the   fourth position. Save the Navigation form with the default name.

Set   the database to open the navigation form when the database opens.

Assigned Readings:

Chapter 7. Risk Management 

Initial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.

Also, provide a graduate-level response to each of the following questions:

1. Give some examples of projects using each of the risk mitigation strategies (accept, minimize, share, or transfer).  How successful were these strategies?  In hindsight, would another approach have been better?

 [Your initial post should be at least 450+ words and in APA format (including Times New Roman with font size 12 and double spaced). Post the actual body of your paper in the discussion thread then attach a Word-version of the paper for APA review]

Text-

Title: Project Management ISBN: 9780134730332 Authors: Pinto Publisher: Pearson Edition: 5TH 19 

1. Find a peer-reviewed scholarly journal article discussing electronic innovation and the government. Complete a review of the article by writing a 2-3 page overview of the article. This will be a detailed summary of the journal article, including concepts discussed and findings. Additionally, find one other source (it does not have to be a peer-reviewed journal article) that substantiates the findings in the article you are reviewing.
   You should use Google Scholar to find these types of articles.
   Once you find the article, you will read it and write a review of it.  This is considered a research article review.
   Your paper should meet these requirements: 
   • Be approximately four to six pages in length, not including the required cover page and reference page.
   • Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
   • Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. 
   • Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

 Case Project 5-2: Planning Folder Permissions (Pg. 241 of your text)
Up to this point, the college has used a relatively unplanned approach to folder permissions, sometimes using the default permissions on newly created folders. Now they have created a new committee to review security on the servers, and the committee is working to develop a specific policy for setting up NTFS folder permissions and share permissions. They have asked for your recommendations on the following types of folders:
• The Windows folder (which is not shared)
• Software application folders (which are not shared)
• Home folders for faculty and staff (which are not shared)
• Folders containing the college’s financial accounting databases (which are not shared and are used only by members of the Administrative Business Department)
• A shared folder containing electronic pages from the faculty and staff handbook (which is shared for faculty and staff use only)
• Shared folders used by instructors to provide students with class information and assignments If slide presentation software is available to you, such as PowerPoint, consider giving your response as a slide presentation. 

 Complete the following assignment in one MS word document: 

Chapter 3 –discussion question #1-4 & exercise 12

#1. How do you describe the importance of data in analytics? Can we think of analytics without data? Explain. 

#2. Considering the new and broad definition of business  analytics, what are the main inputs and outputs to the analytics continuum? 

#3. Where do the data for business analytics come from?  What are the sources and the nature of those incoming data? 

#4. What are the most common metrics that make for analytics-ready data? 

Exercise 12.   Go to data.gov—a U.S. government-sponsored data portal that has a very large number of data sets on a  wide variety of topics ranging from healthcare to education, climate to public safety. Pick a topic that you are most passionate about. Go through the topic-specific information and explanation provided on the site.  Explore the possibilities of downloading the data, and use your favorite data visualization tool to create your own meaningful information and visualizations. 

When submitting work, be sure to include in APA format and include at least two APA formatted references (and APA in-text citations) to support the work this week.
All work must be original (not copied from any source).

 Word document that is 4-5 pages (double-spaced) on a cybersecurity topic  (Cloud Security)