The entity types and their associated attributes are,
Customer-ID à Customer-name, Account-number,
Branch-No à address, employee-ID, customer-ID
Employee-ID àemployee-name, branch-No
Account-number àbalance, branch-No, customer-ID
Customer-ID àbalance, branch-No
Customer-ID àaddress, employee-ID
Branch(branch-No, street-number, city, postcode).
Employee(employee-ID, employee-name, branch-No*)
Customer(customer-ID, customer-name, account-number*, branch-No*)
Account(account-number, balance, branch-No* , customer-ID*)
Consider the following relation schema about project meetings:
PMG(projID, title, type, manager, jobID, start-date, end-date, contractor, contractNo)
FDs based on business rules are:
2.1. The given FDs have redundancies. Give the minimal basis for the given FDs.
Project(projID, title, type, manager-ID*)
Manager(Manager-ID , manager-name, project-ID*)
Job(jobID, start-date, end-date, Contract-No*,project-ID*)
Contract(contractNo, contractor, job-ID*)
Staff(empNo , givename, surname)
openSession(sessionNo , opendate, opentime)
property(propertyNo , streetnumber, street, suburb, postcode, sessionNo*)
owner(ownerNo, address, phoneNo, ABN, entityname, ownerType, propertyNo*)
client(CustNo, givename, surname, phoneno, crediting)
Lease(leaseNo, startdate, enddate, custNo*, PropertyNo*)
Remember, at the center of any academic work, lies clarity and evidence. Should you need further assistance, do look up to our Computer Science Assignment Help
Proofreading and Editing$9.00Per Page
Consultation with Expert$35.00Per Hour
Live Session 1-on-1$40.00Per 30 min.
Doing your Assignment with our resources is simple, take Expert assistance to ensure HD Grades. Here you Go....
Get Flat 10% Discount Upto A$50 on all Assignment Orders:
Get 20% OFF upto A$40 on your First Assignment order.
Get 500 Words Free on your Assignment: