The field can be referred as studentname the numbers

Info icon This preview shows pages 6–9. Sign up to view the full content.

View Full Document Right Arrow Icon
the field can be referred as “student_name”), the numbers forming student’s identification number would be stored in another field (which can be named as “Student_ID”). A field can also contain an image or any other type of media (for example; the Facebook database would contain the photos and the videos that users upload on the site in addition to the text data that users provide on the website). At further lower level, the characters (such as alphabets and numbers) are stored in the computers in terms of bytes. A byte can be a number (such as “4”), a letter (such as “G”), or a symbol (such as “@”) and is composed of a group of 8 bits. A bit (stands for binary digit), which can only consist of a 0 or a 1, is the smallest unit of data that a computer can process. Relational Database Approach Managing databases with DBMS vs. Spreadsheet 6
Image of page 6

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Spreadsheet applications like Excel are good for handling small amounts of data, where the data relationships are uncomplicated. Spreadsheet applications are also very useful for modelling, calculating and graphing data as well as for conducting “What if?” or sensitivity analyses. Database systems are, on the other hand, more efficient when there is a large amount of data, where there are complex relationships and data linkages. Database applications are more useful for reporting purposes, generating exceptions and summaries, as well as data extracting, merging, and other data manipulations. To show the differences between using spreadsheet versus database when managing data with complex relationships, we will examine a simplified case. Let us look at the data management requirements of Amazon.com’s, especially focussing on storing their purchase order information. To start with, let’s say you only need to store book related information. To simplify, we are only interested in the book name, price, author and ISBN number (the number that uniquely identifies a book (as shown in the screenshot below). Note: ISBN number shown here for this book is not real (it is a made up number to make the example simple). To store this information (as well as data about other books) using Excel, you could create a worksheet as follows. 7
Image of page 7
In the figure above, there are 4 fields (ISBN, Author, BookName, and Price) and 3 records (i.e., rows). What if you want to capture the complete purchase order information using Excel spreadsheet? Assume that for each purchase, you record the following information. Note, that for simplicity we are assuming that each order contains only one book. You can create a worksheet with each order stored in a row. The details (or the attributes) contained in the order are stored in various columns (with headings such as ordernumber, date, customerId, name, phone, ISBN, bookname, Author, Price, etc.,). See the image below for an example.
Image of page 8

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern