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

Related questions

Q: 8. The following Activity table uses the JSON data type to log information about the activities of…

A: SON (JavaScript Object Notation) is a popular data interchange format used to store and exchange…

Q: Task Description: consider the following relations for a university: Student (sid: integer, sname:…

A: Here I have created the tables and then inserted the dummy values into each table. Below is the…

Q: Draw tables to show the 3NF and dependencys

A: the tables in Third Normal Form (3NF) with their dependencies: Table 1:…

Q: 2- Convert the conceptual ERD given below to logical ERD. Consider the additional requirements given…

A: there are nine tables in ER diagram. product table has primary key PId.jwellery table and elecrical…

Q: 1) What results will be produced by execution of following query? SELECT c.CustName FROM Customer c…

A: SQL queries

Q: Given the default schema of a database: Orders 123 Orderld OrderDate ADC OrderNumber 123 Customerld…

A: Please refer to the following step for the complete solution to the problem above.

Q: Consider the following relations: Employee(E_id: integer, E_name: string, Age: integer, Salary:…

A: Referential integrity constraints are rules that ensure that the references from one table to…

Q: , day of the week. Provider: In the same way the channel is hosted by provider. They have…

A: Draw an er diagram by following these constraints: Entities and attributes: Television_Channel: A…

Q: Tyler Richardson set up a house alarm system when he moved to his new home in Seattle. For security…

A: Physical address: The physical address in networking is defined as the location that is present in…

Q: For the following business rules, a sample ERD is provided below. • A painter can paint may…

A: The issue is with the relationship between GALLERY and PAINTING in the ERD. The text describes a…

Q: Using nested subqueries in SQL, find the names of all vehicle manufacturers who have plant locations…

A: Required SQL Query Is given below:

Q: Digital Wallet: the access control rule for the class Transaction and boundary use case for the…

A: Let's delve deeper into each aspect, starting with the access control rule for the Transaction…

Q: For the following business rules, a sample ERD is provided below. • A painter can paint may…

A: The objective of the question is to identify the mistake in the connectivity symbol of the ERD…

Q: Based on the following domain model class diagram, develop the relational database schemas. Owner…

A: Answer : I attached an relational schema please have a look once.

Q: Task 4: As a part of marketing strategy, the Marketing team continuously conducting an advertising…

A: Actually, database is a used to stores the data.

Q: List the default members for all the default groups Explain local groups, where are they created,…

A: As you have posted multiple questions, we will solve the first question for you. In windows, the…

Question

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)
fullName
billAddress
homePhone
account ID (key)
accountType
dateOpened
balance
branchID (key)
managerName
branchLocation
mainPhone
1.
0."
officePhone
Transaction
transID (key)
transDate
transType
transAmount
B
of

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!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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

For the table BOOKAUTHOR below you are given the following functional dependencies. BOOKAUTHOR (ISBN, BookTitle, Author_Num, LastName, Publisher, Royalty, Edition) Functional dependencies: 1. ISBN BookTitle, Publisher, Edition 2. Author Num → LastName 3. BookTitle → Publisher 4. {ISBN, Author_Num} → BookTitle, LastName, Publisher, Royalty, Edition Write the types of functional dependencies shown in (1) to (4) above. Also, decompose the table to the third normal from (3NF).
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
A relation FarmVisit is defined below with attributes in the table headings. FarmVisit visitorID visitorName date farmID farmName t1 H001 John 1 Feb 2021 A10 Green Field t2 Н005 Ashley 1 Jan 2021 A10 Green Field t3 но05 Ashley 1 Feb 2021 A10 Green Field t4 H005 Ashley 15 Apr 2021 H02 Есо t5 Но06 Ashley 15 Apr 2021 A11 Green Field a) Write down examples of tuples (i.e., tl, t2) to show neither of the following is a functional dependency: (i) visitorID -> date (ii) date -> farmID b) Write down the functional dependency (FDs) using the above data, which can represent all possible data. The FDs should be non-trivial and the determinants of the FDs should contain minimal number of attributes required. c) Using the tuples given, can (visitorID, farmID) be the primary key of FarmVisit? Explain why. d) What the highest normal form by which the FarmVisit relation can be classified? Explain why.
courses dasses ↑coursel INT courseDateTime DATETIME O room INT coursel INT courseName VARCHAR(45) course Description VARCHAR(45) room are used by a class. For each entity: Entitios rooms Froom DVT L-building VARCHAR(X) capacity VARCHAR(45) Inders The ERD depicts the data needed to track which course and Indicate if the entity is strong, weak ID-dependent, or weak non-ID-dependent For each relationship: • List the cardinality and participation of each entity in the relationship List the business rules for each relationship Indicate if the relationship is identifying or not
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
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.