Unanswered | Answered

Database Design

~1800 answered questions
Parent Category: Technology
Database design is the process of creating a detailed data model of a database. It is the next step after requirement gathering and before coding begins. A good database design can save a lot of time during the database development.
To put it simply there are many types of data systems. But we'll just talk about two of the most common here: The first is commonly known as flatfile. The flat file is pretty simple: Each major category of data (e.g. Employees) is contained in a single file. If that employee can have multiple phone …
Popularity: 55
Oracle and Access are both RDBMS's (Relational Database Management Systems). Consequently they both use tables which have 'keys' to retrieve rows, and use 'foreign keys' to other tables to 'relate' those rows together. Oracle and Access also both use SQL (Structured Query Language) to allow you to u…
Popularity: 22
Babies From The MoonIn Windows, in My Computer, right-click on the System Volume Information folder and pick Properties from the context menu. Uncheck Read Only and pick Apply. At the command prompt, change to the folder, change the attributes of that directory: attrib System Volume Information -s -…
Popularity: 115
This is the most common of all the different types of databases. In this, the data in a relational database is stored in various data tables. Each table has a key field which is used to connect it to other tables. Hence all the tables are related to each other through several key fields.
Popularity: 39
dick brothers mad science
Popularity: 3
RDBMS - Relational Database Management System - Multiple users can access and there will be relationships between the tables, security is increased DBMS - Database Mangement system - small number of users DBMS is the Database Engine itself like MySql Server RDBMS is the GUI (Graphical user in…
Popularity: 14
Answer Data base is a list of information given with details as needed. It can also generate and distribute to users some tables and graphs. It can be password and access level protected. Answer Entering information and numbers, and the calculations of those numbers.
Popularity: 10
There are two primary variations of deductive database systems: expert database systems and knowledge-based database systems. Deductive databases differ from these two types of databases in one major respect: In the case of expert or knowledge-based databases, the data needs to be present in the pri…
Popularity: 1
over normalization One of the tenets of relational database design is "normalization". Normalization is the process of reducing a complex data structure into its simplest, most stable structure. In general, the process entails the removal of redundant attributes, keys, and relationships from a co…
Popularity: 22
Graphic design by its nature is an artistic endeavor. As such, No two artists are likely to go about their creation is the same manner and would probably not want to be constrained by the same software. By making the software customizable, each can tweak the various tools within the software to make…
Popularity: 1
BigTable
Popularity: 2
Answer I can help you with that. In my case, I had neither experience nor certification. Currently I am a database administrator making $70,000/yr. How? The key is in the title "Database Administrator." What does it mean? As it turns out it has two definitions: 1) a person who maintains a dat…
Popularity: 32
all kinds of great jobs1. retail manager 2. escort 3. maid
Popularity: 8
Decantation is a fast method for separating a mixture of a liquid and a heavier solid. In this process , first the solid impurities are allowed to sediment at the bottom of the container. Then, the pure liquid is poured out carefully from the container into another container. The precipitate or soli…
Popularity: 12
A role as Software Developer and in particular Web Designer, working in alliance with the Graphic's Team. With past 5 years of in JavaScript,CSS, HTML i have been scripting various Web UI components. This span of work makes me gel quickly with designer teams and share a good interaction. Moving ahea…
Popularity: 0
Assuming that you mean within the context of a relational database, the process would typically go something like this: 1) Identify in general terms what the database is supposed to do - for example, a hotel reservation system.2) Determine the sort of things the system needs to keep track of - in ou…
Popularity: 0
The question is too vague for a sound answer so I will try to shotgun it. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />The most basic relationship is a parent-child relationship. The parent table might be "Department," the child table, "Employee." The child can n…
Popularity: 34
The way that you are apart from others is by your CANDIDATE NUMBER. :)
Popularity: 4
There are several normal forms are available in DBMS.those are1NF,2NF,3NF,BCNF,4NF,PJNF(project Join),DKNF(Domain Key).
Popularity: 1
pages 491-492===D. Document Processing
Popularity: 2
A database is used for storing your work and is a easy way to store information A database is crucial for storing information, providing information to multiple users, easy access to data, fast information recall, and increased efficiency particularly for business owners. Storing Information A …
Popularity: 31
Point of sale Inventory system (Till) Warehouse Inventory System Electronic Telephone Book Airline booking system Hotel Booking system
Popularity: 0
collecting data, about someone, something etc For example a company may have a data base of all their clients addresses.
Popularity: 6
Input Process Output is what you put in, what you use both input and output for, and also what you get out. For example you might put in your monthly expenditure and income (input) , then you can work out your average (process) and then finally create a graph (output). Hope this helps!! lol Documen…
Popularity: 29
Answer Broadly speaking, a relational database is one that can be accessed by any of the datum items within the database, or things RELATED to them.For example, a telephone directory in the U.S. usually is accessed by the last name of the person or business looked for. However, it can also be access…
Popularity: 15
The amount of an electric motor's copper depends upon the size of the motor and the supplies used to make it. Generally, the older the motor, the more copper will be present.
Popularity: 6
1. accurate information 2. organized information 3. timely information 4. verifiable information 5. accessible information 6. economical information 7. useful information
Popularity: 25
The review of the related literature in the management information system gives an overview of the information contained. This is very important as it provides the reader with the content.
Popularity: 1
An ER diagram is an entity-relationship diagram they show individuals and their links to each other. An ER diagram for a hospital management system would be a flow chart showing hospital staff, equipment, patients, records and more.
Popularity: 1
I haven't met the other candidates so I can't speak for them, or against them. My own special skills are a strong focus on usability and simplicity. I am a firm believer in elegant solutions and I will go the extra mile to make anything I do look simple and intuitive. I am a great admirer of Apple C…
Popularity: 11
Design of the database (Database Design) refers to a given application environment, optimize the structure of the database, the database and applications, which can efficiently store data to meet the application needs of various user information needs and processing requirements). At www. myelibrary…
Popularity: 5
You use the appropriate tools from your database's system or third-party tools. For MySQL, you can use PhpMyAdmin to create a database. For Oracle, or Microsoft SQL Server, or other applications, they have tools for this purpose.
Popularity: 1
Answer A pseudo column is an item of data which does not belong in any particular table but which can be treated as if it did. Any SELECT list of columns can include these pseudo columns. SYSDATE current date and time ROWNUM sequence number assigned to retrieved rows ROWID unique identifier fo…
Popularity: 22
First, define participants ("lifelines") for the interaction. For example, on high overview level it could be web client interacting with online bookshop. On the more detailed levels, sequence diagram would include some software components participating in the interaction. Second, define "messages"…
Popularity: 2
Commitment to Technology - OnQ™ is the Hilton Family of Hotels' proprietary technology platform that integrates multiple capabilities onto one system to support hotel reservations & sales, guest service, operations and business intelligence-gathering activities. OnQ™ provides guest informati…
Popularity: 15
Compared to a manual database, a computerized database is more flexible, compact, and faster. It reduces the probability of inconsistent data. When a database is teamed with a computer, many of the problems with a manual database are eliminated. A computerized database Provides: Speed It can find…
Popularity: 12
general purpose software is software that is used for general purposes. such as Microsoft word or excel.
Popularity: 7
these are some of the advantages of database management systems 1.allows remote login. 2.eases the problem for mobility because of number1(remote login) 3.allows sharing of research and other works.eg like we are doing now(sharing) 3.makes it for the database administrator to monitor user activities…
Popularity: 18
Hello, Main types of database server are: Hierarchical databases. Network databases. Relational databases. Object-oriented databases By Anaya, The Cheesy Animation(India ,Ahmedabad)
Popularity: 0
The database administrator performs a critical role within an organization and is an important and key role in Database Management Systems. The major responsibility of a database administrator is to handle the process of developing the database and maintaining the database of an organization. The…
Popularity: 3
how to draw e-r diagram for hospital management system plz show the figure?
Popularity: 13
IBM Infosphere Data Architect, CA Erwin, Microsoft Access GUI are examples of physical database designer.
Popularity: 4
Currency - is the information up to date? Accuracy - accurate for its use - i.e. daily production figures, weekly sales figures, monthly overall figures, yearly production figures rounded up to nearest £'000 Relevance - how relevant it is to the end user - i.e. a machine breaks down 4 times in on…
Popularity: 14
Some questions that hiring authorities might ask you in an interview for a position as a systems business analyst include: How do you see yourself fitting for the position of BSA for the given role ?Describe your previous experience as BSA/similar role?What is your academic background?How do you ens…
Popularity: 18
Er diagram for payroll system is also known as the Entity Relationship Diagram. This diagram shows the company how it manages to pay their employees.
Popularity: 0
This position takes the business requirements and models a database based on the business's needs. Does the database need to be in real-time? What kind of data will it hold? Sensitive? There's hundreds of factors that determine how the database is designed, updated, protected. Each business is dif…
Popularity: 10
A database is, simply put, an organized collection of data. The manner in which information is entered into a database makes it easy to retrieve, format and manipulate. All that is required is the knowledge of the proper language. When you know how to query a database in the correct manner, it will …
Popularity: 1
probably, online shopping is not advisable because you can only see it trough internet but you can't touch the texture, quality and smoothness so maybe, it is not what you like when you see it.
Popularity: 20
it is a big juicy mongy apple pie from mcdonalds Well the answer that the person left above to me was STUPID but anyways general purpose software is like a software you use at home or school like a word processor or spreadsheets and stuff like that.
Popularity: 0
A pivotal setup in designing a relation database is to design the relations making up the database. Although this might appear to be a simple task, many subtleties are waiting to trap the unwary designer. The Advantages to using a relational database system: You use tables to create the relatio…
Popularity: 16
In a doctor's database, there would be several fields. The fields could contain the patient's name, address, telephone or mobile number, their Name,Age,Date of birth,allergies, and the doctor's name. Each thing would have a field of its own. So the patient's name and the doctor's name would be in tw…
Popularity: 3
A databasefield is a certain part of a data base e.g d.o.b hobbies. It is a part of the database e.g the name or surname or the address. A field is essentially the columns of the table on the database.
Popularity: 13
An ER diagram is used for any Hotel Management system is very easy b/c first of all we have to make an chart that which things are required in any hotel ?
Popularity: 5
A rediffmail account is deactivated when it has not been used for 90 days. Once that has happened, any emails that were sent to the account will be permanently deleted.
Popularity: 0
you need a patient, doctor, equipment and appointment table
Popularity: 5
A database is an organized collection of data. The data is typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies).The term database is corre…
Popularity: 0
try www.wikipedia.com which will help you for making ER - Diagram .... and copy past given link below in your browser for detailed description about ER - Diagram : http://www.infocom.cqu.edu.au/Courses/spr2000/95169/Extra_Examples/ERD.htm
Popularity: 15
Hotel Booking System Level One Data Flow Diagram  Level Two Data Flow Diagram
Popularity: 17
Normalisation means make table very effective and usable means make table atomic ,unique primary key,not redundancy etc.
Popularity: 5
These can be found online. You might want to do an image search for the industry or business that you want this information for.
Popularity: 0
The relationship between CAD (Computer aided design) and CAM (computer aided manufacturing) is that both types of designing need to be done on a computer and operated by an engineer.
Popularity: 0
HOW MANY TYPES OF DATABASES IN COMPUTERS PLS GIVE ME LIST OF IT. 4
Popularity: 8
Network Database model was designed to solve some of Hierarchical Database Model. Specifically this solves the problem of data redundancy by representing relationships in terms of sets. ADVANTAGESOrganization: Information is grouped into entities/records and each entity has attributes, which corresp…
Popularity: 4
An ER diagram of a library database management system helps to keep all aspects of running a library organized. The diagram should include the books and publishers, as well as members of the library and who has checked out which books.
Popularity: 5
MySQL, Oracle, MS Access, MS-SQL, pretty much any software that is related or its sole purpose is for databases is a database package.
Popularity: 25
MW - Molecular Weight ! - kk_kill3r
Popularity: 4
We know a database is one that stores data related to each other. A network database is just like network database only difference between them is, in network database records are connected by means of a link.
Popularity: 0
Computer software piracy is the unauthorized use of computer software. Installing a single use copy on multiple computers, downloading cracked software from the internet, and purchasing bootleg copies of software are all examples of computer software piracy.
Popularity: 0
The difference is that "systems development life cycle" is the time it takes to fully develop and fine-tune an entire information system. "Software development life cycle" applies only to the software development process.
Popularity: 4
Sales Job: "The money." HR Job: "I like helping people." Teaching Job: "I want to give others the same sort of education I had" Mechanic Job: "I like cars." Summary: There are as many answers as there are jobs and the answer is always glib and obvious.
Popularity: 2
The ability to ask a well-specified question, perhaps.
Popularity: 3
Database Approach vs. Traditional File Processing Self contained nature of database systems (database contains both data and meta-data). Data Independence: application programs and queries are independent of how data is actually stored. Data sharing. Controlling redundancies and inconsistencies. Se…
Popularity: 11
Unix was rewritten in the C programming language and not in assembly language. The migration from assembly language to the higher-level language C resulted in much more portable software, requiring only a relatively small amount of machine-dependent code to be replaced when porting Unix to other com…
Popularity: 5
Dependency means that the one entity dependents on another entity. This is also applicable for the Function also. For Example : If you trying to check the general function which tells you about the rooms availability, which consist of checkFreeRooms() and we can have the checkForACRooms() and Check…
Popularity: 6
database are used to organise data into a more formal and understandable structure
Popularity: 4
You can unlock sony ericsson different methods: - free cracked software (search for SEtool cracked), but be careful this involves risk and you can damage your phone if you do not know what you are doing - by cable online Instant most of the time, but still includes flashing / patching your phone …
Popularity: 2
Data Structure The table format is simple and easy for database users to understand and use. RDBMSs provide data access using a natural structure and organization of the data. Database queries can search any column for matching entries.Multi-User Access RDBMSs allow multiple database users to acc…
Popularity: 1
An engineer designs machines. And an architect also designs the layout/aesthetics of the machine.
Popularity: 2
In 3 tier architecture, client directly interacts with intermediate server and intermediate server will directly interact with database server.
Popularity: 7
search for this line below there is a video you can watch" VB.NET Database Tutorial - Connecting To Microsoft SQL Server (PART 1) (Visual Basic .NET) Thank you Dariush from Wickenburgnet.com
Popularity: 0
class Bubblesort{ public static void main(String a[]){ int i; int array[] = {2345,12,1,111}; System.out.println("Values Before the sort:\n"); for(i = 0; i < array.length; i++) System.out.print( array[i]+" "); System.out.println(); bubble_srt(array, array.length); System.out.print("Values…
Popularity: 4
A data warehouse is a central repository where data from multiple sources is combined ideally in a standardized data structure.
Popularity: 2
Disadvantages of paper based communication: There are many benefits towards this communication method but they always come at a cost! Issues arise as cost of sending away Via. stamps and delivery, other areas are the writers hand writing quality along with the grammar and spelling mistakes. Some pa…
Popularity: 4
Data in the database is very easy to handle. To organize data in database in ascending or descending order we can use group by command.
Popularity: 0
simply draw separate graph from the graph from which you have to find the subgraphs, remove exact one edge ont time and proceed to the till end.
Popularity: 5
The main disadvantage of a relational database is that it is slow and computationally intensive. Other disadvantages are: Extracting a meaningful information from the data takes a lot of time as the data is stored in multiple tables. The data complexity grows with the increase in the number of re…
Popularity: 1
STOP - dont do anything else. contact your service provider and talk to them about it they will help you and give you a new code. DONT keep trying to guess the code if you dont kno wat it is, your phone will lock permanantly and you will have to buy a new SIM card.
Popularity: 4
wix.com is a great website to create a website for music social networking and so much more!
Popularity: 1
"Draw Data flow diagram of car dealer?"
Popularity: 10
An entity-relationship diagram for online banking includes the process of online banking and the relationship between each step. It is a model that maps out, describes, and defines how components are linked for online banking.
Popularity: 2
There are many differences between a traditional FPS and a DBMS. The main difference is the security and integrity that is maintained in DBMS but not in FPS.
Popularity: 0
Database is of number of types two of them are OODBMS and RDBMS. OODBMS is acronym for object oriented database and RDBMS stands for relational database. In OODBMS object oriented features are inculcated and in RDBMS relation between the tables is defined. A Relational Database is designed and main…
Popularity: 4
see the link below http://www.freetutes.com/systemanalysis/sa8-comparison-relational-model-oo-model.html we compare the two models from the following criterias: model representation capabilities, languages, system storage structures, and integrity constraints. Data Model Representation Di…
Popularity: 2
An entity set that does not possess sufficient attributes to form a primary key is called a weak entity set. One that does have a primary key is called a strong entity set. The discriminator (or partial key) of a weak entity set is the set of attributes that distinguishes among all the entities of …
Popularity: 17
I/O devices accept or release information at much slower rate than the microprocesor. Handshaking is the method that synchronize the I/O device with microprocessor.
Popularity: 5
There are three database models. The three database models are as follows : 1) relational2) network data3) hierarchical
Popularity: 5