Please answer questions on the picture Q.2.2Which type of relationship is shown in each case below? Motivate youranswer.Q.2.2.1managesBranchEmployee0..11..1BranchID {PK}ManagerID {FK}EmployeeID {PK}NameNameSurnameCity(2)Q.2.2.2transportsSpaceShuttleAstronaut* SpaceShuttlelID* AstronautIDNameNameSurname(2)Q.2.2.3 Table: PersonPrimary key: PersonIDPersonIDSurnameName1ModiseDikelediRomanoDonatelloTable: QualificationPrimary key: QualificationIDForeign key: PersonIDQualificationIDPersonIDDescription971BCIS (Application Development)98BCIS (Game Design andDevelopment)99BA (Graphic Design)(2)

Here have to determine about type of relationship of given table.

2.2 Which type of relationship is shown in each case below? Motivate your answer. Q.2.2.1 manages Branch Employee 0..1 BranchID {PK} ManagerID {FK} 1.1 EmployeeID {PK} Name Name Surname Gity Q.2.2.2 SpaceShuttle + transports KAstronaut * SpaceShuttlelID * AstronautID Name Name Surname Q.2.2.3 Table: Person

2.2 Which type of relationship is shown in each case below? Motivate your answer. Q.2.2.1 manages Branch Employee 0..1 BranchID {PK} ManagerID {FK} 1.1 EmployeeID {PK} Name Name Surname Gity Q.2.2.2 SpaceShuttle + transports KAstronaut * SpaceShuttlelID * AstronautID Name Name Surname Q.2.2.3 Table: Person

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Create a knowledge base using frames for the description of the domain given below. Arepresentation must contain at least one class frame and all types of relations available inframes. Roland Greenberg was born in Germany in 1973. He is a sociologist by his education and has 15scientific publications. Roland collects stamps. His collection consists of 36,000 stamps from 1910to 1960. The follwoing information is known about each stamp: year of issue, title, country,monetary value and special marks (if any). One of the stamps is a stamp issued in Germany in1942 "Make the planet free!". It costs 50,000 EUR, because the stamp of the German post is seton it. Another stamp is the "Classic Fashion" released in France in 1956. It costs 3000 EUR. Could you please solve problem given above? Thanks
Using the Crow's foot notation,create an ERD that can be implemented for a medical clinic using the following business rules:A patient can make many appointments with one or more doctors in the clinic,and a doctor can accept appointments with many patients.however each oppointment is made with only one doctor and one patient.Emergency patients do not ned an appointment .However,for appointment management purposes,an emergency is entered in the appointment book as"unscheduled."If kept,an appointment yields a visit with the doctor specified in the appointment.The visit yields a diagnosis and ,when appropriate, treatment.With each visit,the patient's records are updated to provide a medical history.Each patient visit creates a bill.Each patient visit is billed by one doctor,and each doctor can bill many patients.Each bill must be paid.However a bill may be paid in many instalments,and a payment may cover more than one bill.A patient may pay the bill directly,or the bill may be the basis…
correct and detailed answer will be upvoted else downvoted. Ivan is playing one more roguelike PC game. He controls a solitary saint in the game. The saint has n hardware spaces. There is a rundown of ci things for the I-th opening, the j-th of them builds the legend strength by ai,j. The things for each opening are pairwise unmistakable and are recorded in the expanding request of their solidarity increment. In this way, ai,1<ai,2<⋯<ai,ci. For each space Ivan picks precisely one thing. Let the picked thing for the I-th space be the bi-th thing in the comparing list. The arrangement of decisions [b1,b2,… ,bn] is known as a form. The strength of a form is the amount of the strength increments of the things in it. A few forms are prohibited from the game. There is a rundown of m pairwise unmistakable restricted forms. It's reliable that there's no less than one form that is not restricted. What is the develop with the greatest fortitude that isn't prohibited from…
Case Study:Consider an online shopping website that maintains a shopping cart. A user can search productsand place order and can make payment for it either online or cash on delivery. If a user placean order of amount RS 2500 or above he gets home delivery of the product for free, otherwisehe has to pay Rs 250 extra for home delivery. There are different types of users based onmembership Guest User (No membership), Gold User, Platinum User. Guest user doesn’t getany discount, Gold user gets 5% off on every product, Platinum User get 7.5% on everyproduct. Question No. 2: Draw Activity diagram for the case study above ? Question No. 3: Draw Class diagram for the case study above. ?
Which of the following is FALSE about managing access control during system design? I. Each entry in an access matrix represents an access right. II. Global access table is the best implementation for access matrix. III. A capability provides an actor to gain control access to an object of the class described in the capability. IV. Access matrix implementations provide dynamic access control. A III and IV B I and III C II and IV D I, II, and IV E II, III, and IV
Using the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic using the following business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be paid in many instalments, and a payment may cover more than one bill. A patient may pay the bill…
Label each phrase as either interpretation sharing, projection sharing, or fact sharing. Note: each information sharing type is used once. Diesel is leaking from the ship onto the dock. Answer (circle one): interpretation sharing, projection sharing, fact sharing. There is a fire station near the diesel leak. Those firefighters have been trained to respond to small diesel spills. Answer (circle one): interpretation sharing, projection sharing, fact sharing. If the ship leaks more than 10,000 gallons of diesel, then we will need to send in additional firefighters and specialized equipment trucks through Route B. Answer (circle one): interpretation sharing, projection sharing, fact sharing.
val isPresent = intent.getBooleanExtra("present", false)val technology = intent.getStringExtra("technology")val plugged = intent.getIntExtra("plugged", -1)val scale = intent.getIntExtra("scale", -1)val health = intent.getIntExtra("health", 0)val status = intent.getIntExtra("status", 0)val rawLevel = intent.getIntExtra("level", -1)val voltage = intent.getIntExtra("voltage", 0)val fastchargestatus = intent.getBooleanExtra("fastcharge_status", false)val temperature = intent.getIntExtra("temperature", 0)var level = 0if (isPresent) {if (rawLevel >= 0 && scale > 0) {level = rawLevel * 100 / scale}voltageValue = voltage / 1000.0fbinding.PowerSource.text = getPlugTypeResultString(plugged)binding.BatteryVoltage.text = " $voltageValue V"binding.BatteryStatus.text = getStatusResultString(status)
Given the below three scenarios, you’re required to create one Test Suite containing 3 Test casesand one separate test case for each scenario, where you should add the suitable test scripts thatcan confirm the success of these scenarios using Robot Framework. Deliverables One folder containing one TestSuite.robot file.Scenario 1: Verify user can search for a movie on the IMDb homepage● Given that the user is on the IMDb homepage "https://www.imdb.com/"● When the user enters a search query "The Shawshank Redemption" (or any other moviename) in the search bar.● And clicks the search button● Then the search results page should display movies related to the search query.● And the first search result should be "The Shawshank Redemption" movie i.e. the namewritten in the search query. Scenario 2: Verify user can access the top-rated movies section● Given that the user is on the IMDb homepage "https://www.imdb.com/".● When the user clicks on the "Top 250 Movies" link in the header.● Then the…
Question 10 sis Good always tell the truth Bad always lies. use a truth table to determine what type each person is or if their status cannot be determined.A: “I am Good or B is Bad”B: “A is Bad if C is Good”C: “I am Bad or A is Bad only if B is Good" Please show work and address all parts Don't ignore any part all part work u
A company has various rules for how payments to suppliers are to be authorized.Some payments are in response to an approved purchase order. For approved purchase orders under $5,000, the accountingclerk can immediately issue a check againstthat purchase order and sign the check. Forapproved purchase orders between $5,000and $10,000, the accounting clerk can immediately issue a check but must additionallyobtain a second signature. Payments for approved purchase orders over $10,000 alwaysrequire the approval of the accounting manager to issue the check as well as the signature of two accounting clerks. Payments thatare not covered by a purchase order that areunder $5,000 must be approved by the accounting manager and a departmental manager who will absorb the cost of the paymentinto that department’s budget. Such checkscan be signed by a single accounting clerk.Payments that are not covered by a purchaseorder that are between $5,000 and $10,000must be approved by the accounting…
can you make ER Diagram with Crow`s foot method about library system. The rule: 1. A member can borrow more than one book at a time 2. A member can have more than one phone number 3. A book can have more than one author 4. All book registration, member and borrowing processes can only be done/served by officers 5. Data for books, members and officers are stored with a unique id, so no id is the same.