Database

1. Database ?

There's lots of ways and reasons why a company would use database. Database are use to store, maintain, and organize records. Here are 3 examples: Business # 1: Office Depot Office Depot will use a database to track purchases by customers, track orders they submitted to their manufacturers, and monitor their inventory. Business # 2: Bank of America Bank of America uses a database to maintain their customer's accounts, including monitoring account activities, such as debits and credits. Business # 3: Hospitals A hospital will use a database to maintain records of patient who visited the hospital. Such records can be use for multi-purpose reports. Reports such as, how many patients visited the ER, the ICU, etc...

2. Database??

1)Databases are used in many applications, spanning virtually the entire range of computer software. Databases are the preferred method of storage for large multiuser applications, where coordination between many users is needed. Even individual users find them convenient, and many electronic mail programs and personal organizers are based on standard database technology. 2)A computer database is a structured collection of records or data that is stored in a computer system. A database relies upon software to organize the storage of data. In other words, the software models the database structure in what are known as database models (or data models). 3)The first database management systems were developed in the 1960s. A pioneer in the field was Charles Bachman. Bachman's early papers show that his aim was to make more effective use of the new direct access storage devices becoming available: until then, data processing had been based on punched cards and magnetic tape, so that serial processing was the dominant activity. Two key data models arose at this time: CODASYL developed the network model based on Bachman's ideas, and (apparently independently) the hierarchical model was used in a system developed by North American Rockwell later adopted by IBM as the cornerstone of their IMS product. While IMS along with the CODASYL IDMS were the big, high visibility databases developed in the 1960s, several others were also born in that decade, some of which have a significant installed base today. Two worthy of mention are the PICK and MUMPS databases, with the former developed originally as an operating system with an embedded database and the latter as a programming language and database for the development of healthcare systems. 4)The model in most common use today is the relational model. Other models include the hierarchical model and the network model.

3. What database software to learn to get a job?

you need to learn both, but SQL provides more long term opportunity. As a manager I had an immediate need for a MS Access expert. But the reality of the project and ultimate goal required a more in depth knowledge and framework such as your SQL. Think about your longterm goals. you probably want ot do real programming. Knowledge of both will keep you employed. Access may have you doing, financial analyst and other related work. (If you could bridge the two worlds it would do wonders for your carer as well.) While SQL will keep you moreso in your computer programming realm.

4. What is the best database software / programme for a small company with huge product portfolio?

sql server 2005 - express will provide you with 4GB database space... and its free... should you need more space... you could opt for 2 database instances or you could upgrade to the fully fledged product...what could be better - a free great product - by microsoft?

5. Act Database! How do I export the ACT database to include all Notes and Sales opportunities.?

I don't think its possible. You can export all the main fields but not if you are exporting as a comma or tab delimited form. try this link - it tells you what you can do with ACT! export. Hope this is of some help http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_alp.php?p_sid=AEylEZQip_lva=12357p_li=p_accessibility=0site_ID=1p_page=1p_cv=p_pv=p_prods=0p_cats=p_hidden_prods=prod_lvl1=0p_search_text=exportp_new_search=1p_search_type=answers.search_nl

6. How to connect VB 2008 application to Database that is online?

Much easier to write a little php page that they contact to interact with the database (with proper security precautions, of course). Otherwise you open the database to the world and it's subject to attack.

7. How do you advertise a database company online?

Even though it is not a small business, it is more of just another website that has alot of traffic flow. If you go to areas of heavy public use like myspace or any of those. Go to the very bottom of any of the websites front page. You will see a part that says most likely contact us. Then you simply type a business question or any question and they will give you the information you need. I suggest going through actual heavy places that arent soley business areas. Like here on yahoo, myspace, geocities, and other places. Just put up many things, they even have some myspace business profiles to promote business. That should stimulate alot of customer growth as far as I can see.

8. What is the best database language to learn?

The difference, from a developers point of view, between them is dialect extensions. Oracle uses PL/SQL, Microsoft and Sybase use T-SQL, and MySQL uses MySQL SQL. Another thing to keep in mind is that SQL Server from Microsoft only runs on the windows platform. The others are cross-platform. In addition, whether you decide to develop using ASP or PHP, you will be able to use any of the database systems for your web apps. ASP works very well with Microsoft SQL Server since they are developed and sold by the same company. PHP has built in functions for using the MySQL system. Also, ASP and PHP can be used in conjunction with an Oracle database. While you are making your decision, keep in mind that learning standardized SQL will allow you to write scripts/queries for any major database system.

9. How can I store different language file in Oracle database?

10. How to create a database from start to finish?

I believe WAMP5 includes MYSQL and PHP so you should be good to go as far as a database goes. The database (MYSQL) should already be pre-installed with the rest of the installation of WAMP5. The language that you will most likely use to interact with MYSQL is going to be PHP. Have you ever used PHP before? If not I suggest learning the entire PHP language not just database use. I suggest this site (http://www.webmonkey.com/webmonkey/programming/php/tutorials/tutorial4.html) ~ it looks good. If not just search PHP MYSQL on google. Hope this helps!

11. How do you setup an online database of downloadable files?

Make an account with rapidshare.com, it has a monthly cost though if you want to upload a lot of files.

12. Is there a free Microsoft Access database template for building a family tree?

You'd be better off designing your own MDB that way you can control the output features. or you can try this: http://www.fabalou.com/Access/General/genealogy_example.asp Family Matters for Access (I believe) http://www.matterware.com/ A Whole bunch of other Genealogy Software http://www.google.com/Top/Society/Genealogy/Software/ You can also get Family Tree Maker 2005 for free with limited features.

13. Where can I find a airport codes and cities database?

www.ifly.com

14. How does a database work in a large retail store?

In most cases, especially with Tier 1 retailers (like your example of Home Depot), there is no single database in the store that has all of the product data and information, but a collection of databases, which have been built 'fit for purpose' to support specific business processes in that environment. The most important of these will be the SKU PLU (price look up) file on the POS (point of sale) system that contains minimal product information, item numbers and prices. This same database usually contains any promotional pricing and clearance pricing also and is synchronized with the head-office database at least once a day to ensure correct pricing in stores and that each item can be scanned when it is taken to the checkout. Many retailers will also have an in-store inventory management system which will vary in complexity and breadth of function based on the sophistication of the retailer and their level of centralization. This will have functionality such as stock availability, expected receipts, special orders, stock taking/counting etc. In some cases this database will have a local copy which is synchronized periodically with a central repository - but in many cases, this database is actually housed centrally and you will see sales associates looking things up on 'green screen' terminals. So, although the business function and the access is taking place at the store, the database is not physically located there. This same system may also be responsible for tracking receipts as they are loaded from trucks out back - or this can be a separate system again, with yet another database.

15. How to remove image dupes from a database where the image files are 99% identical but have different hashes?

if they have different hashes you pretty boned

16. How much would a database consultant charge?

If this is for a commercial project, then i would estimate you would pay $100 an hour minimum for this kind of database consultancy. If this is for a non-profit school project then get someones' dad to do the database work :-)

17. How to build a database for a website?

18. How to I mirror cell contents from any cell in a database to one particular cell in Excel?

Assume the block of 5000 cells is in sheet1, as a sample i reduce it to only 50 cells A1:E10 the cell that depends on the click is F1 of Sheet1 Alt-F11 to open VBA editor, and double click on left Sheet1(Sheet1) icon then paste the following code to the right blank area Private Sub Worksheet_SelectionChange(ByVal Target As Range) ===============CHANGE VALUE AFTER = SIGN ONLY=== cellblock = A1:E10 targetsheet = Sheet1 targetcell = F1 '==============DON'T CHANGE CODE FROM HERE====== If Target.Cells.Count 1 Then Exit Sub If Not Intersect(Target, Range( cellblock)) Is Nothing Then Worksheets( targetsheet).Range( targetcell).Value = Target End If End Sub Here's is a demo http://www.freewebs.com/swhtam/YA/click2Assign.xls Alt+F11 to open vba editor to see the full code. Please post more or email me for more details Hope this helps.

19. What is the best way to maintain a database in a small company?

For 15 people I suggest Access. However, there are many other free database programs out there that you can download for free. Ofcourse, if you have license and you are expert than there are many other soultions like SQL, Oracle etc.

20. What classes should I take for database administrator in high school?