answersLogoWhite

0

Database Design

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.

500 Questions

What is a general-purpose software?

User Avatar

Asked by Wiki User

It is a general piece of software that anyone could use, such as a word processor or spreadsheet etc. You can go into a shop and buy it. The developers would make lots of copies and sell it as all sorts of people would want it. You also have specialist software which may be written for a specific group of people or a specific company or individual and which would be no use to anyone else. Only one or a few copies might be made as it is for a very specific client.

Does a database have to be computerized?

User Avatar

Asked by Wiki User

No. A database can be manual, like a phone book or a shopping list. For it to be a database it needs to be structured or organised. If you take a phone book, although there are thousands of names in it, you can usually find a phone number you are looking for very quickly. This is because the phone book is structured and organised. So it does not have to be on a computer to be a database. A manual database can be computerised. The data would be entered into a computer.

Which utility keeps track of where your documents spreadsheets and presentations reside?

User Avatar

Asked by Wiki User

File management is the utility that keeps track of where your documents, spreadsheets, and presentation are located. It also displays other files that are on your computer like pictures.

What is difference between data integrity and data security?

User Avatar

Asked by Wiki User

Data integrity = making sure the data is correct and not corrupt

Data security = making sure only the people who should have access to the data are the only ones who can access the data. also, keeping straight who can read the data and who can write data.

What is input mask in a database?

User Avatar

Asked by Wiki User

An input mask refers to controlling the input that a user is going to provide.

For example, if you were going to ask for a person's phone number, and you know the format of the phone number is going to be (xxx) xxx-xxxx, then you would set an input mask forcing the input to be in that format.

A zip code, for example, is 5 or 9 characters in the U.S..... either 12345 or 12345-6789.

Therefore, you would use an input mask that looked like xxxxx | xxxxx-xxxx

This controls the user's input so that less validation is required later.

Input masks are mostly used to validate input that has a strict pattern that never changes. With Access validation rules you can validate more complex patterns.

Sequence diagram for online bus reservation?

User Avatar

Asked by Wiki User

digrams for public transportation

Why is this website so laggy?

User Avatar

Asked by Wiki User

Its not this website its either your computer or a virus.

How we can develop a database?

User Avatar

Asked by Wiki User

First of all u must khow for what u want to create DBMS. you must create Mini world and select some entities and distinguish their attributes. For khowing more about entities,attributes and their relations i suggest u read this book: Fundamental of database system written by: Ramez Elmasri & shamkant B. Navathe

What are protocols and why are they introduced in network communications?

User Avatar

Asked by Wiki User

A protocol is a set of rules describing some behavior. In order to communicate in a common manner, the sender and receiver have to agree on the "language" of communication.

A protocol states what those rules are, and because they are a standard, everyone agrees and knows what to expect.

What is the difference between data model and database model?

User Avatar

Asked by Wiki User

A database is a collection of tables that is used for some purpose (typically an application of some sort). A database model is a description of that database, and describes how the tables relate to each other. Typically, a model is designed first, then the actual database is implemented using the model as a blueprint.

Contrast of database and database system?

User Avatar

Asked by Wiki User

A database is simply a collection of pieces of information (data). A text file storing names and phone numbers is a database. A database management system (DBMS) is some software that manages the data within the database such as MySQL. Both the software and the database are considered together when thinking of a DBMS.

How would a library use a database?

User Avatar

Asked by Wiki User

to keep track of how many books people borrowed or how many books have not been returned.

Which of the locations represent the greatest danger in encountering misinformation?

User Avatar

Asked by Wiki User

If you wanted to look up an article from the Chicago Tribune the best place to start would be

What is an example of how a database can be queried?

User Avatar

Asked by EncofBizandFinance

In an inventory database, for example, a purchasing query could be done for all merchandise at or near the inventory minimum of the particular item.

Design a combination circuit that accepts a 3 bit number and generates a 3 bit binary number equal to the square of the input number?

User Avatar

Asked by Wiki User

0 + 0 = 0

0 000 0000

1 + 1 = 2

1 001 0010

2 + 2 = 4

2 010 0100

3 + 3 = 6

3 011 0110

4 + 4 = 8

4 100 1000

5 + 5 = 10

5 101 1010

6 + 6 = 12

6 110 1100

7 + 7 = 14

7 111 1110

What are the components of relational database?

User Avatar

Asked by Wiki User

Table, index, trigger and column Table, index, trigger and column

What does the term record mean in relation to databases?

User Avatar

Asked by Wiki User

Record is more a term related to databases than to spreadsheets. However, as you can do some database work using a spreadsheet, then it can be a term used in a spreadsheet. A record in a database is a row of related data, such as the name, age, address and phone number of a person. If it is done in a spreadsheet, with each set of data on a separate row, it can be regarded as being a record.

What data type should use if want a field to contain a combination of numbers and text?

User Avatar

Asked by Wiki User

A text field can contain both numbers and text, so that is what you would use.

What are micros in MS Excel?

User Avatar

Asked by Wiki User

If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) that are stored in a Microsoft Visual Basic module (module: A collection of declarations, statements, and procedures stored together as one named unit. There are two types of modules: standard modules and class modules.) and can be run whenever you need to perform the task. For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps.

Describe the main characteristics of the database approach and contrast it with the file-based approach?

User Avatar

Asked by Wiki User

The Database Approach has four common characteristics. These are: Self-describing nature, support multiple user view of data, share the data and multiple user transaction processing and insulation between data and data abstraction.

Entity relationship diagram of hr system?

User Avatar

Asked by Wiki User

In case you have no background in computer science, entity relationship is a method that conceptually identifies the interacting, and independent objects( both physical and otherwise) in an information system with the view to avoid data redundancy, maintain data integrity, improve data efficiency, increase resource utilization in terms of storage management and access speed or system response time. Pls let stop here. An instance of your diagram, which I will stress you little, is to quickly image

1. A hostel and rooms in it, here Hostel as well as the rooms are treated as different entities.

2. imagine manager and employee under him in an organization, even though they can all be referred to as employees yet manager is different entity

In a nut shell we use a line to link two interacting entities and the cardinality( which is to be discuss professionally as either one to one, one to many). That is all.

I am not too good at drawing but I could conceptualize it mentally.

If this does not satisfy you do not hesitate to mail me at: maduchudi@yahoo.com I will always be for you all.

What are the difference between Entity Relationship Program and Flow Chart?

User Avatar

Asked by Wiki User

ER diagram is Entity Relationship Diagram which shows relationship between different entities in a process....

Data Flow diagram is a symbolic structure which shows the flow of data how it is

used in diff stages in a particular process....

Complete architecture of 8086 microprocessor?

User Avatar

Asked by Wiki User

8085 Architecture - II Written by: shankar • Edited by: KennethSleight

Published Sep 30, 2009 • Related Guides: Intel

Learn in detail about the functions and working of flags, the timing and control unit, Interrupt control and various other signals associated with it. Also learn about the Data bus and address bus present in 8085 microprocessor and how these units combine to process a data altogether.

Introduction

In the previous articles we learnt about what are microprocessors in general and the about the 8085 microprocessor in particular. We saw the various registers used in 8085 microprocessor and how they act along with Arithmetic and Logic unit to process a data. But Registers and ALU alone cannot successfully process a data and provide the result to the programmer. There are various other units which help in data transfer and addressing, Carry operation while adding or subtracting, and sometimes also to interrupt a process when necessary. Let us discuss about those units in detail.

Architecture DiagramFlags

Flags are nothing but a group of individual Flip-flops. The flags are mainly associated with arithmetic and logic operations. The flags will show either a logical (0 or 1) (i.e.) a set or reset depending on the data conditions in accumulator or various other registers. A flag is actually a latch which can hold some bits of information. It alerts the processor that some event has taken place.

TI's Signal Conditionersti.com

Cutting Edge Silicon Process Tech & Advanced Analog Circuit Design

Ads by Google

But why are they called flags?

The possible solution is from the small flags which are found on the mail boxes in America. The small flag indicates that there is a mail in the mail box. Similarly this denotes that an event has occurred in the processor.

Intel processors have a set of 5 flags.

  • Carry flag
  • Parity flag
  • Auxiliary carry flag
  • Zero flag
  • Sign flag

Consider two binary numbers.

For example:

1100 0000

1000 0000

When we add the above two numbers, a carry is generated in the most significant bit. The number in the extreme right is least significant bit, while the number in extreme left is most significant bit. So a ninth bit is generated due to the carry. So how to accommodate 9th bit in an 8 bit register?

For this purpose the Carry flag is used. The carry flag is set whenever a carry is generated and reset whenever there is no carry.

But there is an auxiliary carry flag? What is the difference between the carry flag and auxiliary carry flag?

Let's discuss with an example. Consider the two numbers given below

0000 0100, 0000 0101

When we add both the numbers a carry is generated in the third bit from the least significant bit. This sets the auxiliary carry flag. When there is no carry, the auxiliary carry flag is reset.

So whenever there is a carry in the most significant bit Carry flag is set. While an auxiliary carry flag is set only when a carry is generated in bits other than the most significant bit.

Parity checks whether it's even or add parity. This flag returns a 0 if it is odd parity and returns a 1 if it is an even parity. Sometimes they are also called as parity bit which is used to check errors while data transmission is carried out.

Zero flag shows whether the output of the operation is 0 or not. If the value of Zero flag is 0 then the result of operation is not zero. If it is zero the flag returns value 1.

Sign flag shows whether the output of operation has positive sign or negative sign. A value 0 is returned for positive sign and 1 is returned for negative sign.

Instruction Register and Decoder

Instruction register is 8-bit register just like every other register of microprocessor. Consider an instruction. The instruction may be anything like adding two data's, moving a data, copying a data etc. When such an instruction is fetched from memory, it is directed to Instruction register. So the instruction registers are specifically to store the instructions that are fetched from memory.

There is an Instruction decoder which decodes the informations present in the Instruction register for further processing.

Timing and Control Unit

Timing and control unit is a very important unit as it synchronizes the registers and flow of data through various registers and other units. This unit consists of an oscillator and controller sequencer which sends control signals needed for internal and external control of data and other units.

The oscillator generates two-phase clock signals which aids in synchronizing all the registers of 8085 microprocessor.

Signals that are associated with Timing and control unit are:

Control Signals: READY, RD', WR', ALE

Status Signals: S0, S1, IO/M'

DMA Signals: HOLD, HLDA

RESET Signals: RESET IN, RESET OUT

Interrupt Control

As the name suggests this control interrupts a process. Consider that a microprocessor is executing the main program. Now whenever the interrupt signal is enabled or requested the microprocessor shifts the control from main program to process the incoming request and after the completion of request, the control goes back to the main program. For example an Input/output device may send an interrupt signal to notify that the data is ready for input. The microprocessor temporarily stops the execution of main program and transfers control to I/O device. After collecting the input data the control is transferred back to main program.

Interrupt signals present in 8085 are:

INTR

RST 7.5

RST 6.5

RST 5.5

TRAP

Of the above four interrupts TRAP is a NON-MASKABLE interrupt control and other three are maskable interrupts.

A non-maskable interrupt is an interrupt which is given the highest priority in the order of interrupts. Suppose you want an instruction to be processed immediately, then you can give the instruction as a non-maskable interrupt. Further the non-maskable interrupt cannot be disabled by programmer at any point of time.

Whereas the maskable interrupts can be disabled and enabled using EI and DI instructions. Among the maskable interrupts RST 7.5 is given the highest priority above RST 6.5 and least priority is given to INTR.

Serial I/O control

The input and output of serial data can be carried out using 2 instructions in 8085.

SID-Serial Input Data

SOD-Serial Output Data

Two more instructions are used to perform serial-parallel conversion needed for serial I/O devices.

SIM

RIM

Address buffer and Address-Data buffer

The contents of the stack pointer and program counter are loaded into the address buffer and address-data buffer. These buffers are then used to drive the external address bus and address-data bus. As the memory and I/O chips are connected to these buses, the CPU can exchange desired data to the memory and I/O chips.

The address-data buffer is not only connected to the external data bus but also to the internal data bus which consists of 8-bits. The address data buffer can both send and receive data from internal data bus.

Address bus and Data bus:

We know that 8085 is an 8-bit microprocessor. So the data bus present in the microprocessor is also 8-bits wide. So 8-bits of data can be transmitted from or to the microprocessor. But 8085 processor requires 16 bit address bus as the memory addresses are 16-bit wide.

The 8 most significant bits of the address are transmitted with the help of address bus and the 8 least significant bits are transmitted with the help of multiplexed address/data bus. The eight bit data bus is multiplexed with the eight least significant bits of address bus. The address/data bus is time multiplexed. This means for few microseconds, the 8 least significant bits of address are generated, while for next few seconds the same pin generates the data. This is called Time multiplexing.

But there are situations where there is a need to transmit both data and address simultaneously. For this purpose a signal called ALE (address latch enable) is used. ALE signal holds the obtained address in its latch for a long time until the data is obtained and so when the microprocessor sends the data next time the address is also available at the output latch. This technique is called Address/Data demultiplexing.

How is data held in a database?

User Avatar

Asked by Wiki User

Data is all of the information that is stored in a database (a file that stores records), it remains to be data unless it is published or verified as accurate and useful.