You helped me a few weeks ago with an Access DB question. Now I have a similar one in SQL. The areas I am struggling is relationships and SQL coding. I have attached the assignment and my Week1 assignment I have to build from in this. Please take a look and let me know if you are able to help. I need to hand this in before January 29, 2017.  This course goes on for another three weeks, so I will contact you if I have more questions about this - which I likely will.

I should mention that because my understanding of relationships is weak, my Primary/Foreign key assignments in the Word document may not be correct. Please let me know if you have feedback on that. I would very much like to understand relationships better, but the courses I take on onine and I am not getting very good support from the Instructor.

Thank you!

Brandon

 

Running head: BUSINESS PROPOSAL 1 BUSINESS PROPOSAL
Brandon Starks
Carlotta Persaud
DBM/294
January 21, 2017 DATABASE MANAGEMENT BUSINESS PROPOSAL BUSINESS PROPOSAL 2 Currently no work order or ticketing system exists within our organization. As a
result, neither planned or ad hoc service is prioritized, communicated, or accounted for on a
regular basis. In fact, we do not currently know how long our current planned work would
take us because we have no handle on the time commitments of our project – not service –
workload. As a result, dissatisfaction is growing both among our internal customers as well as
our service employees.
As a solution to this issue A work ticketing system should be built within a database
management system. Such a system will help to collect and organize information we need as
a snapshot of where we currently sit regarding work-hour commitments, allow us to better
plan and track our commitments in the future, and serve as a transparent communications
channel with our internal customers allowing them to see the status and priority of their
request as well as those priorities which we set above their own. The overall design of the
database proposed to solve this business problem is as follows: BUSINESS PROPOSAL 3 Below is a description of what each table should represent and it’s need within the new
system:
Table 1: Technician Table
EmployeeID (Primary
Key)
Integer LocationID (Foreign
Key)
Integer Concept: This table will identify the specific Technician who is assign to individual work tickets. This
will allow the list of technicians to be updated independent of other ticket information. Table 2: Technician Territory
EmployeeID (Foreign Key) TerritoryID (Primary Key) Integer Integer Concept: Allows list of technicians to be manipulated by ID and track metrics for certain areas. For
example, if a business were extending their branching network into a new territory this would allow
a comparison between it and an existing region. Table 3: Table: Territory Description
TerritoryID (Primary Key) TerritoryDescription
Integer
ntext
Concept: Create profile of a territory to compare similarities and differences when comparing
territory metrics. This is a seldom used Table and can be held alone for an indexing optimization
function. Table 4: Employee
EmployeeID (Primary
Key)
Integer LocationID (Foreign
Key)
Integer Concept: Table will allow to match work tickets with the employee who requested work done. Table 5: WorkTicket
TicketID (Primary Key) EmployeeI
D
Integer
Integer
Allows ticket to be assigned to a technician. TechnicianID (Foreign Key)
Integer BUSINESS PROPOSAL 4 Table 6: TicketDetail
TicketID LocationID (Primary
Key)
Integer
Integer WorkDetail
ntext Concept: Allows information to be provided to the technician working on the ticket. This is created in
a separate table as an indexing function for database optimization. Table 7: Materials
ParkID (Primary
Key)
Integer PartName
nvarchar20
0 Concept: Allows specific parts to be assigned to work for activity based accounting purposes. In the
future, could be tied into an hourly cost for further accuracy. Could also be included in an inventory
system or asset management system.

• 1493945957-Week2Assignment.PNG
• 1493945958-CH WK1 Assignment.docx

ComputerScienceExpert

(11)

Status NEW Posted 05 May 2017 12:05 AM My Price 11.00

-----------

Attachments

file 1493945961-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer