Database Concepts Unit1 Research

In: Computers and Technology

Submitted By DeathGuard
Words 357
Pages 2
1. After reviewing the history on SQL server, I have found that there have been 7 revisions of the SQL standard. In the most recent, SQL 2011, there were many new non-temporal features. You have DELETE in MERGE, Pipelined DML, CALL enhancements, Limited fetch capability, Collection type enhancements, non-enforced table constraints, and window enhancements. With SQL:2011 replacing SQL:2008 as the standard in December of 2011, there were also some new DDL features that improved the usability of generated and identity columns.

2. SQL Express allows certain features that are available in the regular edition. The following are major features that are supported in SQL Express: Stored Procedures, Views, Triggers, Cursors, sqlcmd and osql utilities, Snapshot Isolation levels, Native XML support (including XQuery and XML Schemas) Transact-SQL language support, and dedicated administrator connection. In Oracle Express, you are able to use a browser-based interface to administer the database, create tables, views, and other database objects, import, export, and view table data, run queries and SQL scripts, and generate reports. DB2 Express is a no-charge community edition of DB2 data server and is ideal for small businesses and multi-branch companies. It includes self-managing capabilities and includes all of the core features of the larger DB2 editions which include Data Studio, Time Travel Query, PureXML and compression backup. After looking over all of the specs of each of these programs, I believe that SQL and Oracle are the top two. When we look into the finer details of things, my personal preference would be to go with SQL Express as there are many reviews that support it.
Bibliography
IBM. (2012). DB2 Express. Retrieved September 2012, from http://www-01.ibm.com/software/data/db2/express/about.html
Microsoft. (2012). SQL Express. Retrieved September 2012, from…...

Similar Documents

Pt250 Database Concepts Unit 1 Research Assignment

...Unit 1 Research Assignment The History Of SQL SQL was created in 1970 by Dr. E. F. Codd. There have been three revisions of the standard and they are SQL99, SQL2003 and SQL2008. The Query was the most recent edition of SQL. Microsoft SQL 2010 Express Features 1. Simplify Development Efforts Leverage Existing Skills Get started today developing on SQL Server with SQL Server Data Tools. Take advantage of existing Transact-SQL skills, and incorporate technologies, including the Microsoft ADO.NET Entity Framework and LINQ. Develop applications faster through deep integration with Visual Studio, Visual Web Developer, and SQL Server Management Studio. Improve Developer Productivity Increase developer productivity and simplify deployment through integration with Visual Studio and Visual Web Developer. Take advantage of advanced capabilities, including rich table and query designers, full integration with Server Explorer, and drag-and-drop IDE support for rapidly building data-bound applications. Tune the Design Process Manage SQL Server 2012 Express databases with SQL Server Management Studio Express. Connect to local SQL Server 2012 Express databases and manage objects with full Object Explorer integration. Write, execute, and test queries by using visual query plans that provide hints to tune queries and access management and maintenance options. 2. Develop Sophisticated Applications Rapid data exploration & visualization Discover...

Words: 751 - Pages: 4

Database Concepts

...920 ALLEN 30 1840 WARD 30 1438 JONES 20 3421 MARTIN 30 1438 BLAKE 30 3278 CLARK 10 2818 SCOTT 20 3450 KING 10 5750 TURNER 30 1725 ADAMS 20 1265 JAMES 30 1093 FORD 20 3450 MILLER 10 1495 10. Select the name and department name of the employees who has the job as ‘manager’. Use the lower case value. SELECT ENAME, DNAME FROM EMP, DEPT WHERE EMP.DEPTNO=DEPT.DEPTNO AND LOWER(JOB) = 'manager'; ENAME DNAME ---------- -------------- JONES RESEARCH BLAKE SALES CLARK ACCOUNTING 11. List all employees who work in the same department as the PRESIDENT. select ename, deptno from emp where deptno = ( select deptno from emp where JOB = 'PRESIDENT'); ENAME DEPTNO ---------- ------ CLARK 10 KING 10 MILLER 10 12. List all employees who have the same job as SCOTT. SELECT ENAME, JOB FROM EMP WHERE JOB=(SELECT JOB FROM EMP WHERE ENAME='SCOTT'); ENAME JOB ---------- --------- SCOTT ANALYST FORD ANALYST 13. List all employees who have been hired since CLARK was hired. SELECT ENAME, HIREDATE FROM EMP WHERE HIREDATE>(SELECT HIREDATE FROM EMP WHERE ENAME='CLARK'); ENAME ......

Words: 2823 - Pages: 12

Database Concepts Research Paper

...Database concepts research assignment week 9 Don't use Personal Identifiable Information (PII) in your password such as, Name, User name, Birthday, Pet’s name or Child's name. Don't use any word that can be found in the dictionary as your full password. Don’t use the same password for online banking that you use for social networking or email. Don’t give your password to someone over the phone. Try to use special characters such as non-alphabetic characters. Try to create passwords at with at least eight characters. Try to use a password vault application to protect and help manage your many passwords. Try to change your most critical passwords on a regular basis. The Windows operating system already has authentication functionality built-in. It has to do so. And if you're in a domain environment, there are special computers, called Domain Controllers, where authentication actually takes place. Those systems tend to be treated more security than regular servers, even SQL Servers. And therefore, if the username/password combinations are going to be stored on the most secure systems in the domain, that would be on the domain controllers (as a side note, a hash is what is actually stored there, not the password itself). If you let Windows do the authentication, then SQL Server doesn't have to store anything related to a username/password combination. And it's up to Windows to check the security. In other words, SQL Server is handing off this sort of authentication to processes......

Words: 729 - Pages: 3

Database Concepts

...Mary Easterling Database Concepts Paper (Ch. 30 Web Technologies and DBMS) The internet or web was created in 1989, the internet grew into the powerful information exchange service that it is today. It has expanded the world at a pace that has astounded many experts in this new field. This new technology brought forth many new ideas for better, faster, easier ways to communication between the different computer formats, so the experts had get together and create a universal language that would be accepted with all computer hardware systems. Most web pages today are written in HTML, XML, JAVA, JavaScript are just a few examples. Websites now and in the past use the uniform resource locations (URL’s) to communicate inside the different browsers with the information or resources on a specific server. Without these locations, the information cannot be found or accessed, for example, to access Google.com, the browser needs to break down the information into an address to continue, and if the address is incorrect or cannot be located it will return a page not found error. Hypertext markup language (HTML) is the most common language that spans across the different platforms. This language is pretty easy to learn using the free basic instructions available on the internet, and now most high schools teach HTML to their students so they can create their own webpage. Most personal webpages today are a great example of what is called a static web page. “An HTML document that......

Words: 517 - Pages: 3

Pt1420 Database Concepts

...data E 14. Downtime of customer database J Solutions or preventative actions: A. Enable content filtering and antivirus scanning at the entry and exit points of the Internet. Enable workstation auto-scans and auto-quarantine for unknown file types. B. Apply file transfer monitoring, scanning, and alarming for unknown file types and sources. C. Place employee on probation, review acceptable use policy (AUP) and employee manual, and discuss status during performance reviews. D. Apply filters on exterior Internet Protocol (IP) stateful firewalls and IP router WAN interfaces. E. Implement daily data backups and off-site data storage for monthly data archiving. Define data recovery procedures based on defined Recovery Time Objectives (RTOs). F. Define vulnerability window policies, standards, procedures, and guidelines. Conduct LAN domain vulnerability assessments. G. Apply real-time lockout procedures. H. Define a strict zero-day vulnerability window definition. Update devices with security fixes and software patches right away. I. Track and monitor abnormal employee behavior, erratic job performance, and use of IT infrastructure during off-hours. Begin IT access control lockout procedures based on AUP monitoring and compliance. J. Develop a disaster recovery plan (DRP) specific to the recovery of mission-critical applications and data to maintain operations. K. Encrypt all confidential data in the database or hard drive. L. Use workstation......

Words: 479 - Pages: 2

Research Database

...Research Database Assignment Form Describe briefly your topic of interest (15 possible points): According to the American Diabetes Association (2013), "There are 25.8 million people in the United States, or 8.3% of the population, who have diabetes". The amount of cases of adolescents with Type 1 diabetes, previously known as juvenile diabetes is multiplying. Lack of compliance in diabetes can lead to serious complications, such as blindness, kidney damage, cardiovascular disease, neuropathy and foot ulcers, but people with diabetes can lower the occurrence of these and other diabetes complications by controlling blood glucose, blood pressure, and blood lipids by eating properly, exercising, and following the treatment regimen. My topic is on compliance issues with the adolescent with Type 1 Diabetes; parental support and involvement and influences from peers. #1 Database (or collection) (30 possible points): Title of source: Academic Search Complete Location of source (URL): http://www.ebscohost.com/academic/academic-search-complete Owner or publisher: EBSCO Host Describe (in your own words) the research database or collection of research including the purpose and the subject matter it covers: This database is the world's most comprehensive, scholarly full-text academic journals for multidisciplinary research that is offered by most institutions, which grants free access. Membership required for full text. The amplitude of content enclosed in this resource......

Words: 1267 - Pages: 6

Database Concept

...plans it well. The implementation should to be put in the right place. System implementation efforts offer extraordinary challenges to information technology professionals and the organizations impacted by the implementations. A successful implementation can reap vast rewards in organizational strengths and efficiencies. A failure can drain an organization of people, funds and vitality. Therefore, many people have been affected for reasons of success and failure experienced with the implementation. based on this case study rapid-implementation period of nine months to be implemented when the implementation of this system can be carried out as planned. The step of planning was: - 1. Interaction of technology and organization - a broad concept that laid the foundation for many other factors to consider. 2. User involvement and participation - is influenced by several variables that need to be carefully balanced to ensure a successful engagement. 3. Resistance - can work for or against the project depends on how it is managed. 4. Commitment - an important factor in the success but, as it involves various powers including the human soul (behaviour), it is a challenge to achieve and maintain. 5. Planning - more that can be controlled by project managers from other success factors and involves a lot of critical components. 6. Risk - inherent in each project, but can be expected and achieved success....

Words: 809 - Pages: 4

Database Concepts Unit 1

...1. 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 each one have? What limits do they have? How do they compare to each other? The features are: SQL Server Express supports most of the features and functionality of SQL Server. The following table lists some of the major features and components that are supported. Stored Procedures SQL Server Configuration Manager Views Replication (as a subscriber only) Triggers Advanced Query Optimizer Cursors SMO/RMO sqlcmd and osql utilities Integration with Visual Studio 2005 Snapshot Isolation Levels Service Broker (as a client only)¹ Native XML support, including XQuery and XML Schemas SQL CLR Transact-SQL language support Multiple Active Result Sets (MARS) Dedicated Administrator Connection² Import/Export Wizard The limits are: The following table lists the additional SQL Server database features that are not supported in this version of SQL Server Express. It also lists database features from previous versions of SQL Server that are not supported. SQL Server features not supported in SQL Server Express SQL Server features from previous versions not supported in SQL Server Express Database mirroring SQL Mail Online restore Fail-over clustering Database snapshot Distributed partitioned......

Words: 376 - Pages: 2

Pt2520 Database Concepts

...List the major topics for this database. The major topics of the database are: Lease Form (tracks leases of one apartment complex); Rent Payment Form (tracks rent payment of one apartment complex); Maintenance Request Form (tracks requests for maintenance and apartment manager’s resolution); Sample Quarterly Report (shows revenues and expenses of a particular building, address). STATEMENT OF WORK Project Name: Wild Wood Apartments June 21, 2014 • History: The Wild Wood Apartments are made up of 20 different complexes in Washington, Oregon, California and Idaho with each complex containing from 10 to 60 separate apartments. Leases are from 6 months to a year and the company’s practice is to hire one of the tenants to run the complex, collecting rent, conducting repairs, etc. The company requires a quarterly report to track the lease occupancy, rent payment, maintenance, and revenue and expenses; all of which is done in paper form. The forms are considered time consuming by the property managers, and the corporate office has concerns over their accuracy. A centralized database is being considered to simplify and better manage this data. • Scope: The contractor will include hardware, website, software and data storage support for the headquarters and all property offices that belong to Wild Wood Apartments. The main storage for the data will be offsite and the contractor is responsible for maintaining it. • Constraints: The contractor and the headquarters office of Wild...

Words: 706 - Pages: 3

Database Concepts Research Assignment

...Addison Huggins Unit 4 Research assignment 1 July 24, 2014 The definition of Functional dependency is when one attribute in a relation uniquely determines another attribute. This can be written A -> B which would be the same as stating "B is functionally dependent upon A." While I was looking online for a good example of Functional dependency I came across one, the example comes from the website. http://databases.about.com/cs/specificproducts/g/functdep.htm in this example and I quote ” In a table listing employee characteristics including Social Security Number (SSN) and name, it can be said that name is functionally dependent upon SSN (or SSN -> name) because an employee's name can be uniquely determined from their SSN. However, the reverse statement (name -> SSN) is not true because more than one employee can have the same name but different SSNs.” Transitive dependency occurs when there is an indirect relationship that causes a functional dependency. While looking this up on the internet, it is hard to find a good example but in time I did. The example comes from http://databases.about.com/od/specificproducts/g/transitive-dependency.htm and from the website the example is and I quote “”A -> C” is a transitive dependency when it is true only because both “A -> B” and “B -> C” are true.” Demoralization is a strategy that database managers use to increase performance in their database. This is used to reduce certain types of problems that might......

Words: 267 - Pages: 2

Database Management Concepts

...DATABASE MANAGEMENT CONCEPTS 1. The DBA asks for your help in planning the data archive for the following Premiere Products database:     Rep (RepNum, LastName, FirstName, Street, City, State, Zip, Commission, Rate)     Customer (CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum)     Orders (OrderNum, OrderDate, CustomerNum)     OrderLine (OrderNum, PartNum, NumOrdered, QuotedPrice)     Part (PartNum, Description, OnHand, Class, Warehouse, Price) Determine which data from the database to archive; that is, for each table, specify whether data needs to be archived. If it does, specify which data, when it should be archived, and whether it should be archived with data from another table. 2. The DBA denormalized some of the data in the Premiere Products database to improve performance, and one of the resulting tables is the following: Customer (CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum, RepName) Which field or fields cause the table to no longer be in third normal form? In which normal form is the denormalized table? 3. Does your school have a formal disaster recovery plan? If it does, describe the general steps in the plan. If it does not, describe the informal steps that would be taken if a disaster occurred. For the following exercises, you will answer problems and questions from management at Premiere Products. You do not use the Premiere Products database for any of these......

Words: 471 - Pages: 2

Dbm 380 - Database Concepts

...DBM 380 FULL COURSE http://www.learnyourcourse.com/dbm-380/98-dbm-380-full-course.html DBM 380 WEEK 1 DBM 380 Week 1 DQ # 1- Based on the Manegold (2009) article, describe one method of optimizing data retrieval from a high-use database. (There are many such methods mentioned in the article - pick one you like and do a deep dive.) DBM 380 Week 1 DQ # 2- In the course text, there is some discussion of the capabilities of databases, and recognition of these as an evolution beyond file-based storage approaches. Spreadsheets are one example of a file-based approach. What kinds of things can database management systems do that spreadsheets can't? Also, why is it that in spite of the many apparent data management advantages of databases, spreadsheets are frequently used for data storage in all kinds of organizations? DBM 380 WEEK 2 DBM 380 Week 2 Individual Assignment - Database Design Paper DBM 380 Week 2 DQ # 1- Using the Geiger (2009) article as a guide, how must a database administrator balance the time to complete data modeling step with the benefits this step offers in creating a database? DBM 380 Week 2 DQ # 2- What are the issues identified in the Cox (2009) article that a database administrator should know when working with a many-to-many relationship? Identify and discuss one of these issues. DBM 380 WEEK 3 DBM 380 Week 3 Individual Assignment - ERD Creation Project DBM 380 Week 3 DQ # 1- Why do you think the use of icons in entity-relationship diagrams as......

Words: 481 - Pages: 2

Database Concepts

...Database Concepts David Emersion DBM380 6/29/2015 Wade Fergus Database Concepts In an age when information is power, each business in the market place must make use of every tool at its disposal. Efficiency is the hallmark of any successful business. For a business to be efficient it must be the master of managing its own information. Time is money, and using an ineffective information management system is simply money down the drain. Quick access to accurate information is crucial to an organization’s success. Fortunately, businesses have a powerful weapon at their disposal – databases. Database Systems Every organization from small non-profit teams up to huge corporations supporting millions of customers must keep records of different types of data. These data can vary from inventory prices, to payroll, to medical records, and everything in between. The common challenges that these organizations face is keeping the data accurate, relatively easy to use, and secure. The solution to this problem is to use a database that fits the needs of the organization. A database is a system that houses data and metadata. Metadata is the information about the data and includes “information such as the name of each data element, the type of values (numeric, dates, or text) stored on each data element, and whether the data element can be left empty” (Coronel, Morris, & Rob, 2013, p. 7). A database system......

Words: 578 - Pages: 3

Database Concepts

...Database Systems DBM/380 July 13, 2015 James Cervi Database Systems When it is necessary to store and manage data, a database is used. A database is a collection of data organized in such a way that it can be easily stored, managed, and manipulated. “You can think of a database as an electronic filing system” (QuinStreet Inc, 2015). It is safe to assume that a large percentage of organizations use databases for managing the wide array of data within their company. Databases can keep track of data such as: employee records, consumer demographic and contact information, and company files. A database management system (DBMS) is the software that controls the movement of data in and out of the database, as well as within the database. While a database management system refers to the software used to control the data, the database refers to the body of data being stored. Types of databases can be classified in numerous ways. They can be classified by the user, such as: desktop database meant for a single user, or a work-group database meant for multi-users. There is also an enterprise database which is used by an entire organization. Databases can be categorized by location. A centralized database manages data at a single site, whereas a distributed database manages data in multiple locations. Another way of categorizing databases is by the type of data that is being stored. “General-purpose databases contain a wide variety of data used in multiple disciplines” (Coronel,...

Words: 913 - Pages: 4

Database Concepts

...Huffman Trucking needs a better way to track the maintenance on their fleet of tractors, trailer and the roll-on/roll-offs. The fleet has to undergo periodic maintenance. Plan Putting the equipment's maintenance history, the parts used and vendor information into one database will save Huffman Trucking time and money. The database can include parts inventory information, parts catalogue information, the vendors used and their associated information, and parts purchasing history. The database will include all the maintenance history on each piece of equipment, such as the maintenance of the equipment itself, tire maintenance, the type of maintenance and the maintenance work orders. Conclusion Building a database saves money on maintenance by reducing redundant information and improving record keeping. Both the service and accounting departments will be able to utilize this database to keep track of parts purchases and costs. Having all the information in one central database would allow the diverse facilities to use the database. This type of centralization would bring more accuracy in Huffman Trucking's record keeping and would save money, time and manpower. Huffman Trucking Fleet Maintenance Database Solution Introduction Huffman Trucking is a privately held national transportation company with just under 1,400 employees and facilities across the United States. Huffman Trucking has benefited from a relationship with US Government that started in the late......

Words: 1795 - Pages: 8

Logan Marshall-Green | No Game No Life: Zero Subtitle Indonesia | Watch Movie