The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 398 Weeks Ago, 2 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
1. Task1: Relational Database Management
Food and Beverages case is considered for evaluating the relational database management and three important tables like Customer, Invoice and Product are created. All the three tables are created and related against the basic primary and secondary key constraints using the Microsoft Access Database and the design process followed to create the tables, forms, query and data are explained as below (Pieper, 2004)
1.1 Customer Table
Â
Customer table is used to track the details of customers and the key fields used for this table are as listed below
Â
· Customer reference number
· Customer Title
· Customer First name
· Customer Last name
· Customer Address
· Customer Postcode
· Customer Telephone number
· Customer Email address
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll