LEARN MORE...

Access Millions of academic & study documents

Answers

Content type
User Generated
Subject
MySQL
School
North Carolina Central University
Type
Homework
Showing Page:
1/5
Problem 1
Entities
Customer : REGULAR ENTITY
Customer_ID : [PK] ATTRIBUTE Type:INTEGER
DOB : ATTRIBUTE Type:INTEGER
Customer_Name : ATTRIBUTE Type:VARCHAR Length=255
Customer_Address : ATTRIBUTE Type:VARCHAR Length=255
Account : REGULAR ENTITY
Account_ID : [PK] ATTRIBUTE Type:INTEGER
Account_Type : ATTRIBUTE Type:VARCHAR Length=255
Currency : ATTRIBUTE Type:VARCHAR Length=255
Balance : ATTRIBUTE Type:FLOAT
Branch_ID : ATTRIBUTE Type:INTEGER
Transactions : REGULAR ENTITY
Amount : ATTRIBUTE Type:FLOAT
Customer_ID : ATTRIBUTE Type:INTEGER
Account_ID : ATTRIBUTE Type:INTEGER
Trx_ID : [PK] ATTRIBUTE Type:INTEGER
Applies
Makes
Has
Holds
Operates
Loan
Loan_ID
Year
Amount
Branch_ID
Branch
Branch_ID
Phone_Number
Branch_Address
Bank
Bank_ID
Bank_Name
Bank_Address
Branch_ID
Transactions
Trx_ID
Amount
Customer_ID
Account_ID
Date
Trx_Type
Account
Account_ID
Account_Type
Currency
Balance
Branch_ID
Customer
Customer_ID
DOB
Customer_Name
Customer_Address

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/5
Date : ATTRIBUTE Type:TIMESTAMP
Trx_Type : ATTRIBUTE Type:INTEGER
Bank : REGULAR ENTITY
Bank_ID : [PK] ATTRIBUTE Type:INTEGER
Bank_Name : ATTRIBUTE Type:VARCHAR Length=255
Bank_Address : ATTRIBUTE Type:VARCHAR Length=255
Branch_ID : ATTRIBUTE Type:INTEGER
Branch : REGULAR ENTITY
Phone_Number : ATTRIBUTE Type:NUMERIC Length= Width=
Branch_ID : [PK] ATTRIBUTE Type:INTEGER
Branch_Address : ATTRIBUTE Type:VARCHAR Length=
Loan : REGULAR ENTITY
Loan_ID : [PK] ATTRIBUTE Type:INTEGER
Year : ATTRIBUTE Type:DATE
Amount : ATTRIBUTE Type:FLOAT
Branch_ID : ATTRIBUTE Type:INTEGER
Relationships
Operates : REGULAR RELATIONSHIP Customer ONE MANDATORY to Account MANY MANDATORY
Holds : REGULAR RELATIONSHIP Branch ONE MANDATORY to Account MANY OPTIONAL
Has : REGULAR RELATIONSHIP Bank ONE MANDATORY to Branch MANY OPTIONAL
Makes : REGULAR RELATIONSHIP Customer ONE MANDATORY to Transactions MANY
MANDATORY
Applies : REGULAR RELATIONSHIP Customer ONE MANDATORY to Loan MANY MANDATORY
Problem 2
1
The data shows:
A LastName can show (FirstName, Phone)
A FirstName can show (LastName, Phone)

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/5

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 5 pages?
Access Now
Unformatted Attachment Preview
Problem 1 Account Transactions Branch Account_ID Account_Type Currency Balance Branch_ID Trx_ID Amount Customer_ID Account_ID Date Trx_Type Holds Makes Has Operates Custom er Customer_ID DOB Customer_Name Customer_Address Branch_ID Phone_Number Branch_Address Applies Loan Loan_ID Year Amount Branch_ID Entities Customer : REGULAR ENTITY Customer_ID : [PK] ATTRIBUTE Type:INTEGER DOB : ATTRIBUTE Type:INTEGER Customer_Name : ATTRIBUTE Type:VARCHAR Length=255 Customer_Address : ATTRIBUTE Type:VARCHAR Length=255 Account : REGULAR ENTITY Account_ID : [PK] ATTRIBUTE Type:INTEGER Account_Type : ATTRIBUTE Type:VARCHAR Length=255 Currency : ATTRIBUTE Type:VARCHAR Length=255 Balance : ATTRIBUTE Type:FLOAT Branch_ID : ATTRIBUTE Type:INTEGER Transactions : REGULAR ENTITY Amount : ATTRIBUTE Type:FLOAT Customer_ID : ATTRIBUTE Type:INTEGER Account_ID : ATTRIBUTE Type:INTEGER Trx_ID : [PK] ATTRIBUTE Type:INTEGER Bank Bank_ID Bank_Name Bank_Address Branch_ID Date : ATTRIBUTE Type:TIMESTAMP Trx_Type : ATTRIBUTE Type:INTEGER Bank : REGULAR ENTITY Bank_ID : [PK] ATTRIBUTE Type:INTEGER Bank_Name : ATTRIBUTE Type:VARCHAR Length=255 Bank_Address : ATTRIBUTE Type:VARCHAR Length=255 Branch_ID : ATTRIBUTE Type:INTEGER Branch : REGULAR ENTITY Phone_Number : ATTRIBUTE Type:NUMERIC Length= Width= Branch_ID : [PK] ATTRIBUTE Type:INTEGER Branch_Address : ATTRIBUTE Type:VARCHAR Length= Loan : REGULAR ENTITY Loan_ID : [PK] ATTRIBUTE Type:INTEGER Year : ATTRIBUTE Type:DATE Amount : ATTRIBUTE Typ ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Documents

NVCC The UML Class Diagram & Notation Java Programming Languages Discussion
Develop Application – Write, Test, and Debug a Simple Application Review Fundamental concepts from the previous T...
Jquery Ajax Retrieval from Restcountries Project
jquery ajax retrieval from restcountries.com/v2/ - name, alpha 2 code, alpha 3 code; and output to jquery HTML table. I'm...
JNTU RFID Network Security Paper
I'll share my research proposal and reference to make a concept map flow chart on RFID security and privacy on Internet of...
Marymount University App Development Computer Coding Task
Write a program that calculates and displays all factors of a number with a function. A factor is any number that divides ...
Complete the test questions. For every test question, it is mandatory to include
Complete the test questions (6-10).  For every test question, it is mandatory to include at least 1 paragraph ex...
Linux String Manipulation Paper
The introduction is in the PDF. The introduction is in the PDF. The introduction is in the PDF. The introduction is in the...
Cs141 Assignment 1 Questions
You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the a...
Answers
insert into customer(store_id, first_name, last_name, email, address_id, active, create_date) values(1, 'FirstName', 'Last...
Current Network Architecture
Typically, SNHUEnergy Inc. firm has made use of Information Technology to facilitate the running of the firm operations. T...