IndiaBIX

Database - Introduction to Database - Discussion

Discussion Forum : Introduction to Database - General Questions (Q.No. 16)
Introduction to Database
16.
Which of the following projects illustrates a database being designed from existing data?
A database using the Production Department's spreadsheets
A database designed to produce production reports for a new Production Department manufacturing process
A database that will combine two databases currently used by the Production Department
None of the above is correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
14 comments Page 1 of 2.
Amujuri vivek said:   1 decade ago
What is meant by spreadsheet, is that data will be present in the spreadsheet in the format of ms-excel. We can take data from it when ever we need it. If we add any data to this spreadsheet we can apply any formula like addition, subtraction, multiplication and division to it. So I think the answer is correct.
Rajat Rahul said:   1 decade ago
@Gothaman: Database is a logically related data. It is called as database because it has been made with the collection of data which has their internal dependencies with the primary keys and foreign keys etc.

However, kindly help me to understand the answer of this question which has option A.
Kruvy said:   1 decade ago
Well, .csv (spreadsheet) can be seen as a table. Basically the concept of database has evolved from flat files (.CSV , .txt).

So, I think that is why Spreadsheet is treated as a database here...

(people who knows Office Macro would have much idea about it....)
Chitresh said:   1 decade ago
Actually, sql loader is used to import excel files in the database. Basically if you have a table in which there is no data, you can either enter the data manually or you can load it through 'sql loader'.
Jaba said:   1 decade ago
I think, Using The data in Spreadsheet which is existing, database can be created which is efficient (like SQL).
(1)
Rajib said:   1 decade ago
Could any one tell me how to import data from the excel sheet to the database table ?
Chitresh said:   1 decade ago
So, input of sql loader - excel files containing data.

Output= data in the table.
Karam said:   1 decade ago
Data from existing database is also a project. So why not the option B or C.
Gandi srinu said:   1 decade ago
Creating another data base in the form of spread sheet is a new project.
Kiran said:   1 decade ago
What is spreadsheet in database? how it will use in that?
Post your comments here:

Your comments will be displayed after verification.

Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers