Create a new table that will be used to track employee location. The attributes associated with the
Fantastic news! We've Found the answer you've been seeking!
Question:
Create a new table that will be used to track employee location. The attributes associated with the table: employee id, location id, location description, street address, city, state, zipcode. Create a new table the attributes listed above. Please identify the primary key. It has a relationship with employees. Provide SQL statement
Transcribed Image Text:
Authors AuthorlD FirstName LastName YearBom YearDied Description 1 BooksAuthors AuthorID TitleID Customers Customer D FirstName LastName Phone Address1 Address2 City State Zip OrderStatus StatusID Status Descip 00 Books TitlelD Title Publisher PubDate Edition Cost SRP ConditionID Sold BooksOrders OrderD TitlelD Orders OrderlD CustomerlD EmployeelD Amount OrderDate DeliveryDate PaymentID StatusID 00 FormOfPayment PaymentID Payment Descrip Authors ConditionID ConditionName Description Employees Employee D FirstName LastName Address1 Address2 City State Zip Phone DOB HireDate PositionID 00 1 Positions Position D Title Job Descrip Authors AuthorlD FirstName LastName YearBom YearDied Description 1 BooksAuthors AuthorID TitleID Customers Customer D FirstName LastName Phone Address1 Address2 City State Zip OrderStatus StatusID Status Descip 00 Books TitlelD Title Publisher PubDate Edition Cost SRP ConditionID Sold BooksOrders OrderD TitlelD Orders OrderlD CustomerlD EmployeelD Amount OrderDate DeliveryDate PaymentID StatusID 00 FormOfPayment PaymentID Payment Descrip Authors ConditionID ConditionName Description Employees Employee D FirstName LastName Address1 Address2 City State Zip Phone DOB HireDate PositionID 00 1 Positions Position D Title Job Descrip
Expert Answer:
Answer rating: 100% (QA)
Employee Location Attributes employe id location id location descripti... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
Create a new table that will be used to track employee location. The attributes associated with the table: employee id, location id, location description, street address, city, state, zipcode. Create...
-
Create a new table that will be used to track employee location. The attributes associated with the table: employee id, location id, location description, street address, city, state, zipcode. Create...
-
1. Create a new table that will be used to track the tblCustomer address and contact information. The attributes associated with the table: customer_id, address_type street address, city, state,...
-
When a parameter is changed, does this affect the argument that was passed into the parameter?
-
The magnetic field between the poles of an electromagnet is 2.6 T. A coil of wire is placed in this region so that the field is parallel to the axis of the coil. The coil has electrical resistance 25...
-
An epidemiologist from the CDC was presenting a report on the status of AIDS to a congressional committee. In concluding her remarks, she noted that from an epidemiological perspective it was more...
-
In a survey of South African CEOs, the annual incomes were normally distributed, with a mean of \($7.14\) million and a standard deviation of \($0.5\) million. Find the probability that a randomly...
-
Consider the data shown in Table 12E.1. The target value for this process is 200. (a) Set up an integral controller for this process. Assume that the gain for the adjustment variable is g = 1.2 and...
-
Tarrant Amertex Regional Hospital, one of our hospitals in the Fort Worth area, has been in need of a new Chief Executive Officer. Last week, we reached a "handshake" dealthough per current protocols...
-
Give two characteristics of each type of legal standard: statute, case, and regulation. (An example of a characteristic would be the source of the legal standard.)
-
Goldie and Kurt want advice from your financial advising firm. They have provided the following information. They graduated from university four years ago and they have good jobs, but neither of them...
-
Fill in the blank field in this text: Clicking on the[1]_________________________ next to the Zoom icon will list additional zoom tools not currently shown in the View toolbar.
-
Revit comes with many predefined doors and windows. A) True B) False
-
Fill in the blank field in this text: The icon with the floppy disk picture allows you to [1]__________ a project file.
-
Skylights need to be rotated to align with the plane, or pitch, of the roof. A) True B) False
-
When using the Mirror tool, you occasionally need to draw a temporary line that represents the Axis of Reflection. A) True B) False
-
ExplainCapital Structure and give an example.Define Capital Structure and give an example.
-
The liquidliquid extractor in Figure 8.1 operates at 100F and a nominal pressure of 15 psia. For the feed and solvent flows shown, determine the number of equilibrium stages to extract 99.5% of the...
-
A bank manager has n clients waiting to be served, all of whom arrived at the same time. Let us call the time at which these clients arrive to be 0. The manager estimates that client i requires t;...
-
Suppose scientists discover a new way to extract oil from deposits that were previously thought to be unrecoverable. The extra supply of oil leads oil prices to decline by $5 per barrel. Explain the...
-
In the simple theory developed in the chapter, why is the stock price equal to the dividend divided by interest rate (net of the capital gain)?
-
Why do countries trade? What are the benefits and costs of trade?
-
(a) Complete a steady-state simulation of the vinyl-chloride process in Figure 2.6. First, create a simulation flowsheet. Assume that: Cooling water is heated from 30 to \(50^{\circ} \mathrm{C}\)...
-
For the monochlorobenzene separation process in Figure 7.14, the results of an ASPEN PLUS simulation are provided in the multimedia modules under ASPEN \( ightarrow\) Principles of Flowsheet...
-
Complete a simulation of the entire process for the hydrodealkylation of toluene in Figure 6.14. Initially, let the purge/recycle ratio be 0.25 ; then, vary this ratio and determine its effect on the...
Study smarter with the SolutionInn App