Explain what is meant by repetition of information and
inability to represent information. Explain why each of
these properties may indicate a bad relational database
design.
Answer Posted / shrikant patil
Repetition of Information is a condition in a relational
database where the values of one attribute are determined by
the values of another attribute in the same relation, and
both values are repeated throughout the relation. This is a
bad relational database design because it increases the
storage required for the relation and it makes updating the
relation more difficult.
- Inability to represent information is a condition where a
relationship exists among only a proper subset of the
attributes in a relation. This is bad relational database
design because all the unrelated attributes must be filled
with null values otherwise a tuple without the unrelated
information cannot be inserted into the relation.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
where is the first engeenering college of Asia
what is the work of Loopback ?
how can we implement the raid techmology on linux. operating system
what is the difference between error,exception,bug,defect,fault..?
Why DG Set manufacturers do not give options for alternative fuels. They even do not allow to change at the cost of custmers.
what is the concept of c++ class
What is the dewpoint of atmoshperic Air?
Explain Belady's Anomaly.
What are the input documents to 1.Functional testing,2.System testing and 3.Integration testing. Whether there will be separate test cases for regression testing or functional testing?
Explain work?
hi friends i am b-tech in computer science having interview of State bank of india clerk day on 30 th april. I want to know the answer of question:"you r B.tech in C.S. why do u want to become a bank clerk?" please help.Its my humble request.
Write a shell script to delete all files present in a directory “dir1”. Any error, if it occurs while carrying out this operation should be stored in a file errorlog
Net app interview questions ============================ . Storage Fundamentals: - what is Raid? What are different kind of Raids? - Difference between all of Raids , Advantage of one raid over other - What are FCP & ISCSI, Difference between them. - FC Topologies, Iscsi commands - How to mount a Lun on Windows/Linux - NFS and CIFS - Difference between SAN, NAS and DAS - Different Backup methodologies, Snapshot, mirror, Disaster Recovery, High Availability, Cluster concepts 2. Network Fundamentals: - TCP/IP and ISO/OSI layers - What is DHCP, DNS, SNMP, Router, Hub, Switch, HTTPS , HTTP, telnet , ssh, rsh - Different SNMP versions (V1, V2, V3) - SNMP traps - Ipv4 and Ipv6 addressing 3. Database: - SQL queries, Joins (may ask you to write queries with complex joins) - Aggregate functions - Schemas, Tables, views (create, delete, alter, drop etc) 4. Testing - Bug tracking process, Types of Bugs - Difference between priority and Severity of Bug - Your best bug , what will you do when your bug is not fixed/rejected etc. - What is Functionality/Sanity/Stress/Upgrade & revert/Performance/negative/Release test/regression tests. How you have done these in your past projects. - Black box testing, grey box testing - May ask to write test cases on a given scenario - What is test plan and test summary/strategy document. Different sections in these documents. - SDLC, Test Lifecycle and approach to test a product (Given a product what different kind of testing you will do) 5. Perl ( in addition, you may be asked to write scripts on below areas) - Regular expressions - File/Directory Handling - Scalars, Arrays and Hashes - Packages and Modules - Use and require statements - Go through Net::Telnet, Net::SNMP, Net::SSH modules in perl
Write a program to input 10 elements in an array and seperate even and odd numbers, positive and negative between them ?
what is your experience in developing technical specifications?