1.

A travel agency would like to track the destination of each flight. Given the following business rule, what constraint(s) can you apply to the flight table, given there is also a destination table?

"A flight must be associated with a destination".

Question 1 options:

2.

Constraint applied to a one-to-many relationship when a referenced record (on the 1 side) is deleted, then the referencing records (on the Many side) should also be deleted.

Question 2 options:

3.

Which of the following is the most appropriate data type for a column named "State" that stores abbreviated names of the states in USA like "TN", "VA" etc.

Question 3 options:

4.

How can database performance be improved without changing the logical design of the database? Check all that apply.

Question 4 options:

5.

Which of the following statements best describe an index?

Question 5 options:

Module 2 Course Work

1. Read Pages 12-30.
2. Use the week 1 video's and this week's reading to complete Lab 1.

Lab 1

This week’s assignment must be done using Microsoft Access.

Please use this assignment as a rubric.

Cross-off each step as you complete it.

1. Create a new Access Database. Name the database using your name.
2. 
   Create a table called Address.
3. 
   Within the Address table create the following fields:
4. 
   FirstName
5. LastName
6. 
   StreetAddress
7. 
   City
8. 
   State
9. 
   Zipcode
10. 
    Telephone
11. Please note:
    (Database table and field names should never contain spaces)
12. 
    Default data should be text.
13. 
    Primary Key is the first and last name.
14. 
    (Please research how to create 2 primary keys in a table.)
15. Create another table named Event.
16. 
    In the Event table create one field named EventName.
17. 
    The data entered in the EventName field should be text data.
    Primary Key is EventName.

18. Create another table named Price
19. 
    In the Price table create one field named Package.
20. 
    Primary key is Package.
21. 
    Create another field named Amount.
22. 
    Create a third field named Discount.
23. 
    Insert 5 records in the address table – make up the data.
24. 
    Insert the name of five holidays in the Event table.
25. 
    Do not insert any records into the Price table.

26. Save your database with your firstnamelastname (no spaces).
27. 
    Upload this database by the deadline. See below

Create a database to hold a collection of numbers to be searched and sorted:

1) Create a main class and a database class

2) Collect 5 random numbers from the user in the main class and store in an array. (not in ascending or descending order)

3) Create an instance of the database class in your main class and store the numbers array in the database using its constructor.

4) In the Database class, create a method that performs a bubble sort and returns a sorted array of the data (ascending and descending). Call this method from the main class and print the result to the screen.

5) In the Database class, create methods that each return the min, average, and max respectively. Call each of them from the main class and print the result to the screen.

6) In the Database class, create a method that searches for a value in the array using a binary search and returns the index of that value. Call this method from the main class and print the result to the screen.

BubbleSort and Binary Search Code:

{

public static void main(String args[])

{

SortExample ob = new SortExample();

int[] arr = {64, 34, 25, 12, 22, 11, 90};

ob.bubbleSort(arr);

System.out.println("Sorted array");

ob.printArray(arr);

int key = 22;

int index = ob.BinarySearch(arr, key);

System.out.println("\n" + key + " is at index: " + index);

}

void bubbleSort(int[] arr)

{

int n = arr.length;

for (int i = 0; i < n-1; i++)

for (int j = 0; j < n-i-1; j++)

if (arr[j] > arr[j+1])

{

// swap temp and arr[i]

int temp = arr[j];

arr[j] = arr[j+1];

arr[j+1] = temp;

}

}

/* Prints the array */

void printArray(int arr[])

{

int n = arr.length;

for (int i=0; i<n; ++i)

System.out.print(arr[i] + " ");

System.out.println();

}

int BinarySearch(int[] arr, int key)

{

int mid = 0;

int low = 0;

int high = arr.length - 1;

while (high >= low)

{

mid = (high + low) / 2;

if (arr[mid] < key) {

low = mid + 1;

}

else if (arr[mid] > key) {

high = mid - 1;

}

else {

return mid;

}

}

return -1;

}

}

14.19. Suppose that we have the following requirements for a university database
that is used to keep track of students’ transcripts:
a. The university keeps track of each student’s name (Sname), student number (Snum), Social Security number (Ssn), current address (Sc_addr) and phone (Sc_phone), permanent address (Sp_addr) and phone (Sp_phone), birth date (Bdate), sex (Sex), class (Class) (‘freshman’, ‘sophomore’, … , ‘graduate’), major department (Major_code), minor department (Minor_code) (if any), and degree program (Prog) (‘b.a.’, ‘b.s.’, … , ‘ph.d.’). Both Ssn and student number have unique values for each student.
b. Each department is described by a name (Dname), department code (Dcode), office number (Doffice), office phone (Dphone), and college
(Dcollege). Both name and code have unique values for each department.
c. Each course has a course name (Cname), description (Cdesc), cours number (Cnum), number of semester hours (Credit), level (Level), and offering department (Cdept). The course number is unique for each course.

d. Each section has an instructor (Iname), semester (Semester), year (Year), course (Sec_course), and section number (Sec_num). The section number
distinguishes different sections of the same course that are taught during the same semester/year; its values are 1, 2, 3, … , up to the total number of sections taught during each semester.
e. A grade record refers to a student (Ssn), a particular section, and a grade (Grade).
Design a relational database schema for this database application. First show all the functional dependencies that should hold among the attributes. Then design relation schemas for the database that are each in 3NF or BCNF. Specify the key attributes of each relation. Note any unspecified requirements, and make appropriate assumptions to render the specification complete.

Using your DBMS, build this database and populate it with several entities. (Use your imagination)

Using your DBMS, build this database and populate it with several entities. (Use your imagination)

Using your DBMS, build this database and populate it with several entities. (Use your imagination)

Please help me with the set up SQL. thank you

3. Counting Services Inc. has the following portfolio of trading equity securities at 12/31/18. All securities were purchased during 2018.

Symbol # shares Total Cost Market Value

AAPL 1000 $105,000 $125

BMX 2000 $47,000 $51

CAT 1000 $100,000 $105

GNC 3000 $64,000 $21

Total   $316,000

• Prepare the adjustment necessary at 12/31/18.

• On February 12, 2019, Counting Services sells 1,000 shares of AAPL for $125,000. Prepare the journal entry.

• The total cost of the three remaining securities is $211,000 and the market value is (see below) at March 31, 2019. Prepare the adjusting entry.

Value of a Statistical Life (VSL). (a) Describe VSL in terms that a non-economist can understand. (b) Lavetti (2017) studies the wage-risk tradeoff for one of the riskiest professions in the United States, crab fishing in Alaska. The riskiness of crab fishing is driven mainly by the season and weather conditions. Lavetti collects data on the weather conditions of specific fishing trips, and the wages paid to the crew. He then runs a regression of the wage on the expected fatality rate for each trip and finds that an increase in one fatality per 1000 full time workers per year increases the mean hourly wage by $2.10. Calculate the VSL implied by this estimate, assuming that the number of hours a full time worker works in a year is 2000. (c) Does this number seem high or low to you? Briefly discuss why this might be the case.

Bigg company is evaluation two projects for next year’s capital budgeting. The after-tax cash flow ($) (including depreciation) are following:

Project A                              Project B

Year 0    -7500 -17500

Year 1    2000                                       5600

Year 2    2000                                       5600

Year 3    2000                                       5600

Year 4    2000                                       5600

Year 5    2000                                       5600

Year 6    4000                                       9000

If company’s WACC is 13%, find NPV, IRR, Payback and discount payback for each project. If the projects are mutually exclusive what is your recommendation to the company.(show working please)

Exp19_Access_Ch02_Capstone - International Foodies 1.0

Project Description:

International Foodies is an importer of exotic foods from all over the world. You landed a summer internship with the company and discovered that their product lists and the suppliers they buy from are stored in Excel workbooks. You offer to help by using your newly gained knowledge of Access to create a relational database for them. You will begin by importing the workbooks from Excel into a new Access database. Your manager mentions that she would also like a table that specifies food categories so that you can relate the products you sell to specific categories in the database. You will create a table from scratch to track categories, create relationships between the tables, and create some baseline queries.

Steps to Perform: