SQL-Concepts-and-Database-Design-computer-science-homework-help

Assignment 6: SQL Concepts and Database Design

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.

Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in preparing the documentation of the organization’s sales database. You are asked to propose a data dictionary that can be used to document the following:

  • Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID)
  • Invoice (InvNumber, InvDate, EmpNumber,  InvAmount, CustomerID)
  • InvoiceLine (InvLineNumber, InvNumber,  ProductNumber, Quantity)
  • Product (ProductNumber, ProductDescription, ProductCost)
  • Department (DepartmentID, DepartmentDescription)
  • Job (JobID, JobDescription)
  • Customer (CustomerID, CustomerName, CustomerAddress, CustomerPhone)

Write a three to four (3-4) page paper in which you:

  1. Create a data dictionary that includes the following:
    1. A description of the content for each field
    2. The data type of each field
    3. The format the data will be stored as in the field
    4. The range of value for the field
    5. A label, as required, if the attribute is a primary key or foreign key

Note: An example is shown in Table 7.3 in chapter 7 of the textbook.

  1. Imagine that you are asked to identify the number of days that exist between the first invoice and last invoice for each month and complete the following:
    1. Construct a query that will show the number of days that exist between the first invoice and last invoice, for each month, for each employee, using the DATEDIFF function. Be sure to provide the SQL script that will carry out this function.
    2. Construct a query to show the expected payment date if invoices are due within 30 days of transaction. 
    3. Construct a query that will show distinct area codes of the customers.
  2. Create a plan of the necessary activities that would be required to implement a valid database design process by including the following:
    1. Steps in the conceptual design stage
    2. Steps in DBMS selection stage
    3. Steps in logical design stage
    4. Steps in physical design stage
    5. Task details of each activity within each stage

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

  • Design a relational database so that it is at least in 3NF.
  • Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.
  • Explain the key principles of data security and identify data security risk and violations in data management system design.
  • Use technology and information resources to research issues in the strategic implications and management of database systems.
  • Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

discuss-greenhouse-visit-250-300-words-writing-homework-help

Students should write 250-300 words explaining what they learned at the greenhouse last week. Discuss what you learned, how this relates to community service, what you can do to help, and how the greenhouse impacts the George Mason campus.

We went to the greenhouse in gmu and meet two ladies there work in the greenhouse since it is start we clean with them

1.  We walk to from the classes to the greenhouse

2.  They teach us about the greenhouse

This greenhouse is also a symbol of an environmentally friendly facility since we use biological control against plant pests, such as lady beetles to control mealy bugs. In the near future, Marcelli plans to use Nematodes to control fungus and gnats, and parasitic wasps to control whiteflies.

The greenhouse has also provided plants to other institutions. Tobacco plants were given to the greenhouse manager of the George Washington University, and tomato plants were also given to the Insect Zoo at the Smithsonian Museum of Natural History.

no plorgasim   

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

The-investment-trade-idea-assignment-help-

The investment / trade idea itself is very open ended. You just need to highlight:

Return – what’s my thesis – how do I win?

Risk – what disproves my thesis – how do I lose?

Holding period which matches thesis.

Position (i.e. long vs. short).

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Java-Programming-write-a-java-program-to-enter-demographic-information

Urgent – please be thorough and USE the grading rubric and follow the example provided but be creative

SHOW – all work, extensive comments, discussion of run time error etc…

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Prepare-Resume-and-cover-letter-English-homework-help

Prepare Resume and cover letter in word  follow as same as  image format through below attachment

My details are in below attached word file

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

write-a-story-with-required-vocabs-English-homework-help

11 Vocabulary Words

  1. Books have indexes. The index has terms listed (most often alphabetically), with a page number or pointer to where the term is located in the book. This is a good way to understand indexes in general—they never lose this fundamental structure.
  2. tag cloud is a list (or visual array) of terms with hyperlinks to the places the terms are used.
  3. An index has an alphabetically or numerically sorted list of terms or phrases with links to the information described by those terms.
  4. Some words, called stop words, are excluded by search engines like Google from their index (for example, “the,” “and,” “is”, etc.). The assumption is that these words are not essential and will not make a difference in the results you want.
  5. The Google index is known by other terms as well, including reverseindex, full-text index, inverted index, etc.
  6. Google has editorial policies that are run not by humans but automatically by computer algorithms. The algorithms do things like checking that your page isn’t on a list of pages that contain pirated information.
  7. The processing of following Web links is called spidering or crawling.
  8. Starting on any dot in a network diagram and following all its links, as long as the entire network is connected, will eventually lead you to every node. Similarly, if I started at any person connected to you through other people on a social network, I could get to you eventually. This type of connection is sometimes referred to as “six degrees of separation” phenomenon.
  9. The program Google uses to perform this function of crawling the Web is called a spider, a crawler or also a bot—it follows these links automatically.
  10. In computer jargon, a cache is a place where you store information temporarily. It is not the original that is stored, but a copy for temporary use.
  11. Google’s index is a reverse or full-text index. It includes all the words on a page and only the words on a page.
Instructions

By now you should be pretty familiar with the vocab words of this module. So, you should be able to use them properly and creatively

  1. Read over the vocabulary words one more time
  2. Compose and type in a story that shows you really understand each of the words
    • Be creative but be sure what you type shows you understand (not just can type) the words
    • Use all the vocabulary words
    • Type them exactly as they are typed above (same pluralization, capitalization, tense, etc.
  3. Get an Eval for your story. For the best Eval
    • Use all the words
    • Make sure you use the words in a way that really shows you understand them

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Born-or-Made-That-Way-Jason-Case-Study-law-homework-help

Born or Made That Way? Jason Case Study

In this assignment, you will be using the DSM-5 (link given in the resources), which provides descriptions of psychiatric conditions, including criteria for determining whether a condition exists and treatment recommendations, as well as other details.

http://dsm.psychiatryonline.org.library.capella.edu/doi/book/10.1176/appi.books.9780890425596

Note: You may review the document Accessing the DSM-5 and the Mental Measurement Yearbook (given in the resources) to understand how to access the DSM-5 in the Capella library.

For this assignment, you will review the media Jason’s Case Study as a focus, as you start to develop you own premises of how you would explain criminal behavior.

https://media.capella.edu/CourseMedia/PSYC3130/Jason-CaseStudy/media.asp

Instructions

After reviewing the media Jason’s Case Study, access the DSM-5 and read about the following:

·  Affective disorder. For example, depressive and bipolar disorders. Is Jason’s difficulty self-regulating, a biological condition, or a learned behavior?

·  Substance abuse. For example, is Jason’s drug use indicative of a disease model or is it socially influenced?

·  Anxiety. For example, is Jason dealing with a neurochemical or hormonal imbalance, or is it a learned behavior or a behavior modification, or is there some secondary gain for Jason?

·  Psychotic disorders. For example, does Jason experience thought distortion or difficulty with reality testing?

In your paper:

·  Analyze the case study in terms of the psychology described in the DSM-5. Note: Choose only one of the disorders listed that you think is most closely related to Jason’s case. Through your analysis of Jason’s case study and your reading in the DSM-5, describe how he meets the criteria of the disorder you have chosen. Remember, a disorder is based on time, duration, intensity, and the degree to which it interferes with everyday functioning (social, interpersonal, work, and patterns in relationships) and not just the observable behavior.

·  Determine social factors (for example, parenting styles, rejection by loved ones, lack of limits, et cetera) that impact Jason’s behavior (for example, his bullying, lying, and drug use).

·  Describe what you have found in the case that is relevant for a court case for either the defense or the prosecution. Without considering establishing competency or sanity, reflect on the implications of what you have seen in the DSM-5 and the case study in terms of criminal justice for Jason.

Other Requirements

·  APA formatting:. 3-4 typed, double-spaced pages, not including the title page or the references page.

References: A minimum of three references.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

What-causes-or-stimulates-a-volcanic-eruption-science-homework-help

What causes or stimulates a volcanic eruption? Please give extensive insight on what happens before, after, and during a volcanic eruption. Cite references.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Describe-the-gender-role-differences-and-how-they-impact-the-development-of-an-individual-s-personality-

 

Describe the gender role differences and how they impact the development of an individual’s personality. Justify how this information would be beneficial as you begin to use the assessment tools available to measure an individual’s personality.

After reviewing the many different assessment tools we have discussed throughout the course, identify the one you would use the most. Which theory is it related to?

Explain why you choose this method. Summarize the advantages to this technique/tool. Assess some of the challenges you may face using this tool and how you will overcome them.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

#NAME?

Q1 Visit stopbullying.gov and watch the videos featured on the “Kid Videos” page, located on the StopBullying.gov website. Describe three ways in which you could incorporate strategies to prevent bullying as part of your classroom management.

Q2 What are some ways that environment can affect a classroom and the learners within it? What techniques or strategies can be implemented to ensure all students’ needs are being met? How would you change the classroom environment if you faced an unruly class?

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.