Unit 18 - Database P1, M1 - 1008 Words

Database Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user. MS Access is a database management system design by Microsoft. It offers user four important objects they are: * Table A Table is where you are organised and store data so you have to create the table before store any data. By creating table, you need to define few things, Fields name, Data type, and the Description. * Fields Name Fields†¦show more content†¦* Data Redundancy – Relationships General a database has a lot of tables and some tables are related to each other so relationship is use to make the connection between two or more tables. It is a method to avoid excessive data and to ensure the data integrity. There have three types of relationships: * One to One For example, one employee only has one ID and one ID only for one employee. In many case, â€Å"One to One† relationship is for reduce the time to searching data. * One to Many Simply, â€Å"One to Many† means one thing or one person has many relations with other. For example, one department can have many employees. * Many to Many â€Å"Many to Many† is different with other two. To build â€Å"Many to Many† relationship you need to have at least three tables. It is because â€Å"Many to Many† cannot make the connection directly. For example, a student can choose many course but a course can have many student too so you cannot actually link them together. To link them, you will need a table to transfer data so the relationship will become â€Å"Many to One† and â€Å"One to Many†. * Normalisation It is a design method that used to avoid data redundancy and eliminate uncoordinated relationship. Normalisation has six stages to help with separate data which are UNF, 1NF, 2NF, 3NF, BCNF, 4NF and 5NF. * UNF is the first stage which is unnormalised; * 1NF is to remove the repeating groups; *Show MoreRelatedEssay on My Pico Question1936 Words   |  8 Pagesï » ¿My Pico question: P: Women between 18-69 years presenting for cervical cytology screening. I: HPV DNA testing C: Cytology Screening O: Sensitivity for detecting cervical precancerous lesions. Article 1: Int J Cancer.  2014 Jul 1;135(1):166-77. doi: 10.1002/ijc.28640. Epub 2014 Jan 24. Is HPV DNA testing specificity comparable to that of cytological testing in primary cervical cancer screening? Results of a meta-analysis of randomized controlled trials. Pileggi C1,  Flotta D,  Bianco A,  NobileRead MoreDistributed System Problem Solution Andrew Taneebaum Maarten Van Steen19007 Words   |  77 Pagesextent does Java RMI rely on code migration? A: Considering that object references are actually portable proxies, each time an object reference is passed, we are actually migrating code across the 16 PROBLEM SOLUTIONS FOR CHAPTER 3 17. 18. 19. 20. 21. network. Fortunately, proxies have no execution state, so that support for simple weak mobility is all that is needed. Q: Strong mobility in UNIX systems could be supported by allowing a process to fork a child on a remote machineRead More_x000C_Introduction to Statistics and Data Analysis355457 Words   |  1422 Pages25 ââ€"  ââ€" ¼ USA Today (July 2, 2001) gave the following information regarding cell phone use for men and women: Average Number of Minutes Used per Month Relative Frequency Men Women 0 to 200 to 400 to 600 to 200 400 600 800 .56 .18 .10 .16 .61 .18 .13 .08 Video Solutions Motivate Student Understanding More than 90 exercises will have video solutions, presented by Brian Kotz of Montgomery College, which can be viewed online or downloaded for later viewing. These exercises will beRead MoreQuality Improvement328284 Words   |  1314 Pagescentered at the desired or target value. However, the distribution of the critical characteristics for the transmissions manufactured in the United States takes up about 75% of the width of the specifications, implying that very few nonconforming units would be produced. In fact, the plant was producing at a quality level that was quite good, based on the generally accepted view of quality within the company. In contrast, the Japanese plant produced transmissions for which the same critical characteristicsRead MoreComputer Networking: a Top-Down Approach Featuring the Internet, 4th Edition - Solutions to Review Questions and Problems27823 Words   |  112 Pagesare transmitting simultaneously) is 0.008. 16. The delay components are processing dela ys, transmission delays, propagation delays, and queuing delays. All of these delays are fixed, except for the queuing delays, which are variable. 17. Java Applet 18. 10msec; d/s; no; no 19. a) 500 kbps b) 62.5 seconds c) 100kbps; 312.5 seconds 20. End system A breaks the large file into chunks. To each chunk, it adds header generating multiple packets from the file. The header in each packet includes the addressRead MoreMerger and Acquisition: Current Issues115629 Words   |  463 Pagesacquisitions transactions on the Canadian stock markets over the period 1990–2004. The chapter focuses on the consequences of MA on the accuracy and quality of earnings forecasts, using financial analysts’ forecast consensus provided by the IBES database. The results highlight an increase of financial analysts’ forecast errors after the mergers, and the pre-merger level of accuracy is restored only two years after the event. Light is also shed on the over-optimism shown by fina ncial analysts in theirRead More4g Communication22481 Words   |  90 Pagesfailure. The user, device, or network can initiate handoff between networks. The device itself incorporates most of the additional complexity without requiring wireless network modification or employing interworking devices. Each network can deploy a database that keeps track of user location, device capabilities, network conditions, and user preferences. The handling of quality-of-service (QOS) issues remains an open research question. Overlay network: In this architecture, a user accessesRead MoreMonte Carlo Simulation218872 Words   |  876 Pagestheorem provides information about the likely magnitude of the error in the estimate after a ï ¬ nite number of draws. A small step takes us from volumes to integrals. Consider, for example, the problem of estimating the integral of a function f over the unit interval. We may represent the integral 2 1 Foundations 1 ÃŽ ±= 0 f (x) dx as an expectation E[f (U )], with U uniformly distributed between 0 and 1. Suppose we have a mechanism for drawing points U1 , U2 , . . . independently and uniformlyRead MoreFinancial Statements Fraud56771 Words   |  228 Pages................................................ 15 Experimental Design and Factors .............................................................. 17 Dependent Measure ................................................................................ 18 Combiner Method Factor........................................................................ 19 Sensitivity Analysis ................................................................................ 20 Investigating the True Class of All Objects..