COMPSCI 1BA3 Lecture Notes - Lecture 6: Referential Integrity, Relational Database Management System, Link Group

48 views3 pages

blackmammoth375

22 Oct 2012

School

Department

Course

Professor

For unlimited access to Class Notes, a Class+ subscription is required.

Document Summary

Access building a database and defining table. Identify all the fields needed to produce the required information. Organize each piece of data into its smallest useful part. You much name, each field, table, and other object. The field size property defines a field value"s maximum storage size for text, Number, and autonumber fields only: byte, integer, long integer, single, double, decimal. Creating a table in design view involves entering the field names and defining the properties for the fields, specifying the primary key, and saving the table structure. In the field name box, type the name for the field, and then press the tab key. Accept the default text data type, or click the arrow and select a different data type for the field. Enter an optional description for the field, if necessary. Use the field properties pane to type or select other field properties, as appropriate.

Related Questions

QUESTION 17

Exercise: Download the "01 - Sample Database" file from Blackboard (Part 1 /Exercise Files), extract the Zip, and open the database.

Go to the Relationships window and observe the relationship between the Services and Locations tables. How was that relationship created?

Feel free to delete the existing relationship line if you wish to test some of the choices below.

⭕ Drag from "Location ID" in the Locations table to "Location" in the Services table.

⭕ Right click the Locations table heading area, choose "relate to", then select the Services table.

⭕ Drag from "Location" in the Services table to "Location" in the Locations table.

⭕ Right click the Locations table heading area, choose "show direct relationships", then select "activate" after it displays the Services table

QUESTION 18

_________ refers to the set of rules that helps to maintain consistency between related tables

⭕ Referential Integrity

⭕ Join

⭕ Relationship

itsmedj

Objective: Take a sample feed, parse it, augment it, and output individual JSON objects for each product in it.

product.txt

The file contains several fields of basic product information for 1000 products.
Data for each product is on one line, with fields separated by a vertical pipe character.

This particular retailer classifies products into a particular store, department, category, and subcategory.

Example >

A Blender might have the following "taxonomy" or category classification.

Home & Garden > Kitchen & Dining > Appliances > Blenders

Store

Department

Category

Subcategory

store_id

department_id

category_id

subcategory_id

These IDs are also represented in a sort of shorthand.

They should all be prefixed by the first three letters of their respective field name.

A store_id of 1 becomes sto1

A department_id of 2 becomes dep2

A category_id of 3 becomes cat3

A subcategory_id of 4 becomes sub4

targets.txt

A system to keep track of these various classifications
- Example
  - A store_id of sto40 maps to a “target value” of 187298 in PromoteIQ's system

Output Example:

The desired output for the first product is one line of JSON that when pretty-printed looks like:

{

"sku": "22067130",

"name": "Brainboxes ES-571 Brainboxes Es-571 Industrial Isolated Ethernet to Serial + Switch - 1 x Network (R",

"description": "Brainboxes ES-571 Brand New Includes Lifetime Warranty Product # ES-571 Factory floors can be harsh environments.",

"priceList": 387.95,

"taxonomy": [

"sto2",

"dep7",

"cat270",

"sub18532"

"targetValues": [

187167,

187177,

187950,

196404

]

}

The taxonomy IDs have been mapped to their long form and placed in the taxonomy property.

Each taxonomy ID has also been mapped to its corresponding target value ID from the targets.txt file
- and that result is stored in the targetValues
- The priceList property is the product price as a JSON float, not a string

coffeebear857

You have been contracted by a popular fitness club to create a Java Program that
will help in the input, calculation, display of calories burnt and pounds lost during a week of
workout for members of the club.
The program will also base on the amount of weight lost update the weight of the user and
calculate and display the users BMI – body mass index using any researched method. See an
example here- http://www.whathealth.com/bmi/formula.html
The club takes part in 5 major types of activities, namely walking, running, swimming, hiking,
and bicycling.
The program is to prompt for the Name of the member, gender, weight in pounds, height and
the time spend on each activity during the week in minutes.
The program will then calculate the calories burnt per activity, the total calorie burnt for the
week and the amount of weight lost during the week.
The amount of weight loss will be used to update the weight that was stored in the array and
calculate the person BMI . http://www.whathealth.com/bmi/formula.html
Activity Calorie Burnt Per pound per minute for
men (women are 1/6 less)
Walking .036
Running .095
Swimming .058
Hiking .058
Bicycling .044
 Calories burned per pound per minute (Bicycling – .044) x (times) your exact weight
(140 pounds) = (equals) total calories burned per minute (6.16 calories burned per
minute) x(times)minutes of activity (30 minutes) = (equals) 184.80 total calories
burned per activity.
 Women burn 1/6 less calories than Men.
 3500 calories = 1 pound of weight loss.
Author: Dexter Chin-Yan
Write a program that would do the following:
 Print a suitable heading and prompt for the required information
 Calculate the necessary required information and store in an Array(s)
o After members names, gender, weight in pounds and time spent in each
activity has been entered (10 Members) The program should calculate the
total calories burnt Total Calorie Burnt for the week and the amount of
weight loss (depending on whether it is a man or a woman.
o Calculate and display BMI and weight status based on the table above.
General Guidelines:
 Make use of appropriate messages to make you program as informative and user
friendly as possible, without being unnecessarily complex.
 Keep user interactions simple and instructions clear
 Use adequate documentation and proper indentation to clarify your program code
where necessary and improve layout
 Pay attention to good structure and use of programming constructs.
Evaluation
 Documentation and layout (spacing, indentation and commenting) 10 marks
 Proper layout of interface for input, output of information 10 marks
 Use of method to calculate, BMI, calories burnt per activity, and weight loss.
20 marks
 Creation and use of arrays to hold and processed information 20 marks
 Working program (Correctness, efficiency, user interaction)

dove

COMPSCI 1BA3 Lecture Notes - Lecture 6: Referential Integrity, Relational Database Management System, Link Group

Document Summary

Get access

Related Documents

COMPSCI 1BA3 Chapter Notes -Associative Entity, Data Redundancy, Unique Key

COMPSCI 1BA3 Chapter Notes -Foreign Key, Unique Key, Logical Connective

COMPSCI 1BA3 Lecture Notes - Meridian Regional Airport, First Normal Form, Electrical Contacts

Related Questions