Computers and Technology, 12.04.2021 23:30 tiwaribianca475

5.11 - Suppose each of the following Update operations is applied directly to the database of Figure 5.6. Discuss all integrity constraints violated by each operation, if any, and the different ways of enforcing these constraints: Figure 5.6 One possible database state for the COMPANY relational database schema. (a) Insert < 'Robert', 'F', 'Scott', '943775543', '21-JUN-42', '2365 Newcastle Rd, Bellaire, TX', M, 58000, '888665555', 1 > into EMPLOYEE. (b) Insert < 'ProductA', 4, 'Bellaire', 2 > into PROJECT. (c) Insert < 'Production', 4, '943775543', '01-OCT-88' > into DEPARTMENT. (d) Insert < '677678989', null, '40.0' > into WORKS_ON. (e) Insert < '453453453', 'John', M, '12-DEC-60', 'SPOUSE' > into DEPENDENT. (f) Delete the WORKS_ON tuples with ESSN

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 05:30, donmak3833

Agood flowchart alludes to both the inputs and outputs you will need to receive and give to the user. true or false?

Answers: 3

continue

Computers and Technology, 24.06.2019 09:50, ira51

Suppose you are an ad-serving company and you maintain a log of cookie data for ads you serve to the web pages for a particular vendor (say amazon). a. how can you use this data to determine which are the best ads? b. how can you use this data to determine which are the best ad formats? c. how could you records of past ads and ad clicks to determine which ads to send to a given ip address? d. how could you use this data to determine how well the technique you used in your answer to part c was working? e. how could you use this data to determine that a given ip address is used by more than one person? f. how does having this data give you a competitive advantage vis-à-vis other ad-serving companies?

Answers: 2

continue

Computers and Technology, 24.06.2019 10:30, pino40

Which of the following types of software is most applicable to the promotion of new products through advertising? a. databases b. spreadsheets c. web design programs d. word processing tools

Answers: 2

continue

Computers and Technology, 24.06.2019 11:00, iloveballet1857

Each row in a database is a set of unique information called a(n) ? a.) table. b.) record. c.) object. d.) field.

Answers: 2

continue

You know the right answer?

5.11 - Suppose each of the following Update operations is applied directly to the database of Figure...