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)
A Employee Location Attributes employe id location id location descript... 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,...
-
Stems of the first land plants functioned primarily as transport and support structures. Modern stems have these functions also, plus several more. Describe the additional functions.
-
a) What is a relational database? Explain. b) Why would a database administrator want to restrict access to certain tables? c) Why would a database administrator want to restrict access to certain...
-
Aylward, Inc. currently has $2,145,000 in current assets and $858,000 in current liabilities. The company's managers want to increase the firm's inventory, which will be financed by a short-term note...
-
Assume that Fossil paid expenses totaling \($40,000\). How does this transaction affect Fossils accounting equation? a. Increases assets and decreases liabilities b. Decreases assets and increases...
-
The plant manager of Shannon Electronics Company is considering the purchase of new automated assembly equipment. The new equipment will cost $2,400,000. The manager believes that the new investment...
-
1 . Firms institute a variety of brand - related strategies to create and manage key brand assets that includes like brand extension and line extension, manufacturer brands and private - label...
-
In early 2016, Doc and Lyn McGee formed the McGee Cake Company. The company produced a full line of cakes, and its specialties included chess cake,* lemon pound cake, and double-iced, double...
-
CAL inc recently started a zipline operation in Kamloops, British Columbia. As part of an initiative to boost tourism, the Canadian government agreed to loan the necessary land to CAL for a five-year...
-
There are three components in the triple bottom line: people, planet, and profit. Which component do you think is most important? Why?
-
Marginal utility refers to: a. the extra level of electricity from a public utility b. the level of satisfaction from consuming a good c. utility derived from consuming a good d. a change in utility...
-
Describe at least two reasons that a companys ratios might not be comparable over time.
-
Describe at least four financial conditions that may signal financial trouble.
-
Information from an environmental management accounting (EMA) system can be used to support managers and their primary responsibilities of planning, directing, and controlling. Think of an...
-
The following are a few Christian viewpoints on Debt "Debt is considered slavery " Proverbs 22:7, I Corinthians 7:23 "Debt was considered a Curse", Deut 28: 1,2,12, Deut 28: 15, 43, 44 "Debt Presumes...
-
In the current year, the City of Omaha donates land worth $500,000 to Ace Corporation to induce it to locate in Omaha and create an estimated 2,000 jobs for its citizens. a. How much income, if any,...
-
The issue of homelessness has continued to grow over the years. In addition to defining homeless students as those who lack "a stable, long-term place to reside," our textbook authors also explain...
-
Reread the inflation shock example (event #1) in Section 13.5. Suppose the size of the shock is 0. (a) In the AS/AD graphs describing the response of the economy to the inflation shock, we labeled...
-
Consider the user cost of capital in the presence of taxes, starting with equation (17.5). Suppose the price of capital, pk, is constant, so there is no capital-gain term. What is new, however, is an...
-
Suppose a friend of yours decides to write a novel. Explain how ideas and objects are involved in this process. Where do nonrivalry and increasing returns play a role? What happens if the novel is...
-
Derive the equation of motion and natural frequency for a mass \(m\) on the string that is under constant tension \(T\) as shown in Figure 2.44. Assume small displacements and that \(m\) is much...
-
Continuing Problem 13, the string is stretched to the position shown in Figure 2.45. Calculate the natural frequency of the system using the following parameter values: \(m g=2 \mathrm{lb}, T=50...
-
Derive the equation of motion for a uniform stiff rod restrained from vertical motion by a torsional spring of stiffness \(K\) and two translational springs each of stiffness \(k\), as shown in...
Study smarter with the SolutionInn App