Consider the following traditional file system, which shows a number of index cards stored in two separate databases (and possibly in two different locations/ departments). Student information for Jane Blue is shown below:Compare the data found in each index card. State any discrepancies which may be found and explain what problems can occur because of the discrepancy. A single file of records.Se parate files for each function.StudentTheAdministrationFacultyDatabaseDatabaseStudent IDStudent NameStudent ID2345324Jane Blue2345324Student NameJane BlueStudent Address Main Avest. GeorgesSubjects Passed MGMT2005MGMT2006$32.50Student Address Main AveSubjects Enrolled MGMT3011MGMT23 05Fees paidSubjects Passed MGMT 1000MGMT1001

Actually, database is a used to stores the data.

Answered: Consider the following traditional file…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Consider the following traditional file system, which shows a number of index cards stored in two separate databases (and possibly in two different locations/ departments). Student information for Jane Blue is shown below:

Compare the data found in each index card. State any discrepancies which may be found and explain what problems can occur because of the discrepancy.

A single file of records.
Se parate files for each function.
Student
The
Administration
Faculty
Database
Database
Student ID
Student Name
Student ID
2345324
Jane Blue
2345324
Student Name
Jane Blue
Student Address Main Ave
st. Georges
Subjects Passed MGMT2005
MGMT2006
$32.50
Student Address Main Ave
Subjects Enrolled MGMT3011
MGMT23 05
Fees paid
Subjects Passed MGMT 1000
MGMT1001

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions