Free Essay

Advanced Database

In: Computers and Technology

Submitted By blecaf
Words 418
Pages 2
Question
The following are column headings found in spreadsheets with the indicated name. Use these spreadsheets in answering the following questions. A. Name of Spreadsheet: EQUIPMENT Column Headings (Number, Description, AcquiationDate, AcquistionPrice) Question 1(the number of themes you think the spreadsheet includes with appropriate theme names) Ans: There should be one(1) THEME with the name “EQUIPMENT” all column headings are kind of similar to its theme. B. Name Of Spreadsheet: COMPANY Column Headings (Name, IndustryCode, GrossSales,OfficerName, OfficerTitle) Question 1 (the number of themes you think the spreadsheet includes with appropriate theme names Ans: There should be Two(2) THEMES with the names “COMPANY”, “OFFICER” Question 2: Breakup columns of Spreadsheets with more than one theme and fix them under a single theme. Assuming that the names of the companies are the same. The industry code can be an identifier.
|COMPANY |
|Name |*IndustryCode |GrossSales |

|Officer |
|OfficerName |OfficerTitle |*IndustryCode |

Question 3: Problem that would occur when updating and deleting data Ans: For example if the Company changes its Name. The OFFICER table also must be updated

C. Name Of Spreadsheet: COMPANY Column Headings (Name, IndustryCode, GrossSales,NameOfPresident) Question 1 (the number of themes you think the spreadsheet includes with appropriate theme names) Ans: There should be one(1) THEME with the name “COMPANY” D. Name Of Spreadsheet: COMPUTER Column Headings (Serial Number, Make, Model, DIsktype, DiskCapacity) Question 1 (the number of themes you think the spreadsheet includes with appropriate theme names) Ans: There should be one(1) THEME with the name “COMPUTER”

E. Name Of Spreadsheet: PERSON Column Headings(Name, DateofHire,DeptnName,DeptManager,ProjectID, NumHours, ProjectManager) Question 1 (the number of themes you think the spreadsheet includes with appropriate theme names) Ans: There should be Three(3) THEMES with the name “PERSON”, “DEPARTMENT”, “PROJECT”. Assuming the Numofhours are the hours worked by the PERSON Question 2: Breakup columns of Spreadsheets with more than one theme and fix them under a single theme. Ans:
|PERSON |
|Name |DateOfHire |*DeptName |NumOfHours |

|DEPARTMENT |
|*DeptName |DeptManager |

|PROJECT |
|ProjectID |ProjectManager |*DeptName |

Question 3: When inserting data into the table: Ans Data can be inserted without creating null values Problem that would occur updating data Ans Other data on other tables need to reflect the current data. For Example when a person is moved to another DEPARTMENT data would have to be updated in the other tables(DEPARTMENT and PROJECT) Deleting Data: Some data can be deleted on one table without it reflecting on other tables. The space in the database will be wasted

Similar Documents

Free Essay

Advanced Database

...Advance Database Assessment – Marshalls Garage The problems with a flat file database are as follows -: The potential problems of a flat file database are mostly caused through duplication of the required information – e.g. each time the town is put in, it has to be typed separately, this can lead to errors with spelling and consistency e.g. (AE) instead of Dalbeattie, and also inconsistencies between the data whilst the information is being inserted into the database, this also leads to a larger size of database Also unnecessary duplication of entries makes it extremely difficult to make any necessary amendments, such as – inserting data, deleting data or changing commission, if commission rates were to be changed it would require an awful lot of work to update and correct each entry within the file. To potentially fix the problems which arise through the use of a flat file structure, it would be advisable to input the data into a relational database, this allows each aspect of the flat file database to have a separate table which is linked through a relationship to another table, so that the information can be easily found by the use of queries – selecting the tables that contain the relative information – to withdraw the required information, this in turn avoids duplication of information. In order to create a relational database the information contained within the flat file structure must be grouped in order of subject-: such as, Customers, Cars and Staff...

Words: 1010 - Pages: 5

Free Essay

Advanced Database

...CS 632 Advanced Database Systems Your Name: Yagna Patel Your NJIT UCID: 31327569 Email the COMPLETED form back to me at wangj@njit.edu before 9 PM, Sunday, July 26, 2015. The subject of your email must be CS 632 Exam Time. Students who do not send me the COMPLETED form before 9 PM, Sunday, July 26, 2015 are assumed to be OK with ALL the time slots listed below. If a particular time slot is not checked, it is assumed that the time slot is OK (i.e. the default value for each time slot is OK). The finalized exam time will be posted on Moodle before 9 PM, Sunday, August 2, 2015. The total time (duration) for the exam will be 1 hour. August 4, Tuesday, 6 PM Preferred OK Low priority August 4, Tuesday, 8 PM Preferred OK Low priority August 5, Wednesday, 6 PM Preferred OK Low priority August 5, Wednesday, 8 PM Preferred OK Low priority August 6, Thursday, 6 PM Preferred OK Low priority August 6, Thursday, 8 PM Preferred OK Low priority August 7, Friday, 6 PM Preferred OK Low priority August 7, Friday, 8 PM Preferred OK Low priority August 8, Saturday, 3 PM X X Preferred OK Low priority August 8, Saturday, 6 PM Preferred OK ...

Words: 298 - Pages: 2

Free Essay

Ibm Db2

...IBM DB2 Express – C Introduction The intent of this paper is to describe the installation process of the Microsoft Windows version of the IBM DB2 Express-C database. This is a light-weight version of the more fully featured configuration of IBM’s best-selling DB2 database and includes core DB2 capabilities, free administration, development, autonomic, XML support and access to the online communities and forums. The version downloaded and running is configured for dual core processors and supports up to 2GB of system memory. Insights gained from working with the database after installed are also shared. Installation Process for DB2 Express-C Downloading and installing DB2 Express-C is easily accomplished over an Internet connection. The version installed is 389MB and took approximately 10 minutes to download over a cable modem running at fractional T1 speeds. Installation screens from the steps completed to get DB2 Express-C up and running are shown in the Appendix of this document. After installing the Control Center was invoked at the command line using the command db2cc which is specifically defined in the chapter assigned on DB2 Express-C. Using the command db2sampl -xml –sql to create the sample data worked, and there is the secondary option of using graphical interface commands to accomplish the same. The use of the DB2 Command Line tools show how quickly a multidimensional table can be viewed, edited and batch programming tasks completed using shell scripts...

Words: 728 - Pages: 3

Premium Essay

Secondary Index

...Abstract—A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of slower writes and increased storage space. This paper describes data indexes in database management system and the types of data indexes and how the data organized. It focuses on the secondary index in the database and a secondary index on a non key field implemented. Index Terms—Database Indexes, Indexes, Secondary Indexes. (keywords) database system would look up an index to find on which disk blocks the corresponding record resides, and then fetch the disk block, to get the account record. Keeping a sorted list of account numbers would not work well on every large databases with millions of accounts, since the index would itself be very big; further, even through keeping the index sorted reduces the search time, finding an account can still be further time-consuming. Instead, more I. Introduction An index for a file in a database system works in much the same way as the index in any normal books. If we want to learn a particular topic (described by a word or phrase) in this book, we can search for the topic in the index at the back of the book, find the pages where it occurs, and then read the pages to find the information we are looking for. The words in the index are in sorted order, making it easy to find the word we are looking for. Moreover, the index much smaller than the book, further reducing the effort needed to find the word...

Words: 2595 - Pages: 11

Premium Essay

Personla Experance with Excel

...Personal experience with Microsoft Excel Randall W. Broyles Trident University International From being designed primarily for personal productivity, Microsoft Excel is inherently a personal productivity database meant for individual and the small business. While enterprise database management applications and platforms are meant for much greater and wide-spread use across organizations. Microsoft Excel has progressed from a relative simple calculation program to a more advanced database application through the use of Microsoft Visual Basic and other programming languages that have been integrated into the baseline application. Microsoft Excel has many wonderful features to offer the small business and personal user. Excel is the most widely known for its spreadsheet function, though it has numerous other uses. Spreadsheets are useful to any type of circumstances. For example, a spreadsheet can be used as a personal checkbook, or a professor’s grade book. Invoices and budgets can be prepared with Excel as well. Excel is extremely useful in the decision making process and the Goal Seek command can even be used to return specific results that you are looking for. Another popular function of Excel is the ability to prepare and maintain to produce results that meet a specific criteria. For instance, a certain stock broker might use these commands to return a list of customers who have sold certain stocks over the past two years or more. Lists created in Excel can be...

Words: 495 - Pages: 2

Premium Essay

Test

...Module 5 Database Management using OpenOffice Base Module Overview Welcome to Module 5 - Database Management using OpenOffice Base. This module explores the building of a database using the OpenOffice 3.0 Base software application. The module is intended to be very hands-on and focus upon two primary areas: the how and why of designing and implementing a database, and to develop a basic understanding of relational database theory. This balance of practice and theory is intended to bring greater design strength and data integrity to your database applications. | Upon completion of this module you will be able to: * Describe a database and how it can be utilised * Discuss the difference between a database and the other applications * Understand how databases are organised and operated * Create a simple database and view database content in various modes * Create a table, define and modify fields and their properties; enter and edit data in a table * Sort and filter a table or form: create, modify and run queries to retrieve specific information from a database * Understand what a form is and create a form to enter, modify and delete records and data in records * Build queries to retrieve and sort data * Create routine reports * Build and print reports for regular and ad hoc reporting of data Terminology | | Database | A database is a collection of related information which is organised into a series of rows (called records) and columns (called...

Words: 20896 - Pages: 84

Premium Essay

Google

...International Journal of Engineering and Advanced Technology (IJEAT) ISSN: 2249 – 8958, Volume-2, Issue-3, February 2013 Wireless Fingerprint Based College Attendance System Using Zigbee Technology Gunjan Talaviya, Rahul Ramteke, A.K.Shete Abstract— In this paper we propose a system that takes attendance of student and maintaining its records in an academic institute automatically. Manually taking the attendance and maintaining it for a long time makes it difficult task as well as wastes a lot of time. For this reason an efficient system is designed. This system takes attendance with the help of a fingerprint sensor module and all the records are saved on a computer. Fingerprint sensor module and LCD screen are dynamic which can move in the room. In order to mark the attendance, student has to place his/her finger on the fingerprint sensor module. On identification of particular student, his attendance record is updated in the database and he/she is notified through LCD screen. In this system we are going to generate Microsoft excel attendance report on computer. This report will generate automatically after 15 days (depends upon user). This report will be sent to the respected HOD, teacher and student’s parents email Id. Index Terms—Fingerprints, Enrollment, Fingerprint sensor, Failure to enroll (FTE), Failure to capture (FTC), Verification, Fingerprint templates, identification. For attendance, the student places his/ her finger over the fingerprint device and the...

Words: 1698 - Pages: 7

Premium Essay

Database Paper

...Database Dictionary.com defines database as “a systematically arranged collection of computer data, structured so that it can be automatically retrieved or manipulated”. In today’s business, organizations run on data that have been processed into information and knowledge. That information is used by managers to apply to business problems and opportunities. Furthermore the data is transformed into knowledge and solutions in many different ways after detail analysis. Because data and information are processed in several stages and often in several places, they are frequently subject to problems and difficulties. Managing data in organizations is difficult for many reasons, so organizations in the effort to manage all of the data, developed databases to organize all of the collection. These databases are managed using database management systems, and by utilizing different applications. In our organization, we do have a database that we use for our data collection and analysis and storage of all the data we collect. We also use several applications in the daily operations of our business which I will explain further in this paper. Our organization is currently using several applications to make our processes more precise, effective and efficient. Currently, our organization is using a Sybase SQL database as the main database for all of our business functions. This database delivers extreme transaction processing and access to mission critical information...

Words: 732 - Pages: 3

Premium Essay

Database Systems

...Database Systems name 3-12-2012 Web-407 Advanced Web Development instructor's name Introduction Most companies need some type of database. A company may be small or extremely large but they all share one thing in common, if they make any type of product, sell anything, keep contacts, balance the books, pretty much anything a business can any will do, they need some type of database or multiple databases to store and later retrieve the data a typical business generates. Choosing the right database is even more important in the age of the Internet, products and services can be sold around the world now and the data from shopping carts and other payment and shipping needs a database too. This article will go into a bit more detail on some of the types of databases that are available and how to pick the right one for your company. Open Source vs. Proprietary This is the big question on a lot of businesses minds these days. Rather to try and cut costs by integrating an Open Source database or a proprietary one. First off let us go over what open source means. Open source software, in this case a database, is software that generally has a limited license for free using. The software is developed and maintained by developers and coders around the world that continuously work at improving the software but providing security upgrades and bug fixes. Proprietary software on the other hand is generally developed, upgraded and patched by a company that sells or licenses the software...

Words: 1313 - Pages: 6

Free Essay

Distributed Systems

...Server Training (16 Courses) Training on how to build and manage SQL Server databases. Our SQL Server Training Courses provide the skills needed to build a solid foundation for SQL Server development. Introduction An overview of DBMS technology * How data is accessed, organized and stored * The database development process * Query and application development tools * CASE tools for database analysis and design * Tables, attributes and relationships * Primary and foreign keys * Relational integrity constraints * Manipulating data: selection, projection, join, union, intersection, difference * An integrated, active data dictionary * The query optimizer * Developing the logical data model * Mapping the data model to the relational model * Specifying integrity constraints * Defining the data in the data dictionary * Capturing entities, attributes and identifiers * Describing relationships: one-to-one, one-to-many, many-to-many * Optional and mandatory relationships * Resolving many-to-many relationships for implementation * Generating the SQL to build the database * Reverse engineering to capture the design of an existing database * SQL Programming Language Introduction 1 Days * Write SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures * Update database content with SQL and transaction handling * Retrieve data with filter conditions and from...

Words: 1010 - Pages: 5

Premium Essay

Db Testing

...about Database Testing Presented by: Mary R.Sweeney Exceed Technical Training & Consultation Copyright Sammamish Software Services 2003. All rights reserved. 1 Today’s complex software systems access heterogeneous data from a variety of backend databases. The intricate mix of client-server and Web-enabled database applications are extremely difficult to test productively. Testing at the data access layer is the point at which your application communicates with the database. Tests at this level are vital to improve not only your overall test strategy, but also your product’s quality. In this presentation you’ll find out what you need to know to test the SQL database engine, stored procedures, and data views. Find out how to design effective automated tests that exercise the complete database layer of your applications. You’ll learn about the most common and vexing defects related to SQL databases and the best tools available to support your testing efforts. Copyright Sammamish Software Services 2003. All rights Reserved 1 8/26/2004 The Data Access Layer Testing at the data access layer is the point at which your application communicates with the database. ! In this presentation we’ll discuss why tests at this level are vital to improve not only your overall test strategy, but also your product’s quality ! Copyright Sammamish Software Services 2003. All rights reserved. 2 How to design effective automated tests that exercise the complete database layer...

Words: 5030 - Pages: 21

Free Essay

Acme Global

...ACME Global Consulting Proposal Walterella McNear Professor Thurman Roles CIS 111, Intro to Relational Dbase Management Systems January 23, 2013   Dear ACME, I am sending my recommendations regarding your options for ACME Global Consulting Database Management System (DBMS). In this fast-paced and competitive business world, you want to make the database your company uses simple and easy to use. The E-R Model DBMS will allow your employees to be more efficient and productive in their daily workday schedule. As we all recognize that productivity is one of the many keys to a successful business. Advantages of the Entity Relational Model: a. Structure: The structure of the E-R Model DBMS is the ease of use. This system will allow the users to communicate with each other on the basis that it is not so technical. Your company would have a low percentage rate of mistakes during data entry throughout the daily workforce. This structure also allows employees to communicate and interact with each other more effectively should problems arise. A more efficient workflow would be established due to the different employee groups understanding each other and would be able to solve different issues that may arise within the DBMS. b. Components: Another advantage to having this E-R- Model DBMS is that the components will allow your employee groups to distinguish the differences between these different components in the model. Some of the components are entities that represent...

Words: 515 - Pages: 3

Premium Essay

Case Study Lego

...LEGO - EMBRACING CHANGE BY COMBINING BUSINESS INTELLIGENCE WITH A FLEXIBLE INFORMATION SYSTEM History of LEGO Company The LEGO Group was founded in 1932 by Ole Kirk Kristiansen. The company has passed from father to son and is now owned by Kjeld Kirk Kristiansen, a grandchild of the founder.   It has come a long way over the past almost 80 years - from a small carpenter’s workshop to a modern, to a global enterprise that is now, in terms of sales, the world’s fourth-largest manufacturer of toys. The name 'LEGO' is an abbreviation of the two Danish words "leg godt", meaning "play well". The original Lego toys started with a wooden duck. But the first LEGO automatic binding brick is their most important product. The products have undergone extensive development over the years – but the foundation remains the traditional LEGO brick. The Lego Group began in the carpentry workshop of Ole Kirk Christiansen, in Billund, Denmark in 1916.  In 1961, Lego wished to expand sales to North America, but did not have the logistical capabilities to do so. Lego made an arrangement allowing Samsonite to begin producing and selling Lego products in the United States and Canada.  On 7 June 1968, the first Legoland Park was opened in Billund. This theme park featured elaborate models of miniature towns built entirely from Lego bricks. The three acre (12,000 m²) park attracted 625,000 visitors in its first year alone. During the next 20 years, the park grew to more than eight times...

Words: 1468 - Pages: 6

Premium Essay

Unit 1 Research Assignment 1

...Database Concepts Unit 1 Research Assignment 1 Exploring Programming Languages SQL, in a simplest form, is a data sublanguage purposely invented to provide an interface to a relational database such as Oracle Database, and all SQL statements are instructions to the database. SQL provide benefits for all types of users, including application programmers, database administrators, managers, and end users. Some of its features include processing sets of data as groups rather than as individual units, as well as provide automatic navigation to the data. Since SQL was first created there have been three major changes to the program and eleven minor changes. The latest major change addressed the requirement for objects and "object identifiers" in SQL and also specifies supporting features such as encapsulation, subtypes, inheritance, and polymorphism. Microsoft SQL Express is a free edition of SQL Server that is ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs. It includes the full version of SQL Server 2014 Management Studio and provides LocalDB; a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. Use this if you need a simple way to create and work with databases from code. Microsoft SQL Express even has the options of adding tools or advanced services to the express package. Like...

Words: 375 - Pages: 2

Premium Essay

Motivation

...rmation stored in relational databases. You will learn 1) how to formulate SQL queries and understand how they apply to the schema and how they are executed; 2) how constraints effect insertions and deletions; 3) about the basics of view, transactions, indices and triggers. The recommended reading for Laboration 1 is that of Lectures 1-7 , particularly Chap 6-8. Laboration Come prepared to the review session! Only one try is allowed – if you fail, you are not allowed to try again until the next lab session. The review will take 10 minutes or less, so have all papers in order. To pass you should have Completed Task 1 with at least 9 of the 10 queries right, completed Task 2 and able to explain why certain actions give errors and other do not, also 8 of the 9 steps should be documented showing you executed them correctly, Task 3 the output file should show that the trigger works as it should. The grade is A if passed when the review when due. See the Lab Grading page in bilda contents for the due dates for the labs and the grading of late assignments. Laboration 1 is intended to take 30h to complete. Computing Environment In this assignment you will use Nestor 2.0. Nestor is KTH’s logic engine (computer) dedicated to hold the databases used in this and other similar courses. Nestor is aptly named after Nestor the Gerenian horseman from Homer’s Illiad. Nestor was, by the time of the Trojan war, an old man allegedly one hundred and ten years old. His advanced age had imparted great...

Words: 2303 - Pages: 10