subject

Your goal is to redesign their single table database. below you have some rows of the table to you understand the kind of data it stores, and how thedata relates with itself./hour117721013bill 2/27/20113$100117651015melanie 1/25/20114$120117672051ed 1/31/20112$50117682051ed 2/10/20114$551176933562/15/20115$90 1177333563/20/20116$601177140762/26 /20117$651176640791/25/20114$110117 7040792/25/20115$70a)what can go wrong with storing such information in a single table like the one above? give oneexample of an insertion anomaly and of an update anomaly that can happen when using the tableabove. b)propose a relational database to store the information: draw an entity-relationship diagram andwrite a database design outline.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 05:30
The total revenues for a company are $150,223 and the total expenses were 125,766. if you are calculating the net income, which of these spreadsheets would you use? insert a spreadsheet with $150,223 in cell b2 and 125, 766 in cell b3. enter a formula =b2-b3. the formula should be showing in the formula bar. insert a spreadsheet with $150,223 in cell b2 and 125, 766 in cell b3. enter a formula =b2+b3. the formula should be showing in the formula bar. insert a spreadsheet with $150,223 in cell b2 and 125, 766 in cell b3. enter a formula =b2/b3. the formula should be showing in the formula bar. insert a spreadsheet with $150,223 in cell b2 and 125, 766 in cell b3. enter a formula =b2*b3. the formula should be showing in the formula bar.
Answers: 3
question
Computers and Technology, 24.06.2019 00:30
Setting up a home network using wireless connections is creating a a. vpn b. lan c. wan d. mini-internet
Answers: 2
question
Computers and Technology, 24.06.2019 16:30
The database design steps are listed below in the incorrect order. choose the correct order number next to each step. determine the information to be stored in the database. determine the fields needed to record the data determine if there will be any repetition of data entered, and separate the fields into tables to normalize the data. create relationships to connect the tables.
Answers: 3
question
Computers and Technology, 24.06.2019 19:50
How to unblock on chrome book? ?
Answers: 1
You know the right answer?
Your goal is to redesign their single table database. below you have some rows of the table to you...
Questions
question
History, 20.09.2020 01:01
question
Mathematics, 20.09.2020 01:01
Questions on the website: 13722363