Preview

Unit 1 Research Assignment 1

Satisfactory Essays
Open Document
Open Document
327 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Unit 1 Research Assignment 1
Unit 1 Research Assignment 1: Exploring Programming Languages
Learning Objectives and Outcomes
Describe the role of software for computers.
Identify the hardware associated with a computer.
Describe how computers store data.
Explain how programs work.
Differentiate among machine language, assembly language, and high-level languages.
Differentiate between compilers and interpreters.
Identify the different types of software.

Assignment Requirements
Use the Internet and the ITT Tech Virtual Library to research the following questions:
1. Look up the history of SQL. How many revisions of the standard have there been?
Year 1986 SQL-86, Year 1989 SQL-89, Year 1992 QSQL-92, Year 1999 SQL:1999, Year 2003 SQL:2003, Year 2006 SQL:2006, Year 2008 SQL:2008, Year 2011 SQL:2011. What was added in the most recent one?
SQL:2011

2. A recent trend for major commercial database developers is to offer free “Express” versions of their databases. Microsoft has SQL Express, Oracle has Oracle Express, and DB2 has DB2 Express. Go to the company websites, and look up these Express editions.
What features does Oracle Express have?
New features include: Application Builder for mobile, Mobile and responsive themes, HTML5 Item types, Mobile Calendars, Packaged Applications, RESTful Web services.
What limits does Oracle Express have?
Limits: Poor Basic replication regarding integration, Oracle real application testing, Enterprise Manager, Automatic Storage Management, Java Support, Temporal Database,SQL Pattern matching, Flashback Data archive, Data Masking, Application Security, Secure Application roles, and Proxy Authentication.
How do they compare to each other?
DB2 Express-C
*Cores: 2
*Memory: 16GB
*Size: 15 Terabytes of user data per Database
Oracle Express
*Cores: 1
*Memory: 1GB
*Size: 11GB
SQL Server Express
*Cores: 4
*Memory: 1GB
*Size: 10GB

Required Resources
Textbook
ITT Tech Virtual Library: http://library.itt-tech.edu

Submission Requirements
Submit your written answers
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Powerful Essays

    Unit 7 P3 Research Paper
    • 1234 Words
    • 5 Pages

    Unit 7 P3 Research Paper

    Virus protection – virus protection protects a computer system from malicious viruses and Trojans and worms which you can be infected by through the internet or email or downloading files or through a USB flash drive etc. virus protection usually consists of a firewall, virus scanner, virus remover and spyware. With virus protection you can perform a scan on your computer to check if you have been infected by any viruses or Trojans or worms. With some virus protections software’s you can scan your computer then it will ask you if you want the viruses removed, also if any programs have been infected the virus protection will ask you if you want the infected program deleted, most virus…

    • 1234 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Pt1420 Unit 2 Research Assignment 1
    • 333 Words
    • 2 Pages

    Pt1420 Unit 2 Research Assignment 1

    For Visual Basic a variable’s name must have a letter as the first character, you cannot use spaces, periods, or other special characters such as !@#. The name cannot exceed 255 characters. The variable should not have a similar name as the functions, statements, and methods, and the name cannot be repeated within the scope. This language is not case sensitive.…

    • 333 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    DBM 380 Week 4 Individual Paper Normalization of the ERD
    • 644 Words
    • 4 Pages

    DBM 380 Week 4 Individual Paper Normalization of the ERD

    Reflect on the textbook readings. Using the search strings listed in the Electronic Reserve Readings for Week one search for additional information on database systems. What information would your provide to an organization or your employer on why database systems should be used?…

    • 644 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Eng110 Unit 3 Assignment
    • 1079 Words
    • 5 Pages

    Eng110 Unit 3 Assignment

    M is off center and above eye level in the shot as well as the little girls reflection in the mirror.…

    • 1079 Words
    • 5 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    PT1420 Unit 2 Research Assignment 1
    • 218 Words
    • 1 Page

    PT1420 Unit 2 Research Assignment 1

    Similarities in the languages are that their variables should be made up of Alphanumeric characters. Another similarity is they should refrain from using most symbols. A third similarity is each has reserved words that the language uses for its own purposes.…

    • 218 Words
    • 1 Page
    Satisfactory Essays
    Read More
  • Good Essays

    Pt1420 Unit 10 Research Paper
    • 559 Words
    • 3 Pages

    Pt1420 Unit 10 Research Paper

    A1: Applet is a type of Java program that runs on web browser. It can be a fully functional Java application because it has full Java API…

    • 559 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    pt2520 assignment 1
    • 466 Words
    • 2 Pages

    pt2520 assignment 1

    Let’s get the definition out the way, the standard meaning if you will SQL or “sequel” to some is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS). Now that we got that out the way, let’s get to the first question.…

    • 466 Words
    • 2 Pages
    Good Essays
    Read More
  • Powerful Essays

    Unit 4 Assignment 2
    • 717 Words
    • 3 Pages

    Unit 4 Assignment 2

    The purpose of this policy is to define standards for connecting to Richman investment’s network from any host. These standards are designed to minimize the potential exposure to Richman investments from damages which may result from unauthorized use of Richman investments resources. Damages include the loss of sensitive or company confidential data, intellectual property, damage to public image, damage to critical Richman investments internal systems, etc.…

    • 717 Words
    • 3 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Unit 2 Assignment 1: Homework
    • 848 Words
    • 4 Pages

    Unit 2 Assignment 1: Homework

    User-friendly is a term used in the software development to describe programs that are easy to use.…

    • 848 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    UNIT 2 HOMEWORK 2012
    • 908 Words
    • 4 Pages

    UNIT 2 HOMEWORK 2012

    16. What were the colonies expected to do according to mercantilist doctrine? (Ch. 3, pgs. 72-73)…

    • 908 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Unit 7 Research Assignment 1
    • 240 Words
    • 1 Page

    Unit 7 Research Assignment 1

    Procedural language is a type of computer programming language that specifies a series of well-structured steps and procedures within its programming context to compose a program. It contains a systematic order of statements, functions and commands to complete a computational task or program. It is also known as imperative language. Advantages of procedural language is easy to read program code, easy maintainable program code as various procedures can be debugged in isolation, and code is more flexible as you can change a specific procedure that gets implemented across the program.…

    • 240 Words
    • 1 Page
    Satisfactory Essays
    Read More
  • Powerful Essays

    unit 3 assignment 4
    • 4187 Words
    • 14 Pages

    unit 3 assignment 4

    It is not only individuals in the consumer marketplace that have the potential to buy, as buyers also exist in the business to business market. B2B markets are individuals that have the responsibility of purchasing on behalf of the business. Cadbury have both individual and business to business consumers. They trade with all major supermarkets and superstores, but also sell to local and private shops. This way they can broaden their distribution and reach customers and consumers everywhere.…

    • 4187 Words
    • 14 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    information systems plan for seminole industries research project
    • 5678 Words
    • 23 Pages

    information systems plan for seminole industries research project

    References: (1) Information technology in business: Let me count the ways. (1992). CIO, , 1-1. Retrieved from…

    • 5678 Words
    • 23 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Sql-Cheat-Sheet
    • 360 Words
    • 2 Pages

    Sql-Cheat-Sheet

           SQL Facts SQL stands for Structured Query Language SQL is pronounced “sequel” SQL is declarative language SQL is used to access & manipulate data in databases Top SQL DBs are MS SQL Server, Oracle, DB2, and MySQL Database Definitions RDBMS (Relational Database Management System) – Software that stores and manipulates data arranged in relational database tables.…

    • 360 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Open Sourse
    • 377 Words
    • 2 Pages

    Open Sourse

    Oracle, software downloads are free, and most come with a DL that allows you to use full versions of the products at no charge while developing and prototyping your applications, or for strictly self-educational purposes. Database Servers offer:…

    • 377 Words
    • 2 Pages
    Good Essays
    Read More

Related Topics