Question

In: Computer Science

StudentNumber StudentName SiblingName Major 100 Jose Eric Marketing 100 Jose Teddy Marketing 100 Jose Jorge Marketing...

StudentNumber

StudentName

SiblingName

Major

100

Jose

Eric

Marketing

100

Jose

Teddy

Marketing

100

Jose

Jorge

Marketing

200

Rex

Chris

Business

200

Rex

Rick

Business

  1. Show the final relations in 3NF. Every relation name must be in all CAPS and your primary key(s) & foreign key(s) should be underlined. Be sure to identify relationships by stating "RELATION1.FK references RELATION2.PK".

B. Let's change the original assumption and allow a student to have multiple majors. Based on your answers to Part A, show an example of adding a second major to your second student, who has two siblings.

C. Did allowing multiple majors per student introduce redundancies? If so, let's normalize again and show your final relations in 3NF. Every relation name must be in all CAPS and your primary key(s) & foreign key(s) should be underlined. Be sure to identify relationships by stating "RELATION1.FK references RELATION2.PK".

Solutions

Expert Solution


Related Solutions

Jose and Jorge were identical twins separated at birth. Jose grew up in a large family...
Jose and Jorge were identical twins separated at birth. Jose grew up in a large family in an impoverished slum in the middle of a crime-ridden and polluted district of a major city. Jorge grew up in an upper-middle-class professional family with one other brother in a sub­ urban community in the same city. Despite the fact the Jose and Jorge were identical twins, their lives and health could not have been more different. Jose had few opportunities for medical...
To ensure a full line of outdoor clothing and accessories, the marketing department at Teddy Bower...
To ensure a full line of outdoor clothing and accessories, the marketing department at Teddy Bower insists that they also sell waterproof hunting boots. Unfortunately, neither Teddy Bower nor TeddySports has expertise in manufacturing those kinds of boots. Therefore, Teddy Bower contacted several Taiwanese suppliers to request quotes. Due to competition, Teddy Bower knows that it cannot sell these boots for more than $54. However, $40 per boot was the best quote from the suppliers. In addition, Teddy Bower anticipates...
To ensure a full line of outdoor clothing and accessories, the marketing department at Teddy Bower...
To ensure a full line of outdoor clothing and accessories, the marketing department at Teddy Bower insists that they also sell waterproof hunting boots. Unfortunately, neither Teddy Bower nor TeddySports has expertise in manufacturing those kinds of boots. Therefore, Teddy Bower contacted several Taiwanese suppliers to request quotes. Due to competition, Teddy Bower knows that it cannot sell these boots for more than $54. However, $40 per boot was the best quote from the suppliers. In addition, Teddy Bower anticipates...
Finance Minister Eric Girard announced that the province will give up to $100 extra weekly to...
Finance Minister Eric Girard announced that the province will give up to $100 extra weekly to cashiers, grocery stockers, delivery people, and everyone who keeps the province running. Girard said that the program is meant to ensure that those essential workers will earn more by working than by applying for the federal government's emergency benefits program (CERB), which provides Canadians struggling financially with $2,000 a month. Using the logic of supply and demand, explain what is happening in the low-wage...
A major coffee supplier has warehouses in Seattle and San Jose. The coffee supplier receives orders...
A major coffee supplier has warehouses in Seattle and San Jose. The coffee supplier receives orders from coffee retailers in Salt Lake City and Reno. The retailer in Salt Lake City needs 550 pounds of coffee, and the retailer in Reno needs 300 pounds of coffee. The Seattle warehouse has 800 pounds available, and the warehouse in San Jose has 650 pounds available. The cost of shipping from Seattle to Salt Lake City is $2.50 per pound, from Seattle to...
​Discuss the creation of a marketing plan. What are the major components of a marketing plan?
​Discuss the creation of a marketing plan. What are the major components of a marketing plan?
1-Describe the major trends and forces that are changing the marketing landscape in automobile marketing with...
1-Describe the major trends and forces that are changing the marketing landscape in automobile marketing with special reference to Toyota-Lexus in KSA
((Health Care Marketing)) You are the marketing director of a major health care system in the...
((Health Care Marketing)) You are the marketing director of a major health care system in the Pacific Northwest. Over the past several years, the organization has developed a major center of excellence in digestive diseases. You have been asked to make a presentation to the board at the annual meeting to develop a domestic tourism program that would attract a market from outside the immediate service area. Develop a presentation indicating: the major target markets?? the channels that you need...
Identify the major problems with creating marketing plans.
Identify the major problems with creating marketing plans.
A major problem facing marketing managers is how to allocate their marketing communication budgets, for both...
A major problem facing marketing managers is how to allocate their marketing communication budgets, for both traditional and digital media, in order to improve consumer attitudes, market shares, sales, and profits. In addition, managers are subject to organizational realities which include political and historical influences. With this in mind, respond to the following in the Discussion: What factors would you consider when making marketing communication and budget allocation decisions? How do these factors relate to the relative allocations between advertising...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT