Techniques to store and retrieve data using an sql database

Assignment Help Database Management System
Reference no: EM131168375

Database and Information Retrieval

Assessment Task 1 - Survey Report

Introduction

- This assessment task is for students to develop an understanding of strengths and limitations of various data storage, retrieval methods and models. The assessment requires students to conduct a survey and report on data storage and retrieval techniques and data models.

- This is an individual assessment task that requires students to prepare a report not exceeding 1000 words, plus or minus 10%, excluding the tables for Question 4 and references.

Unit Learning Outcomes
- Of the three Unit Learning Outcomes (ULOs) of this unit, this assessment task focuses on the first two ULOs.

These are:
o ULO 1 - At the end of this unit students will be able to describe the techniques used in storing and retrieving data.
o ULO 2 - At the end of this unit students will be able to evaluate data models and apply data modelling techniques to capture the data aspects of real-world situations.
- The assessment of this report will indicate whether students can partially attain these two ULOs.

Question 1:

Create your own brief description of the following file organisations. You must use several sources for each file organisation to create your description.
a) Sequential access
b) Random access
c) Index sequential access

Question 2:
Describe in detail 3 techniques to store and retrieve data using an SQL database. Some techniques are based on SQL statements, and others based on setting the primary key value.

Question 3:

Briefly describe the following processes related to the Entity-Relationship data model:
a) Gathering business rules
b) Normalisation

Question 4:

Some data about books could include the ISBN, title, authors, edition, publisher, year of publication, and so on. For example, the following table contains some data about five books.

ISBN

Title

Edition

Authors

Publisher

Year

9781305627482

1305627482

Database systems: design, implementation, and management

12

Carlos Coronel, Steven Morris

Cengage Learning

2017

1111969604

9781111969608

9781133526797

Database systems: design, implementation, and management

10

Carlos Coronel, Steven Morris, Peter Rob

Cengage Learning

2013

9780132742924

Database concepts

6

David M. Kroenke, David J. Auer

Pearson

2013

9781449358655

Doing data science

1

Rachel Schutt and Cathy O'Neil

O'Reilly

2013

9780133571783

Web development and design foundations with HTML5

7

Terry Ann Felke- Morris

Pearson

2015

It is possible to create a similar table for other real world objects such as magazines, computers, cars, grocery items, clothes, people, students, musical instruments, and many more. For example, from the above book data we could create three tables, one for each of the following: book, author and publisher.

Your task is to create three tables of several rows and several columns that contain data about related entities.
- Two tables must be related in a many to many fashion.
- The third table must be related to one of the other tables in a one to many fashion.
- Include primary and foreign keys too.

The three entities are of your choice; but you cannot select related entities of book, author and publisher as in the above example.

You must cite and reference with regards to the data you obtained.

Reference no: EM131168375

Questions Cloud

Describe a case that would benefit from saas : Questions: 1. In cloud computing describe a case that would benefit from SaaS. (I am looking for as specific an answer as possible) 2. Based on what you read describe a case that would benefit from PaaS. (I am looking for as specific an answer as pos..
Complete java program named textfileshoppinglist : 1. Build a complete Java program named TextFileShoppingLIst. From its main method, call a method named writeShoppingList. This method takes an ArrayList of five strings provided by the user at the command line. Use a loop for repeated prompting..
Determine whether there is at least one collision : Given positive integers m and n, simulate the placement of n keys, where a record with key k is placed at location h(k) = k mod m and determine whether there is at least one collision.
How would you go about addressing it : Reflecting on the focus and content of this course, what is an important challenge facing management of health care organizations today? How would you go about addressing it? Explain.
Techniques to store and retrieve data using an sql database : Develop an understanding of strengths and limitations of various data storage, retrieval methods and models. The assessment requires students to conduct a survey and report on data storage and retrieval techniques and data models.
Formal use policy for securing networks and databases : Formal Use Policy for securing networks and databases You will create a formal acceptable Use Policy for an organization of your choice. You will use your textbook as a guide to provide detailed information security expectations of the employees i..
Find the probability of selecting the six integers : Given a positive integer n, find the probability of selecting the six integers from the set {1, 2,...,n} that were mechanically selected in a lottery.
Discuss the requirements management plan : Discuss the Requirements Management Plan with a complete requirements traceability matrix of a project?
Relevant details on ics project implementation : Discuss the relevant details on ICS project implementation as well as its security?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Explore the database to understand what it is about

explore the database to understand what it is about then close your Microsoft Access

  Write down 400-600 in your own words why is it significant

write 400-600 in your own words why is it important to define the scope and perform requirement analysis for the

  Ist all carer groups with an expired permit.

ICT211 Database Design. List the patient id, accession id, animal name, and breed for all animals, sorted by animal type, that are currently being treated (where they have not been released, or sent to a carer or other facility). List all Carer Gro..

  Develop an e-r diagram for the library database

Develop an E-R diagram for the library database. The relation schemas for the library database.

  Sql statements that return a subset of columns

Design and develop the below queries using professional principles and standards: Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause

  Create the table for the relation training courses

An ER diagram for the system. Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities. You must use the Finkelstein methodology as per the study book and tutorials.

  What is special about the date or time data type

You are inputting Date/Time data type criteria for the desired fields when creating a query. What is special about the Date/Time data type? Which of the mathematical operators below is used as a comparison operator for queries in Access?

  Create a pl-sql procedure - print out names of employees

Create a PL-SQL procedure that a company name, print out names of employees working at that company. Test your procedure with a company name you have in your company table.

  Explaining software measurement related to software metrics

Is software measurement equivalent to software metrics? What makes them different?

  Write a paper describing project management lifecycle

Write a paper describing Project management lifecycle and Systems Delivery lifecycle.Your paper must contain two well-formed paragraphs (a topic sentence supported by three to four additional sentences).

  Highest average mark

Write a program to calculate and store the average obtained by 20 pupils in 7 subjects. Output the pupil that made the highest average mark in addition to those pupils making 50 marks and over.

  Explaining business activity in new is with a database

Assume you manage business activity which needs a new IS with a database. The development team is divided on which DBMS you must use. One faction wishes to use oracle,a second wants to use MtSQL, and a third wants to use SQL server.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd