The project is about database design.

********* ***** ***** ** ***** your ******* *** ****** ********** ** ******** is ******* ***** *** ********** formed ** ***** about electronic ****** ****** Microsoft ***** and ********* ****** *** *** **** programs in **** ***** **** ** ******* *** major *********** ** ***** records ** ******** and ******* **** *** ******* ******** ******* for healthcare records in a ******** and product ******* ** a store *** ******* *** **** ******** in ******** and *********** can ** accessed easily **** them2 Database ****** **** base model ** the *********** ************ ** *** data ********** ***** are important to a database The structures consist ** the **** objects *** ************ between *** objects *** *** policy **** ***** *** operation ** *** ******** Database designIt ** *** ********** ** ********** which ****** *** ********* *********** *********** *** ********** ** an organization ** ******** **** management systems ********** ******** ******** is friendly ** *********** ********* **** reliability and ***** ** ***** ** **** ******* ****** *** ******** ****** (minimum * ****** ******* *** **** between *** ************* ** *** excel ***** attached5 3 ***** *** *** *** queries with ******** ***** ***** We **** ** ******* **** ** ** *** call ***** ** our ***** ********* ** **** ** ****** *** attributes *** we’ll **** them ***** ** ******** _id and then ** ****** ****** * list ** *** calls ******* ** employee *** start *********** ***** ********* ****** employee_id ******* start_time ****** **** * ***** **** shall return *** **** **** *** **** *** duration of **** **** ** ******* ******* *** *** previous ***** ** the ******** ******* A list ** all ***** together **** the **** *************************** ********* callstart_time ************* ** call_durationFROM callORDER ***************** ASCcallstart_time ASC;The ****** ******** ** ****** the same ** ** *** ******** query ***** columns & order) except *** one ****** ***** ******* ***** this ****** call_duration ** get the **** duration ******* **** *** *** ****** ******** ******** ** takes 3 ********* *** **** for the ********** *** need ******** ***** ********* ***** ****** **** ***** ****** ****** date-time ***** **** **** ****** value) *** ******** ******* *** **** ********** ** *** given ******* ** **** ** ****** *** ***** ******** ** *** ***** for **** ******** ** ** want ** **** * row *** **** ******** *** *** *** ** the duration ** *** ***** he ever made ******* ******** **** ***** ** ******* with *** previous ******* SUM ** **** ******** per each ******************************************************************************** ************** callend_time)) ** ********************* callINNER **** ******** ON *************** * *************** BYemployeeidemployeefirst_nameemployeelast_nameORDER ************ ********* is ******* ******* ** add regarding *** ****** *** ** *** ******* **** ** ****** *** ******* comment ** *** we ******** **** *** ****** * would **** ** ********* here are:We’ve ****** tables **** and ******** ******* ** **** data **** **** ****** ********* ******* *** **** **************** **** *** ********* ******** *** ***** ****** *** previously calculated **** ******** *** **** employeeSince we’ve ******* ********** ** the ******** ***** we **** exactly 1 *** *** **********

Click here to download attached files: Database.docx

Click here to download attached files: table 1.xlsx

Click here to download attached files: table 3.xlsx

Click here to download attached files: table 2.xlsx