Computer Programming and Analysis DBS301 Lecture Notes - Lecture 10: Data Dictionary, Data Definition Language

171 views3 pages

crimsonshark113

17 Nov 2015

School

Seneca College

Department

Computer Programming and Analysis

Course

Computer Programming and Analysis DBS301

Professor

Tanvir Alam

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

Document Summary

Create table cities from table locations, but only for location numbers. 1. less than 2000 (do not create this table from scratch). You will have exactly 10 rows here. When you describe cities, the output is shown below: Create table towns from table locations, but only for location numbers less than 1500 (do not create this table from scratch). This table will have same structure as table cities. You will have exactly 5 rows here. Now you will empty your recycle bin with one powerful command. 3. remove your table towns, so that will remain in the recycle bin. Check that it is really there aren what time was removed. Restore your table towns from recycle bin and describe it. Now remove table towns so that does not remain in the recycle bin. 5. that is really not there and then try to restore it.

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

1.Create a list that contains 10 successive integers starting with the value in the variable start. For example, if start is 7, the resulting list should be [7, 8, 9, 10, 11, 12, 13, 14, 15, 16]. Store the list in a variable named my_list. Assume that the value of start has already been set.

2.Create a list that is made up of the first half of the elements of a list called original_list. Store the new list in a variable called half_list. Assume that the original list has already been initialized and contains an even number of elements.

3. Write a predicate function called same_ends that accepts a list of integers and an integer (n) as arguments. Return True if the first n numbers in the list are the same as the last n numbers in the list, and False otherwise. For example, if the list was [1, 2, 3, 4, 99, 1, 2, 3, 4], the function would return True if n is 4 and False if n is 3. Assume that n is between 1 and the length of the list, inclusive.

4.Write a function called highest_values that accepts as arguments a list of numeric values and a single integer (n). The function should return a list made up of the largest n values from the argument list in order from lowest to highest. For example, if the argument list is [46, 82, 25, 61, 70, 33, 54] and n is 3, the return value should be [61, 70, 82]. Assume that the argument list contains at least n elements.

5.Assume that a list of integers stored in a variable named original contains exactly two elements that are zero. Write code that creates a separate list that contains the elements from original that are between the two zeros. Do not include the zeros in the new list. Store the list in a variable named between_zeros.

6. Write a function called price_range that accepts a list of floating-point numbers representing prices as an argument and returns the the difference between the highest price and the lowest price. Do NOT use the built-in functions max or min in your solution. Assume that all prices are positive values and that none of them exceed 10,000.00.

7. Write a function called count_vowels that accepts a string argument that represents a word and returns the number of vowels that are in the word. The vowels are A, E, I, O, and U (ignore the 'sometimes Y' rule). Count both uppercase and lowercase vowels.

Assume that the variable table holds a two-dimensional list of integers. Write code that computes the sum of all elements in the table, assigning the result to the variable table_sum.

emeraldhorse214

Hi. You should write a Java program to meet the specification shown below.

In this game(dice poker), the computer rolls two standard six-sided dice and you bet on the outcome. The outcome is the configuration of the numbers rolled (explanation below). The input/output should utilise a graphical user interface (input and message boxes).

1.1 Game flow

You start with some money in your bank. You play a number of rounds, where for each round you place a bet and the computer rolls the dice, checks results and modifies your bank balance. After certain conditions, the game ends and you're presented with some final information shown as a message box.

1.2 Placing bets

Before the computer rolls the dice, you can bet some money from your bank.

ˆ If the numbers are sequential (e.g. 1 and 2, 5 and 4, etc. Not 6 and 1), you earn double your bet.

ˆ If the numbers are identical (rolling doubles), you earn triple your bet.

ˆ Otherwise, you win nothing therefore you lose the amount of money you bet.

Before placing a bet, the computer should inform you of your current bank balance.

1.3 Starting Game- Game rules

When the game starts you are given £6 in your bank. Each bet costs £1 and you are allowed to make up to five bets before the game ends. The game will end if you run out of money, or you have no more attempts left (you made all five bets). At the end of the game, you will be told which of these conditions has ended the game.

1.4 Results display

Once the game has finished (all bets have been placed or you ran out of money) the computer will collate and display the results in a single message box, comprised by:

ˆ On row per bet, displaying your bet, the numbers rolled, the amount of money earned or lost for that bet.

ˆ One row at the end, displaying the amount of money that you have remaining in your bank at the end of the game.

1.5..Variable bet amount

Allow the user to change how much they would like to bet and change the amount you win accordingly. Allow bets between £1 and 4£ (integers only)

1.6.High score table

Create a high score table. The more money you have remaining in your bank at the end of the game the higher up the table you will be. In order to implement this, players will have to enter their name before they play. The high score table should be displayed as a separate message box after the results have been displayed at the end of the game(1.4)

Not1: Please use JoptionPane class instead of scanner class.

Not2: Also If possible explain the description of your classes: what each does and how they relate to each other. And if possible, program should be extensible. E.g. Is it easy to change the number of dice? The number of rounds to play? The sides of the dice?Etc.

OC4135869

Computer Programming and Analysis DBS301 Lecture Notes - Lecture 10: Data Dictionary, Data Definition Language

Document Summary

Get access

Related Documents

Computer Programming and Analysis DBS301 Lecture 1: DBS301 - Lab1

Computer Programming and Analysis APC100 Lecture Notes - Lecture 3: Oracle Database, Sql*Plus

ECO333H1 Lecture Notes - Lecture 3: Isocost, Exogeny, Hectare

Related Questions