existing tables. In other words, it uses the relationship of similar data to increase the speed and versatility of the database. Relationship database establish the relationships between entities by means of common fields included in a file, called a relation. For example, a customer orders a product. Each customer may has an ID number and has a name. The relationship between a customer and the customer’s order created by the
Words: 732 - Pages: 3
Top of Form Week 2: Tables, ER Modeling, and The DBMS - Discussion |Database Table Design (graded) | |When designing database tables, the difference between a good design and a bad design can be a few seconds in response time and | |several minutes. You may think that this is not a huge difference, but imagine waiting several minutes on a web page for your results | |to load. How
Words: 10657 - Pages: 43
Journal/diary 15/11/12 (1 hr) | Understanding the problem: * Half page introduction to scenario * Complete Preliminary investigation on marble bar | 16/11/12 (30 mins) | Understanding the problem: * Requirements report | 19/11/12 (1 hr) | Planning: * Feasibility study on flat file and relational database. * Economic and technical feasibility | 20/11/12 (1 hr) | Planning: * Schedule and organisational feasibility * Complete updated requirements report | 22/11/12 ( 1hr and
Words: 290 - Pages: 2
2014 Question 1 a. Why are tuples in a relation not ordered? b. Why are duplicate tuples not allowed in a relation? c. What is different between a key and a superkey d. Why do we designate one of candidate keys of a relation to be the primary key? e. Discuss the characteristics of relations that make them different from ordinary tables and files. f. Discuss the various reasons that lead to the occurrence of NULL values in relations g. Discuss the entity integrity and referential
Words: 313 - Pages: 2
I would start out by explaining to the customer what Microsoft Access is. Microsoft Access is software that manages databases. The database collects, organizes, and stores information about things. The second thing I would do is introduce some basic terms of Microsoft Access. A database table looks a lot like a spreadsheet. There are rows and columns like a spreadsheet, which makes it easier to convert a spreadsheet into a database. Each row and column in a table is referred to as a record
Words: 275 - Pages: 2
Advance Database Assessment – Marshalls Garage The problems with a flat file database are as follows -: The potential problems of a flat file database are mostly caused through duplication of the required information – e.g. each time the town is put in, it has to be typed separately, this can lead to errors with spelling and consistency e.g. (AE) instead of Dalbeattie, and also inconsistencies between the data whilst the information is being inserted into the database, this also leads to a
Words: 1010 - Pages: 5
(10 X 1.5=15) Answer all the questions 1.List out the function of computer. 2.List out any three Output device. 3.What is the Use of find command? 4.How to start the word.? 5.Define Zoom. 6.Write the sum formula. 7.Define Relation. 8.What you mean by Report? 9.What is the use of Undo? 10.What is the use of save as? Section-B (5 X 4=20) Answer all the questions 11.Explain about storage devices. (or) Discuss about operating system. 12.How to
Words: 1165 - Pages: 5
Should have has many Should have Makes has many supervises pays 2. Relational data structures that transfers your ER diagrams LOGIN(Loginname,loginid,Password) STAFF(Firstname,Lastname,Staffid,Street,city,state,emailid) CUSTOMER(Firstname,lastname,customerid,gender,address,dob,phoneno,mobileno,workphnno) FLIGHTDETAIL(flightno,no.of seats,city of departure,city of arrival,time of departure,time
Words: 456 - Pages: 2
not publish a catalog at all. Part 2: Convert the E-R diagram you constructed in Part 1 into the corresponding relational schema. List all tables. In each table, underline the primary identifier. If a specific attribute is a foreign key to another relation, write a short note indicating this. Use as few tables as possible. Practice Question -03 You are given the diagram following Figure for storing information about a virtual store containing various items from different stores. Convert
Words: 1214 - Pages: 5
1) You need to design a new Access database. The first step is to organize the smallest to largest data, also called: D) Hierarchy of data. 2) Access is a relational database, which means that the data are organized into a collection of related: C) Tables. 3) In Access, a collection of numbers and/or characters that describes one aspect of a business object or activity is called: C) A field. 4) A pre-designed database that contains various pre-built objects is called: A) A template
Words: 305 - Pages: 2
