Please need you answer this question be clear also these question are from DataB
ID: 3542185 • Letter: P
Question
Please need you answer this question be clear also these question are from DataBase System course..What are the fundamental differences between a file-based system, and a database system?
In your own words, discuss the properties of a relation.
What are foreign keys? (For what purpose do we use these types of keys)
What are the fundamental differences between a file-based system, and a database system?
In your own words, discuss the properties of a relation.
What are foreign keys? (For what purpose do we use these types of keys)
Explanation / Answer
File-Oriented System versus Database System
Computer-based data processing systems were initially used for scientific and engineering calculations. With increased complexity of business requirements, gradually they were introduced into the business applications. The manual method of filing systems of an organisation, such as to hold all internal and external correspondence relating to a project or activity, client, task, product, customer or employee, was maintaining different manual folders. These files or folders were labelled and stored in one or more cabinets or almirahs under lock and key for safety and security reasons. As and when required, the concerned person in the organisation used to search for a specific folder or file serially starting from the first entry. Alternatively, files were indexed to help locate the file or folder more quickly. Ideally, the contents of each file folder were logically related. For example, a file folder in a supplier
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.