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

  • 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

    Define database architecture. Consider Microsoft® Access®, Microsoft® SQL Server®, Oracle®, and IBM DB2® software as possible examples.…

    • 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
  • Good Essays

    PT2520 Unit 1 Research Assignment
    • 452 Words
    • 2 Pages

    PT2520 Unit 1 Research Assignment

    Major commercial database developers have set a trend of offering “Express” versions of their databases. Companies such as Microsoft, Oracle and IBM DB2 are a part of this trend setting. Microsoft has a program called SQL Express which has the following features; SQL Server Configuration Manager, Replication, Advanced Query Optimizer, SMO/RMO, Sqlcmd, and Integration with Visual Studio 2005. SQL Express all has snapshot isolation level features, Native XML support, SQL language support-Multiple Active Result Sets (MARS), and Dedicated Admin Connection-Import/Export Wizard. These features are different than that of Oracles express version. Some of the software limitations include a 1GB maximum memory, the maximum size of each relational database.…

    • 452 Words
    • 2 Pages
    Good 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

    Pt1420 Unit 2 Research Assignment
    • 878 Words
    • 4 Pages

    Pt1420 Unit 2 Research Assignment

    Some similarities in these programs are that there are specific words you cannot use in each language. These words are generally reserved for some other part of the language and if the is not some kind of distinction between the words this will cause an error. Though these languages have minor similarities they differ in the same way, some are case sensitive while others are not. They also say that most variables should begin with a letter but in two of these programs they can begin with an underscore and in Java you can use a dollar sign as well. Another key difference is the length of the variable name, in Visual Basic you are limited to a length of 255 characters while the other two have no restrictions on length. So for each language there are minor similarities and differences but in order to program in any of these languages you must know these rules in order to prevent errors from…

    • 878 Words
    • 4 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 1 Research Assignment 1: Exploring Programming Languages
    • 612 Words
    • 3 Pages

    Unit 1 Research Assignment 1: Exploring Programming Languages

    Structured Query Language (SQL) is a standard database computer language used for querying, modifying and managing data in Relational Database Management Systems (RDBMS). SQL was developed in the 1970's by IBM to initially manipulate and retrieve data in IBM System R. The SQL language was standardized in 1986 by the American National Standards Institute (ANSI); however, later releases were released as International Organization for Standardization (ISO) standards.…

    • 612 Words
    • 3 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
  • 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

    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
  • 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