EBK DATABASE CONCEPTS
7th Edition
ISBN: 9780133544886
Author: AUER
Publisher: PEARSON CUSTOM PUB.(CONSIGNMENT)
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 1, Problem 1.33E
Explanation of Solution
Name of spreadsheet: COMPANY
Column names:
| Name | IndustryCode | Gross Sales | OfficerName | OfficerTitle |
The above spreadsheet contains Name, IndustryCode, Gross Sales, OfficerName, and OfficerTitle.
Divide the columns into tables with single theme:
Industry details:
| Industry_id | Name | IndustryCode |
| 1 | SUN | 352-765 |
| 2 | Anime | 654-123 |
Officer details:
| Officer_id | OfficerName | OfficerTitle |
| 1 | Ram Kumar | ceo |
| 2 | Rajesh | Project Head |
Sales details:
| Industry_id | Officer_id | Gross Sales |
| 1 | 1 | 23000000 |
| 2 | 2 | 45000000 |
| 1 | 2 | 50000000 |
- Number of themes: Three
- Name of the theme: Industry details, officer details, and Sales
Assumptions:
In the above spreadsheet, there are three themes. One of the themes is about industry which is specified through the heading of Name and IndustryCode. The other theme is about officer who is specified through the heading of OfficerName and OfficerTitle. The final theme is about sales which are specified through the heading of Gross Sales.
- Industry – It contains Industry_id, Name and IndustryCode attributes. The Industry_id is the primary key of the Industry table.
- Officer – It contains Officer_id, OfficerName, and OfficerTitle attributes. The Officer_id is the primary key of the Officer table.
- Sales – It contains Industry_id, Officer_id, and Gross Sales attributes.
Name of spreadsheet: COMPANY
Column names:
| Name | IndustryCode | Gross Sales | NameOfOwner |
The above spreadsheet contains Name, IndustryCode, Gross Sales and NameOfOwner.
Divide the columns into tables with single theme:
Industry details:
| Industry_id | Name | IndustryCode | NameOfOwner |
| 1 | SUN | 352-765 | XXX |
| 2 | Anime | 654-123 | YYY |
Sales:
| Industry_id | Gross Sales |
| 1 | 23000000 |
| 2 | 45000000 |
| 1 | 50000000 |
- Number of themes: Three
- Name of the theme: Industry details and Sales
Assumptions:
In the above spreadsheet, there are three themes. One theme is about industry which is specified through the heading of Name and IndustryCode. The other theme is about president which is specified through the heading of NameOfPresident. The final theme is about a sale which is specified with the heading of Gross Sales.
- Industry – It contains Industry_id, Name, IndustryCode, and NameOfOwner attributes. The Industry_id is the primary key of the Industry table.
- Sales – It contains Industry_id, and Gross Sales attributes.
Name of spreadsheet: COMPUTER
Column names:
| SerialNumber | Make | Model | DiskType | DiskCapacity |
The above spreadsheet contains SerialNumber, Make, Model, DiskType and DiskCapacity...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
-0
e
@
-13-
DC
Current in the & resistance is = I, - Iz
=0-4545-004545 am
EX (2.2): Find the current in the 8sh resistance.
4
ww
0770 709
0568
10V.
M
ДАД
-20V
FISV
2. Jane, Jill, and Jenny have formed a band consisting of 3 instruments.
(a) If each of them can play all 3 instruments, how many different arrangements are possible?
(b) What if Jane can play all 3 instruments, but Jill and Jenny can each play only piano and drums?
4. A person has 9 friends, of whom 5 will be invited to a party.
(a) How many choices are there if 2 of the friends are feuding and will not attend together?
(b) How many choices if 2 of the friends will only attend together?
Chapter 1 Solutions
EBK DATABASE CONCEPTS
Ch. 1 - Why is the study of database technology important?Ch. 1 - Prob. 1.2RQCh. 1 - Describe the purpose of a database.Ch. 1 - Prob. 1.4RQCh. 1 - Prob. 1.5RQCh. 1 - Prob. 1.6RQCh. 1 - Prob. 1.7RQCh. 1 - Break the list in Figure 1-34 into two tables,...Ch. 1 - Show how the tables you created for question 1.11...Ch. 1 - Prob. 1.10RQ
Ch. 1 - Prob. 1.11RQCh. 1 - Break the list in Figure 1-35 into tables, each...Ch. 1 - Describe in your own words and illustrate with...Ch. 1 - Prob. 1.14RQCh. 1 - Define the term database.Ch. 1 - Prob. 1.17RQCh. 1 - List the components of a database.Ch. 1 - Prob. 1.19RQCh. 1 - Prob. 1.20RQCh. 1 - Prob. 1.21RQCh. 1 - What is the purpose of a DBMS?Ch. 1 - List the specific functions of a DBMS.Ch. 1 - Define the term referential integrity constraint....Ch. 1 - Prob. 1.25RQCh. 1 - List the functions of a database application.Ch. 1 - Prob. 1.27RQCh. 1 - Prob. 1.28RQCh. 1 - Prob. 1.29RQCh. 1 - Prob. 1.30RQCh. 1 - Prob. 1.31ECh. 1 - Prob. 1.32ECh. 1 - Prob. 1.33E
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-engineering and related others by exploring similar questions and additional content below.Similar questions
- 5. There are 3 people in a room, and we are curious whether two of them have their birthday in the same month. We record the triplet that describes the month of birthday for each person. E.g., (Oct, Jan, Jul) is one possible triplet/outcome. (Since each month applies to a specific person, (Oct, Jan, Jul) is not the same as (Jan, Jul, Oct), so order is important.) (a) How many possible outcomes are there? (b) In how many of these outcomes do all three people have their birthday in different months? (c) In how many of these outcomes do at least two people have their birthday in the same month?arrow_forward1. We have 8 blocks, of which 4 are green, 2 are red, 1 is white, and 1 is black. If we put the blocks in a line, how many arrangements are possible?arrow_forward3. (a) In how many ways can 3 cats and 3 dogs sit in a row? (b) In how many ways can 3 cats and 3 dogs sit in a row if the cats and the dogs are each to sit together? (c) In how many ways if only the cats must sit together? (d) In how many ways if no two animals of the same type are allowed to sit together?arrow_forward
- the gate level and the transistor level for a certain circuit are given below. Select from the given options for each space the variable name such that the transistor level design matches the gate level design. $1 => S2= M- W $3= |S4 = $5= J -R S1. S2- R S5 S3 S4arrow_forwardGiven that W, L. and tox are scaled with a scaling factor J, Vth and Vad are scaled with a scaling factor P Taking these scaling factors into consideration what is the scaling factor for metric X that equals loN C where loN is the on current of the transistor and C is the gate capacitance of the transistor. O p²/j2 O 1/P O J/P O 1/J2 O P/J2 O 1/(JP) O 1/p2 O P/J O 1/J2 O None of the other optionsarrow_forwardpython Tasks 7 • Task 1: Add a new class 'Moon` that inherits from `CelestialBody' and has an additional attribute `parent_planet. Write a method to display the moon's details along with its parent planet. • Task 2: Modify the 'Galaxy' class to calculate the total mass of all celestial bodies it contains. Implement a method `total_mass() for this purpose. • Task 3: Create a class 'BlackHole` that inherits from `Celestial Body` and adds properties like event_horizon_radius' and 'spins. Implement a method to display black hole details. • Task 4: Develop a simulation where a user can create multiple galaxies and display their celestial bodies in a hierarchical format using inheritance. 10/06/1446arrow_forward
- Please solve q2arrow_forwardself.sAge = age super().__init_("Rahul", age) # inheriting the properties of def displayInfo(self): print(self.sName, self.sAge) obj = Student("Mayank", 23) obj.display() obj.displayInfo() parent class we created the object 'obj' of the child class. When we called the constructor of the child class 'Student', it initialized the data members to the values passed during the object creation. Then using the super() function, we invoked the constructor of the parent class. Asst.L. Manar Hamza Bashaa 2024-2arrow_forwardObject-oriented programming tion defines a new type of that class. Lec 7: Static Members Object-Oriented Programming Assignment: Create a class named StudentRecords and add a static variable named records, which is a list shared among all objects of the class. Then add a method named add_record that takes a student's name as input and appends it to the shared records list.arrow_forward
- python Tasks 6 • Task 1: Develop a Student Profile class with private attributes for `name` and __ grades` (a list of grades), and methods to add a grade and calculate the average. • Task 2: Create a `Playlist class that stores song titles in a private list, with methods to add a song, remove a song, and display the current playlist. • Task 3: Implement a `Temperature Sensor class with a private `_temperature attribute, and methods to set and get the temperature in both Celsius and Fahrenheit. • Task 4: Build a Library Book class with private attributes for the title and availability status; include methods to check out, return, and display the book's availability ⚫Task 5(homework): Create a 'Counter` class with a private _ count attribute, and include get_count()` and `set_count(value)` methods to access and modify it. Ensure set_count only accepts non-negative integers, and add increment()', decrement(), and reset()` methods for control.arrow_forward3. 2. def modify_string(s): s=s+" World!" print(f"Inside the function: {s}") greeting = "Hello" modify_string(greeting) print(f"Outside the function: {greeting}") The output: Inside the function:? Outside the function: ? def modify_list(my_list): my_list.append(10) print(f"Inside the function: {my_list}") numbers = [1, 2, 3] modify_list(numbers) print(f"Outside the function: {numbers}") The output: Inside the function:? Outside the function:? Le E clas def def cla learrow_forwardThe output: tuple outside the funtion (3, 5, 7) tuple inside the funtion (3, 5, 7, 9) tuple after the funtion (3, 5, 7) Assignment 1. def modify_integer(x): X = X + 10 print(f"Inside the function: {x}") num= 5 modify_integer(num) print(f"Outside the function: {num}") The output:? Asst.L. Manar Hamza Bashaa 2024-20arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi...Computer EngineeringISBN:9780133594140Author:James Kurose, Keith RossPublisher:PEARSON
Computer Organization and Design MIPS Edition, Fi...Computer EngineeringISBN:9780124077263Author:David A. Patterson, John L. HennessyPublisher:Elsevier Science
Network+ Guide to Networks (MindTap Course List)Computer EngineeringISBN:9781337569330Author:Jill West, Tamara Dean, Jean AndrewsPublisher:Cengage Learning
Concepts of Database ManagementComputer EngineeringISBN:9781337093422Author:Joy L. Starks, Philip J. Pratt, Mary Z. LastPublisher:Cengage Learning
Prelude to ProgrammingComputer EngineeringISBN:9780133750423Author:VENIT, StewartPublisher:Pearson Education
Sc Business Data Communications and Networking, T...Computer EngineeringISBN:9781119368830Author:FITZGERALDPublisher:WILEY
Computer Networking: A Top-Down Approach (7th Edi...
Computer Engineering
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:PEARSON
Computer Organization and Design MIPS Edition, Fi...
Computer Engineering
ISBN:9780124077263
Author:David A. Patterson, John L. Hennessy
Publisher:Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:9781337569330
Author:Jill West, Tamara Dean, Jean Andrews
Publisher:Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:9781337093422
Author:Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:9780133750423
Author:VENIT, Stewart
Publisher:Pearson Education
Sc Business Data Communications and Networking, T...
Computer Engineering
ISBN:9781119368830
Author:FITZGERALD
Publisher:WILEY