Pt2520 Homework 1

In: Computers and Technology

Submitted By TLee
Words 305
Pages 2
Unit 1 True/False Questions
Indicate whether the following statements are true or false on the student answer sheet.

1) At its simplest, a database can be seen as a collection of related data.

2) A delimited file is a file where the length of the file is limited.

3) A delimited file is one in which the data is separated by a character such as a comma.

4) All fixed length files are of the same length.

5) In relational databases, logical design is kept separate from physical design.

6) A hierarchical database is designed with a tree-like structure that resembles a file system.

7) Codd defined the core principles of a relational database in 1970.

8) Data redundancy improves the integrity of a database.

9) In a diagram, crows feet notation conveys more information about the relationships.

10) A primary key uniquely identifies each row in a database table.

11) In a relational database, all data is kept in tables, even the information about the tables.

12) SQL is the language used by relational databases to create objects and to manipulate and retrieve data.

13) An entity is someone who is interested in the database.

14) In a statement of scope, a constraint is a limit on what the database will do.

15) Oracle is a popular relational database management system.

16) A relational database management system does not include tools for backing up and restoring databases.

17) Documentation is not an important part of database development.

18) In a statement of work, the objective section describes how the proposed new database is meant to serve.

19) It is important to document both the design of the database and the process by which it was developed.

20) The most popular database in the last 30 years has been the relational database.…...

Similar Documents

Pt2520 Unit 1 Research Assignment

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

Words: 358 - Pages: 2

Pt2520 Homework 1

...Unit 1 True/False Questions Indicate whether the following statements are true or false on the student answer sheet. 1) At its simplest, a database can be seen as a collection of related data. 2) A delimited file is a file where the length of the file is limited. 3) A delimited file is one in which the data is separated by a character such as a comma. 4) All fixed length files are of the same length. 5) In relational databases, logical design is kept separate from physical design. 6) A hierarchical database is designed with a tree-like structure that resembles a file system. 7) Codd defined the core principles of a relational database in 1970. 8) Data redundancy improves the integrity of a database. 9) In a diagram, crows feet notation conveys more information about the relationships. 10) A primary key uniquely identifies each row in a database table. 11) In a relational database, all data is kept in tables, even the information about the tables. 12) SQL is the language used by relational databases to create objects and to manipulate and retrieve data. 13) An entity is someone who is interested in the database. 14) In a statement of scope, a constraint is a limit on what the database will do. 15) Oracle is a popular relational database management system. 16) A relational database management system does not include tools for backing up and restoring databases. 17) Documentation is not an important part of database......

Words: 305 - Pages: 2

Pt2520-Unit 1 Research-Exploring Programming Language

...Unit 1 Research Assignment 1: Exploring Programming Language Structured Query Language (SQL) is a specialized language for updating, deleting, and requesting information from databases. SQL is an ANSI and ISO standard, and is the de facto database query language. A variety of established database products support SQL, including products from Oracle and Microsoft SQL Server. It is widely used in both industry and academia, often for enormous, complex datbases. (Base, 2013). 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 Standardization (ISO) standards. (Inc., 2013) Although IBM authored SQL, the first SQL implementation was provided by Oracle Corporation (then called Relational Software Inc.). Early commercial implementations were concentrated on midsized UNIX-based DBMSs, such as Oracle, Ingres, and Informix. IBM followed in 1981 with SQL/DS, the forerunner to DB2, which debuted in 1983. (Unknown, 2010) ANSI published the first SQL standard (SQL-86) in 1986. An international version of the standard issued by ISO appeared in 1987. A significant update to SQL-86 was released in 1989 (SQL-89). Virtually, all relational DBMSs that you encounter today support most of the 1986 standard. (Unknown, 2010) In 1992, the standard was revised again (SQL-92), adding...

Words: 802 - Pages: 4

Homework 1

...1. - What industry standards body and standards series numbers do you need to reference for Ethernet applications and cabling? A- The IEEE is use as the standard for Ethernet applications and cabling. It is part of the 802.3 series of standards and includes applications such as 1000Base-T, 1000Base-SX, 10GBase-T and 10GBase-SR 2. - What are the different types of category 6 cable and what should be recommended for this network? A- There are two types of 6 cable, Cat-6 and Cat-6a I would recommend a Cat-6a for this network, since its intended use is for 10 Gigabit Ethernet with a 500MHz bandwidth support. 3. - What cable would you recommend to offer the best shielding performance? A- I would recommend a Cat-6a (STP cable) for this project. My recommendation is based on this cable capability to protect the network from EMI and to operate at 10GBase-T. 4. - What type of cable would you use for: 4.1 The horizontal spaces? A- Riser-rated cabling is more durable. However, for this project I would recommend a plenum cabling system to prevent toxic fumes if caught on fire. The client is planning to route the cable thought the same space used for air circulation and HVAC. 4.2 The vertical links? A- I would recommend implementing a riser-rated cabling to avoid fire to be spread between floors. “Plenum rated cables can be used in the riser, BUT riser cables cannot be used in Plenum spaces” (PowerPoint presentation in our 1st class). 5. - What would you look for...

Words: 418 - Pages: 2

Homework 1

...!Billion! $10.85!Billion! !!Enterprise!Value !!Equity!Value! $!11.05!Billion! $10.34!Billion! !!Equity!Value !!Implied!Price! !$137.34! $128.43! !!Purchase!Price! !!Current!Share!Price! !$104.61! $104.61! !!Price!Premium 31.29%( 22.77%( !!IRR !!Price!Premium! $!11.15!Billion $!11.23!Billion $!10.52!Billion $!10.61!Billion !$130.76! !$131.81! 25%! 26%! (16% 18%( Conclusion:! • Equity!Price!Range:! $10.34!Billion!–!$11.57! Billion! • Stock!Price!Range:! $128.43!–!$137.34!! •  Sources!and!Uses! USES((in(million) Repay!O/S!Debt Purchase!Equity Transaction!Costs Total!Uses 12,129 Earn!Out! 9%! Cash!on!B/S! 7%! Issue!Debt! 33%! SOURCES Equity!Roll! Over! 18%! New!Equity! 33%! ! ! MERGERS&AND&ACQUISITIONS&–&FINAL&PROJECT& ! 1& Appendix( Table(I:(DCF(Analysis(without(Synergy(–(BCR( INCOME(STATEMENT(ANNUAL(($(IN(MILLION)( Revenues( ( Cost(of(Good(Sold( ( ( Gross(Profit( ( Operating(Expenses( SG&A( ( Research(and(development(Expense( ( Other(Expense(/((Income)([(Net( Operating(Income(/((Loss)( ( Operating!Margin!%! yoy%! yoy%! ! ! yoy%! ! %Revenues! yoy%! ! %Revenues! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! %!Revenue! ! ! ! FY10A( 2,720! ! ! 1,020! ! 37.5%! ! 1,700! ! 62.5%! ! 760! ! ! 185! ! ! 25! ! 730! ! 26.9%! 105! ! 51! ! 1.88%! 0.5x! FY11A( 2,896! ! 6.48%! 1,097! ! 37.9%! 7.58%! 1,799! ! 62.1%! ! 795! ! 4.58%! 185! ! 0.00%! 272! ! 547! ! 18.9%! 115! ! 71! ! 2.47%! 0.6x! FY12A( 2,958! ! 2.13%! 1,125! ! 38.0%! 2.55%! 1,833! ! 61.9%! ! 817! !......

Words: 4550 - Pages: 19

Homework-1

...Homework -1 Everest University Professor: Dr. Stephen Tvorik Business Policy and Strategy. 18th Jan 2014 Abstract In this topic I Explain about the two different part one I explain about the pitfall because of the uncertainty and the other thing is unpredictability. If you are the new consultant in the company you have to take care of the point very carefully. I also explain about the scenario planning in the strategic planning. It is also very important in the strategic planning. I also explain about the cognitive biases and decision making process. In this manager are making a rules and regulation some time it’s not work because of that failure happen in the organization. I also explain about the different characteristic for him or her to follow and measure in organization. The power full leader having a always good mission and they always follow the motivation and different characteristic. Identify at least two potential planning pitfalls and two potential cognitive biases facing the company. Explain how each could result in poor strategy. If Company hires me as a consultant, I have to think about the long term goals for the company and then I have to find the best way to achieving those goals. In strategic planning mission, external and internal environment are the main point to over all organization planning. Some time because of the poor planning or do not plan for uncertainty strategic planning will be going to fail. This is the main point for pitfall...

Words: 940 - Pages: 4

Pt2520 Unit 1 Exploring Programming Languages

... | 1994 | Parallel database server technology is shipped commercially | 1995 | Open source MySQL first released | 1996 | Standard API for OLAP database access and OLAP benchmark is published | 1997 | IBM DB2 UDB unifies DB2 architecture across IBM and other vendor platforms | 1997 | Major DBMS vendors announce Java integration strategies | 1998 | Microsoft SQL Server 7 provides enterprise-level database support for Windows NT | 1998 | Oracle 8i provides database/Internet integration and moves away from client/server model | 1998 | Commercial in-memory database products are shipped for the first time | 1999 | J2EE standardizes JDBC database access from application servers | 1999 | ANSI/ISO SQL:1999 standard ratified, adding object-oriented constructs into the language | 2000 | Oracle introduces application servers with integrated database caching | 2000 | Microsoft introduces SQL Server 2000, aimed at enterprise applications | 2001 | XML integration capabilities appear in mainstream RDBMS products | 2001 | IBM acquires Informix database business | 2002 | Gartner ranks IBM as #1 database vendor, passing Oracle | 2003 | ANSI/ISO SQL:2003 ratified, adding SQL/XML | 2006 | ANSI/ISO SQL:2006 ratified, significantly expanding SQL/XML and object-oriented constructs | 2006 | IDC and Gartner studies show Oracle leading in market share | 2008 | MySQL AB acquired by Sun Microsystems | 2008 | ANSI/ISO SQL:2008 ratified | When things evolve, so do......

Words: 1281 - Pages: 6

Pt2520 Unit 1

...Unit 1 Research Assignment | Exploring Programming Languages | Cody Tidwell | PT2520 1.) Edgar Frank “Ted” Codd was a mathematician and also a computer scientist who never stopped believing. Going for his doctorate on a scholarship from IBM, his determination was proven to many. Once he finished his Ph.D., he worked for IBM where his work truly began to take off. He was the one proposed a set of “12 Rules”, which there are actually 13 when you include the 0). In SQL Server 2012 Service Pack 1 Cumulative Update 4, it expands the supported features for SQL Server backup and restores with Windows Azure Storage. In this release, new Powershell cmdlets have been added. MICROSOFT EXPRESS FEATURES 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 Admin Connection-Import/Export Wizard ORACLE EXPRESS FEATURES Interactive reports Declarative BLOB support Enhanced report printing Adding to the theme repository Optional runtime-only installation Improved security Application date format Application builder refinements DB2 EXPRESS FEATURES Bi-temporal data management Always on transactions Enhanced......

Words: 316 - Pages: 2

Unit 1 Lab 1.1 - 1.4 Pt2520

...Mark Henry Salvador PT2520 Nyguen Unit 1 Lab 1.2 Nouns | Major Topics | Doctors | Each doctor must have their own database for their own patients. | Patients | Each patient will require a database of information (depression state, eating, sleeping, physical and internal problems) for each time they visit twice a month for 18 months. | Drugs | Will need a way to see which patients will receive the drug and the traditional drug. | Supervisor/Researchers | Keep track of every drug that is being hand out. Researchers will need a way to keep data into a neat database so that they can see every bit of information that is required including doctor notes and which drug is being given to each patient. | Mark Henry Salvador PT2520 Nyguen Unit 1 Lab 1.3 Major Topics Requirement to track its software Licensing scheme Installation and uninstallation of software Must have a copy of software available If it must be purchased, it has to be bought History: Law requires that any business, including a school, track its software. It is important to know what software the school owns, in what versions, and what the license agreement for that software is. Scope: A database will insure that you have information on important legal and personal documentation of accounts. Objective: Create a way to track the software that is currently being installed, uninstalled and bought for faculty, staff computers, and software. Preliminary Timeline: 1st week: Figure out......

Words: 339 - Pages: 2

Homework #1

...Homework assignment #1 Homework assignment #1 Michael Sterner Michael_lee_sterner@yahoo.com Content Introduction…………………………………………………………………………...page 2 Question 1 ……………………………….………………….………………………… page Question 2 ……………………………….………………….………………………… page Question 3 ……………………………….………………….………………………… page Conclusion………………………………………………………………………....... page References………………………………………………………………………....... page Homework assignment#1 Hello my name is Michael Sterner and I am writing a essay to day to answer some questions on a few topics about our economy. The purpose of this paper is to answer 3 questions about (1)Which economic system is best suited for handling a crisis of epic proportions (hurricane, flood, blizzard, forest fire, etc.)? Why? (2) Describe and explain why a socialist system might be the best in responding to the needs of people struck by an emergency situation like the earthquake that occurred in Haiti in January 2010? And finally (3) Use the laws of supply and demand to explain why the cost to heat our homes and businesses goes up in the winter time. Be sure to explain your answer fully? Q1: Which economic system is best suited for handling a crisis of epic proportions (hurricane, flood, blizzard, forest fire, etc.)? Why? The Socialism system seems to offer the best resolution for controlling emergency situations. Socialism, in its perfect form, would be the best economic system to assist people because...

Words: 410 - Pages: 2

Pt2520 Unit 1 Assignment 1

...Mike Garrison 12/15/14 PT2520 Unit 1 True or False 1) At its simplest, a database can be seen as a collection of related data. TRUE 2) A delimited file is a file where the length of the file is limited. FALSE 3) A delimited file is one in which the data is separated by a character such as a comma. TRUE 4) Al fixed length files are of the same length. TRUE 5) In relational databases, logical design is kept separate from physical design. TRUE 6) A hierarchical database is designed with a tre-like structure that resembles a file system. TRUE 7) Cod defined the core principles of a relational database in 1970. TRUE 8) Data redundancy improves the integrity of a database. FALSE 9) In a diagram, crows fet notation conveys more information about The relationships. TRUE 10) A primary key uniquely identifes each row in a database table. TRUE 11) In a relational database, alL data is kept in tables, even the information about the tables. TRUE 12) SQL is the language used by relational databases to create objects and to manipulate and retrieve data. TRUE 13) An entiy is someone who is interested in the database. FALSE 14) In a statement of scope, a constraint is a limit on what he database wil do. TRUE 15) Oracle is a popular relational database management system. TRUE 16) A relational database management system does not include tools for backing up and restoring databases. FALSE 17) Documentation is not an important part of database development. FALSE 18) In a......

Words: 316 - Pages: 2

Pt2520 Unit 5 Assignment 1,Unit 5 Research Paper 1 and Quiz 4

...Lab 5.1 Unit 5 Assignment 1 1) Choosing a database management system requires a great deal of analysis. TRUE 2) When choosing a database management system, you should consider system compatibility and hardware requirements. TRUE 3) Only insert and update statements are part of a database transaction. FALSE 4) Physical design is independent of any particular database management system. FALSE 5) A data type is a column specification that determines what kind of data can be stored in it. TRUE 6) Int, decimal and money are character numeric types. TRUE 7) Char and NChar are variable-length character types. FALSE 8) Varchar and NVarchar are variable length character types. TRUE 9) NChar and NVarchar are based on the unicode character set. TRUE 10) Unicode is an expanded character set that contains non-Latin characters. TRUE 11) A null is the same as a 0 or an empty string. FALSE 12) You should not allow nulls in columns that are critical to your business rules. TRUE 13) Tables can only be created by SQL statements in SQL Server. FALSE 14) Referential integrity exists when every foreign key relates to a primary key. TRUE 15) When referential integrity is in effect, you cannot delete a record in the primary key table until you have first deleted all the related records in the foreign key table. TRUE 16) When referential integrity is in effect, you can only enter records in the foreign key side of the relation if it relates directly to a record in the primary key...

Words: 1792 - Pages: 8

Homework 1

... In this homework, you will design a program to perform the following task:  Calculate the usable area in square feet of house.  Assume that the house has a maximum of four rooms, and that each room is rectangular.  There are 4 components of your submission including: * Program Description- A detailed, clear description of the program you are building. * Analysis-  Demonstrates your thought process and steps used to analyze the problem. Be sure to include the required input and output and how you will obtain the required output from the given input? Also, include your variable names and definitions. Be sure to describe the necessary formulas and sample calculations that might be needed. * Test plan - Prepare at least 3 sets of input data (Test data) along with their expected output for testing your program.  Your test data can be presented in the form of a table as follows (note: feel free to adapt to your design) * Pseudocode- Provide pseudocode of your overall design that fulfills the requirements of the project All of these components can be placed in word document.   Example application test data: Test Case # | Input | Expected Output | 1 | Room1: length=10, width=14; Room 2: length=9, width=10; Room 3: length=12, width=12; | 374 square feet | 2 | Your room dimensions | Your output | 3 | Your room dimensions | Your output | Submission requirements: Your completed assignment should be saved as Word document and submitted to your assignment area no later......

Words: 320 - Pages: 2

Homework 1

...Susan Turner Homework # 1 1. The free cash flow for 2014 is $373,584 using the EBDA model which states that EBDA = net income + depreciation + amortization. The free cash flow for 2014 is $453,584 using the EBITDA model which states that EBITDA = net income + interest + depreciation + amortization. 2. If depreciation doubled taxable income would fall and taxes would be decreased. So your net income would decrease but net cash flow would increase. 3. The quick ratio for 2014 is .9. Quick ratio = ( current assets – inventories)/ current liabilities. Quick ratio = ( 2,680,112 – 1,716,480)/ 1,039,800 = .9. The current ratio for 2014 is 2.5. Current ratio = current assets/ current liabilities 2,680,112 / 1,039,800 = 2.5. The higher the current ratio the more capable the company is of paying its obligations as it has a larger proportion of asset value relative to the value of its liabilities. The higher the quick ratio the better the company’s liquidity position. The company’s liquidity position in 2013 was very low when compared to 2012 and 2014 and against the industry average. 4. ROE = (net income / pretax profit) x ( pretax profit / EBIT) x (EBIT / sales) x (sales / assets) x (assets / equity). ROE = (253,584 / 422,640) x ( 422,640 / 502, 640) x (502,640 / 7,035,600) x (7,035,600 / 2,680,112) x (2,680,112 / 1,977,152). ROE = .6 x .8408403629 x .0714423788 x 2.6251141743 x 1.3555417085. ROE = .1282572104 or 12.8%. The firms major strengths are its sales and......

Words: 271 - Pages: 2

Pt2520

... object would be represented in a database application as a(n) _____. entity 47. SQL is a(n) _____. query language 48. SQL stands for ______. standard query language The two broad categories of DBMS are ______ and ______. enterprise; personal UML stands for ________. unified modeling language Users access databases through a(n) ______. database application program What are crow's feet? shorthand for multiple lines showing relations between two entities in an E-R diagram When transforming a data model into a database design, designers represent relationships by ______. using the entity identifier 38. 39. 40. 41. 42. 43. 44. 45. 46. 49. 50. 51. 52. 53. 55. 56. 57. 58. 59. 60. https://www.coursehero.com/file/10350813/PT2520-Final-Review/ Powered by TCPDF (www.tcpdf.org) 54. Which of the following is false regarding the process of creating the database? database developers use metadata to create tables, relationships, and other structures in the database Which of the following is not an example of a database project? Ubuntu Which of the following is not part of the database development process? an external verification agency validates the data model Which of the following is true of N:M relationships? more than one entity is allowed on each side of the relationship Which of the following is true of the database development process? changing a relationship from 1:N to N:M is simply a matter of changing the notations Which of the......

Words: 1054 - Pages: 5