Question 10 Name samsnead@gmail.com First: Sam Last: Snead Column families Address Street: 1003 Oak St City: Chicago Zip: 32312 Image Photo: Key info@yahoo.com Company: Yahoo Street: 999 Elm Ave City: Palo Alto Photo: Zip: 94025 Street: 43 Buena Vista Photo: City: Fort Frances ellen.thompson@hotmail.com First: Ellen Last: Thompson Province: Ontario Country: Canada PostalCode: P8A 8L9 Wide column logical structure Captions 1. The key identifies rows, as in a key-value database. 2. Column families are fixed across all rows. 3. Each column family contains one or many columns. Each column has a name and a value. 4. Columns can vary across rows. Using the Wide-Column Database shown above: What information is required to access Sam Snead's ZIP code? The Key for that entry 1 pts
Added by John M.
Close
Step 1
Step 1: Read the text carefully to identify any spelling, typographical, grammatical, OCR, or mathematical errors. Show moreā¦
Show all steps
Your feedback will help us improve your experience
Akash M and 52 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Question 1 (30 marks) Answer questions of items (a) and (b) based on the customer database given in Figure 1. You are encouraged to make assumptions of any new entities that may seem relevant. Marketing department of ABX recruitment requires a customer database based on the following requirements; Persons are identified by a combination of their first name, last name, and date of birth. A person can have an arbitrary number of titles (E.g., Prof. Dr. Karin Knight). For cooperation we record the sector (e.g., IT) and a unique name to represent the cooperation. Persons work for one or more cooperation's. For each relation between a person and a cooperation we record a job title. There are situations where some cooperation in our database don't have any associated employees. Addresses consist of a street, street number, zip code, city, state, and a unique Id. A person can be associated with an arbitrary number of addresses and multiple persons can live at the same address. A cooperation is associated with one or more addresses. No two cooperation's share the same address. Some addresses in the database may not be associated with any cooperation or person. Phone contacts consists of a type (e.g., home or work) and are uniquely identified by a combination of area code and number (e.g., 312 and 123456). Each person is associated with at least one phone contact. Each phone belongs to exactly one person. Some, but not all phone contacts are associated with an address. We allow multiple phone numbers for the same address. An email address consists of an unique address string (e.g., krinknight@sit.edu.my). Each email address has one owner (a person), but not all persons have an email address. We do not record multiple email addresses per person. Figure 1: Customer database a) List all the entities required for requirements given in Figure 1. (10 marks) b) Draw the complete entity-relationship diagram for requirements given in Figure 1. (20 marks)
Akash M.
Consider the following tables for the RENTAL_PROPERTY database: BRANCH (Bno, Street, Suburb, Pcode, Tel_No, Fax_No) STAFF (Sno, Fname, Lname, Address, Tel_No, Position, Sex, DOB, Salary, Bno) PROPERTY_FOR_RENT (Pno, Street, Suburb, Pcode, Type, Rooms, Rent, Ono, Sno, Bno) CLIENT (Cno, Fname, Lname, Address, Tel_No, Pref_Type, Max_Rent, Bno) OWNER (Ono, Fname, Lname, Address, Tel_No) VIEWING (Cno, Pno, Date, Comment) The data for tables BRANCH, STAFF, and PROPERTY_FOR_RENT are as follows: BRANCH: Bno Street Suburb Pcode Tel_No Fax_No B2 56 Clover St Melbourne 3000 9662 7723 9662 7724 B3 163 Main St Kew 3101 9859 8301 9859 0231 B4 32 Manse Rd Bundoora 3803 9479 1284 9479 1212 B5 22 Deer Rd Melbourne 3000 9662 8733 9662 4455 B7 16 Argyll St Hawthorn 3122 9818 7444 9818 6666 STAFF: Sno FName LName Address Tel_No Position Sex DOB Salary Bno SA9 Mary Howe 2 Elm Pl, Hawthorn 3122 Assistant F 19-Feb-70 $27,000.00 B7 SG14 David Ford 63 Ashby St, Kew 3101 0411-942-432 Deputy M 24-Mar-58 $51,000.00 B3 SG37 Ann Beech 81 George St, Kew 3101 0413-983-983 Snr Assistant F 10-Nov-60 $36,000.00 B3 SG5 Susan Brand 5 Western Rd, Kew 3101 0411-412-242 Manager F 03-Jun-40 $72,000.00 B3 SL21 John White 19 Taylor St, Melbourne 3000 0418-444-234 Manager M 01-Oct-45 $90,000.00 B5 CL41 Julie Loo 20 Malvern Rd, East Kew 3102 0411-002-332 Assistant F 13-Jun-65 $27,000.00 B5 PROPERTY_FOR_RENT: Pno Street Suburb Pcode Type Rooms Rent Ono Sno Bno PA14 16 High St Hawthorn 3122 House 6 $650.00 CO46 SA9 B7 PG16 5 Novar Rd Kew 3101 Flat 4 $450.00 CO93 SG14 B3 PG21 18 Dale Rd Kew 3101 House 5 $600.00 CO87 SG37 B3 PG36 2 Manor Rd Kew 3101 Flat 3 $375.00 CO93 SG37 B3 PG4 6 Lawrence St Kew 3101 Flat 3 $350.00 CO40 SG14 B3 PL94 6 Argyll St Melbourne 3000 Flat 4 $400.00 CO87 SL41 B5
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
100,000+
Students learning Computer Science with Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD
