Based on the following domain model class diagram, answer the followings: 1) How many accounts can a customer have? 2) How many branches can a customer be assigned to? 3) How many customers can a branch have? 4) What attributes can you use for keys? Customer Account Branch custNumber (key) fulName billAddress homePhone officePhone account ID key) branchID (key) managerName branchLocation mainPhone accountType 1 1. 0. 1 dateOpened balance Transaction transID (key) transDate transType transAmount

Based on the following domain model class diagram, answer the followings: 1) How many accounts can a customer have? 2) How many branches can a customer be assigned to? 3) How many customers can a branch have? 4) What attributes can you use for keys? Customer Account Branch custNumber (key) fulName billAddress homePhone officePhone account ID key) branchID (key) managerName branchLocation mainPhone accountType 1 1. 0. 1 dateOpened balance Transaction transID (key) transDate transType transAmount

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

Given the following relation(s) and the functional dependencies, what is the highest normal form the data model complies to? Note: Primary keys are indicated in bold. TaxiRide (jobID, jobDateTime, driverID, driverName, taxiID, clientID, clientName, jobPickUpAddress)jobID -> jobDateTime, driverID, driverName, taxiID, clientID, clientName, jobPickUpAddressjobDateTime, driverID -> jobID, driverName, taxiID, clientID, clientName, jobPickUpAddressjobDateTime, taxiID -> jobID, driverID, driverName, clientID, clientName, jobPickUpAddressjobDateTime, clientID -> jobID, driverID, driverName, taxiID, clientName, jobPickUpAddressdriverID -> driverName, taxiIDclientID -> clientName A)1NF B)2NF C)3NF
entities: Residential students which fields like student id, Student name, exam papersTransfer students with fields like student id, transferred school, exam papers etc.Exam papers with fields like subjects, total marks, invigilator, checkers.Exam center with fields like Center Id, location, seating capacity etc. -Create an ER Diagram using the enumerated entities.
Given that a student must have a class. If class has as primary key ClassID, what foreign key field(s) is (are) found in the entity student? A. Class B. ClassID, StudentID C. Class cycle D. ClassID
Let's break down the information into entities, attributes, and relationships: Entities: 1. Ship - ShipID (Primary Key) - ShipName - ShipType 2. Captain - CaptainID (Primary Key) - CaptainName - CaptainLicense 3. ShipmentTrip - TripID (Primary Key) - DeparturePort - ArrivalPort - RouteDetails 4. ShipmentManifest - ManifestID (Primary Key) - Date - GoodsList 5. Goods - GoodsID (Primary Key) - GoodsName - GoodsType (BM or LM) 6. Port - PortID (Primary Key) - Street - City - State - PostalCode - Country Relationships: - Ship to ShipmentTrip (Many-to-Many): - Ship can participate in multiple ShipmentTrips, and a ShipmentTrip can involve multiple Ships. Create a junction table `Ship_ShipmentTrip` with attributes `ShipID` and `TripID`. - Captain to ShipmentTrip (Many-to-Many): - A Captain can be assigned to multiple ShipmentTrips, and a ShipmentTrip can have multiple Captains. Create a junction table `Captain_ShipmentTrip` with attributes `CaptainID` and `TripID`. - Captain to Ship…
create an Entity Relationship Diagram using the following Entities and their respective attritubes for an online programming competition registration for both leaners and university students. 1. Host it's attributes (host Id, hostFirstName,hostLastName, hostTelNum,hostEmail,hostPassword) 2. Student(StudentId, StudentfirstName, Student Email, StudentPassword, InstitutionName) 3. Learners(leaner Id, leanerFirstName, leanerLastName, leanerPassword, SchoolName) 4. Competition(compId, comName, compDate,comTime, compRules, compRequirements) 5. Qualified Student/Leaner (id, firstName, compId,email)
For the following business rules, a sample ERD is provided below. • A painter can paint may paintings. Each painting is painted by only one painter. A gallery can exhibit many paintings. • A painter can exhibit paintings at more than one gallery at a time. • Each painting is exhibited in only one gallery. In the ERD below, an entity is missing a foreign key. Click on the entity that is missing the foreign key. PAINTER PAINTING PK Painter Num PK Painting Num Painter_LName paints но- Painter FName Painting Title FK Gallery Number Painter_Initial O is shown in GALLERY PK Gal Num Gal_Name Gal_Web
Write the Guidelines to create a domain model
14. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique. a. Rows b. Key c. Attribute d. Fields
Multiple choice in network Is a subtype of a membership query message. a. Group-and-source specific query b. General query c. Group-specific query d. All choices
Consider the following schema: Publisher (name, phone, city), PK: name. Book (ISBN, title, year, published_by, previous_edition, price), PK: ISBN, FK: published_by refs Publisher, previous_edition refs Book. Author (SSN, first_name, last_name, address, income), PK: SSN. Write (aSSN, bISBN), PK: (aSSN, bISBN), FK: aSSN refs Author, bISBN refs Book. Editor (SSN, first_name, last_name, address, salary, works_for, book_count), PK: SSN, FK: works_for refs Publisher. Edit (eSSN, bISBN), PK: (eSSN, bISBN), FK: eSSN refs Editor, bISBN refs Book. Author_Editor (aeSSN, hours), PK: aeSSN, FK: aeSSN refs Author, aeSSN refs Editor. Give SQL statements for the following plain English language queries based on the above schema.
Giving the following schema for a supermarket database, specify the domain constrains for each attribute. CUSTOMERS (CustomerID , First_Name, Last_Name) EMPLOYEES (EmployeeID, Name, Email, PhoneNo) INVOICES( InvoiceID, Amount_Paid, Invoice_Date)
Assume, a sales firm using an automated system in their work. They maintain a database of SalesOffice, Employee and their Properties. Without any normalization, all information is stored in one table as shown below. Normalize the form below to UNF, 1NF, 2NF and 3NF. Show primary keys and foreign keys of tables in 3NF. Sales Firm Form SalesOffNo Location ContactNo EmplCode EmplName Salary Property-Id PropertyArea TotalSale SaMus Muscat 24897564 EmC1 Khalil 654 Pr02 2000 5234 EmC2 Sultan 985 Pr34 1250 4295 SaShr Sohar 27564911 EmC3 Abdullah 852 Pr55 1700 11240 EmC4 Jumah 652 Pr66 850 34515