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.
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?
|