subject

Your recommended design ran into a snag. the team leader said it wasn’t bad, but it did not go far enough. the specific comment was that it was not in third normal form. also, the team finally decided on a code for the customer id field, which is a primary key. the code will be a combination code, with four letters followed by four digits. the letters would be the first four letters of the customer’s last name, which might make it easier for customers to remember.
task 1. review the sample erd and table designs, and convert them to third normal form (3nf).
task 2. calculate the exact number of possible combinations with a code composed of four letters followed by four numbers. does this seem like a good choice? why or why not? what would you suggest?

ansver
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 20:00, jroy1973
Awide variety of “ apps “ are available to customize devices. which category of app does the word processing software fall into?
Answers: 2
image
Computers and Technology, 22.06.2019 22:30, MoneyMike42
Alex’s family members live in different parts of the world. they would like to discuss the wedding plans of one of their distant relatives. however, alex wants all the family members to talk to each other simultaneously so that they can make decisions quickly. which mode of internet communication should they use? a. blog b. email c. wiki d. message board e. instant messaging
Answers: 2
image
Computers and Technology, 23.06.2019 01:50, akornegay2
Write a program that uses a random number generator to generate a two digit positive integer and allows the user to perform one or more of the following operations: a. double the number. b. reverse the digits of the number. c. raise the number to the power of 2, 3, or 4. d. sum the digits of the number. e. if the number is a two-digit number, then raise the first digit to the power of the second digit. f. if the number is a three-digit number and the last digit is less than or equal to 4, then raise the first two digits to the power of the last digit. after performing an operation if the number is less than 10, add 10 to the number. also, after each operation determine if the number is prime. each successive operation should be performed on the number generated by the last operation. your program should not contain any global variables and each of these operations must be implemented by a separate function. also, your program should be menu driven. 7. (fraction calculator) write a program that
Answers: 1
image
Computers and Technology, 24.06.2019 05:30, MOONCHILDSUGA
If you combine two cells into one, what action are you performing? a.  adding a new row or column      b.  splitting the cells      c.  removing a new row or column      d.  merging the cells
Answers: 2
You know the right answer?
Your recommended design ran into a snag. the team leader said it wasn’t bad, but it did not go far e...

Questions in other subjects:

Konu
Arts, 28.03.2020 21:42
Konu
Mathematics, 28.03.2020 21:43
Konu
Mathematics, 28.03.2020 21:43