Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
- The following is a sample report from a child clinic. It shows the days and treatments for visits to doctors at the clinic. A mother takes her child, sees a doctor and the doctor administers some treatment. There are couple of things you should assume:
- The mother’s name is unique.
- a mother won't have more than one child with the same name
- the doctor's surname is unique
- a treatment code is unique
- treatments are specific to doctors, eg 101 is only ever given by Johnson
Surname |
First Name |
Town |
Age |
Child |
Doctor |
Date |
Treatment |
Smith |
Jane |
Coventry |
30 |
Rebecca |
Johnson |
27.3.04 |
101 |
|
|
|
|
Brian |
Clarence |
30.5.04 |
209 |
|
|
|
|
Robert |
Johnson |
10.1.88 |
101 |
Brown |
Beryl |
Rugby |
28 |
Alan |
Clarence |
30.4.04 |
214 |
|
|
|
|
Sarah |
Johnson |
29.5.04 |
101 |
|
|
|
|
Sarah |
Clarence |
12.1.04 |
321 |
Jones |
Fiona |
Kenilworth |
34 |
James |
Clarence |
30.4.04 |
322 |
|
|
|
|
Jenny |
Clarence |
11.1.04 |
321 |
|
|
|
|
Keith |
Johnson |
21.4.88 |
409 |
|
|
|
|
Simon |
Clarence |
11.1.04 |
321 |
- From the functional dependencies, identify;
- Functional dependencies
- Partial dependencies
- Transitive dependencies
- Keys (primary key, Foreign key )
- Normalise to 3rd Normal form.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Last month Joe purchased some stock in Acme Software, Inc. Here are the details of thepurchase:• The number of shares that Joe purchased was 1,000.• When Joe purchased the stock, he paid $32.87 per share.• Joe paid his stockbroker a commission that amounted to 2% of the amount he paidfor the stock.Two weeks later Joe sold the stock. Here are the details of the sale:• The number of shares that Joe sold was 1,000.• He sold the stock for $33.92 per share.• He paid his stockbroker another commission that amounted to 2% of the amount hereceived for the stock.Write a program that displays the following information:• The amount of money Joe paid for the stock. • The amount of commission Joe paid his broker when he bought the stock. • The amount that Joe sold the stock for. • The amount of commission Joe paid his broker when he sold the stock. • Display the amount of profit that Joe made after selling his stock and paying the twocommissions to his broker. (If the amount of profit that your…arrow_forwardPlease answer.. It's urgent. Don't reject Read carefully and write codearrow_forwarddiscrete structure could you help me with these two questionsarrow_forward
- Quèstion 17 Procedures are semantically modeled on mathematical functions that are designed to return a single value to another part of the program. True Falsearrow_forwarduse this code template to help you continue: private boolean included Indicates whether the item should be taken or not public Item(String name, double weight, int value) Initializes the Item’s fields to the values that are passed in; the included Field is initialized to false public Item(Item other) Initializes this item’s fields to the be the same as the other item’s public void setIncluded(boolean included) Setter for the item’s included field (you don’t need setters for the other fields) Given code: public class Item { private final String name; private final double weight; private final int value; public Item(String name, double weight, int value) { this.name = name; this.weight = weight; this.value = value; } static int max(int a, int b) { if(a > b) return a; return b; } // function to print the items which are taken static void printSelection(int W, Item[] items, int…arrow_forwardthe only data that should b epresented as numerical values are those that represent numbers. data that represent categories should never be presented as numerical values. TRUE or FALSEarrow_forward
- Please write code for this: Canadian Computing Competition: 2022 Stage 1, Junior #2 Fergusonball players are given a star rating based on the number of points that they score and the number of fouls that they commit. Specifically, they are awarded 5 stars for each point scored, and 3 stars are taken away for each foul committed. For every player, the number of points that they score is greater than the number of fouls that they commit. Your job is to determine how many players on a team have a star rating greater than 40. You also need to determine if the team is considered a gold team which means that all the players have a star rating greater than 40. Input Specification The first line of input consists of a positive integer N representing the total number of players on the team. This is followed by a pair of consecutive lines for each player. The first line in a pair is the number of points that the player scored. The second line in a pair is the number of fouls that the player…arrow_forwardhelparrow_forwardCreate the following variables that can be used to store values. Use the naming conventions as outlined in the Algorithms/Pseudocode Guidelines document in the course resources section of the course. 1. test grade for student test 2. total of all test grades added together 3. the average for the test grades Create an assignment statement that sets the value of the variable you created to store the value of all test grades added together to zero. You may refer to Table 6.1 in Chapter 6 for examples. Create an input statement to input the value for the first test grade for the variable you created. Create an algorithm that will obtain the test grade for three students, add the test grades together, calculate the average of the test grades, and output the average. Use a count-controlled loop to create the algorithm. Use the information from your answers to questions 3, 4, and 5 in the creation of your algorithm. Also use information and examples from Chapter 6…arrow_forward
- Instructions Assuming you are registered in a class with several activities/categories (quizzes, labs, homework, attendance, etc.), you would like to keep track of your grades throughout the quarter. For each category, you need to add your grade, e.g., for the labs you got 100 in lab 1, 95 in lab 2, etc. How are we going to store our grades for each category? Remember that in our main program, we keep the information for various grade categories. This information is stored as a list of lists, which can, for example, look like this: [["Lab", 35], ["Quiz", 35]] Each list that is contained in the main “database” (a list of lists) contains information about a category and its corresponding grade percentage. If for the labs, you got 100 in lab 1, 95 in lab 2, we can store this information for the “Lab” category as an additional list: ["Lab", 35, [100, 95]] This means that our database would then look like this (note the nesting of the grades): [["Lab", 35, [100, 95]], ["Quiz", 35]] In order…arrow_forwardTask 2 Use function to calculate Computer Skills. Both skills Yes: show "Sufficient", only one skill: show "Good", no skill: show "Poor" Computer Skills Student ID 521370 811298 780223 528112 427747 207676 158877 154194 480967 962948 701444 803700 268544 975048 204401 846716 127466 621984 285594 826758 972888 739477 857713 339297 249521 868320 872950 198271 702356 726662 365857 136850 492928 850557 987114 776815 666031 904552 161237 268716 Software Skill Yes Yes Yes No Yes Yes No Yes No No Yes No No Yes Yes No No No Yes Yes Yes Yes Yes Yes Yes Yes No Yes No Yes No Yes No Yes No Yes No Yes Yes Yes Hardware Skill No Yes Yes No Yes Yes No No Yes No Yes No No No No Yes No No No No Yes Yes Yes Yes No No Yes No Yes No Yes Yes | No Yes Yes Yes No Yes Yes Yesarrow_forwardBuilding Arena models: A few years ago, I was in a group involved with building industrial facilities. A team of consultants visited us to make a presentation about improving the building process. They had a demonstration in the form of a game. We were divided into two teams of four and sat four in a row at a table. Person 1 was given 100 poker chips. The game process was Person 1 would roll a single die. Whatever the number was, he or she would pass that number of chips to Person 2. Person 2 would roll the die, and • If the number of the roll is less than or equal to the chips in front of Person 2, the number of the die roll is passed to the next person. Any remaining chips stay in place, to be passed on another turn when possible.• If the roll on the die is greater than the number of the chips in front of Person 2, all the chips are passed, but the difference in what could be passed is lost on that turn. For example, if Person 2 has 3 chips and rolls a “1,” then one chip is passed.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education