answersLogoWhite

0

How do you make a database?

User Avatar

Wiki User

7y ago

Best Answer

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 our example, this would include rooms, guests, reservations, stays, etc. You also would identify the relations between these things - a guest makes a reservation for a room and so on. A frequent tool to do this is called an Entity-Relationship or ER Diagram.

3) Design the general structure of the database with respect to the ER diagram - each entity usually will become one or more database tables and the relationships frequently denote foreign key relations between tables. Also identify cardinalities (one-to-one, one-to-many, many-to-many, etc.) Note that many-to-many relationships will require additional tables to normalize.

4) Flesh out the tables with the various data elements in each and specify data constraints (primary and foreign keys, data domains, etc.)

At this point, you may have enough information to begin creating the actual database.

User Avatar

Wiki User

7y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you make a database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the explanation for the role of the database administrator?

A database administrator oversees all aspects of the database. He/she will be the person who has the ability to make anything happen with the management of the database.


What are the database management activities?

Make sure the database does not run out of space. Nowdays no manual intervention is required in products from major database vendors like Oracle. Make sure the database jobs are running with no issues. Configure, Schedule backups Make sure backup and recovery procedures work as configured. Database security is another task.


Who is a database designer?

A database designer is a person who specifies how a database records are stored, accessed and related to make sure there is adequate performance!


What rhymes with database?

Make a case


What do you mean by database driver?

JDBC which is short for java database connectivity is used to connect database to a java project . To make connectivity a database driver is required to establish the connection.


Why would you sort a database?

You would sort a database to make it easier for a computer to recall information.


What is database softwaer?

The correct spelling is database software instead of database softwear. Database software is a utility or software program. It is used to make databases and manage and edit the information that is kept in them.


Database Application Development?

form_title=Database Application Development form_header=Once you have your database, you will need apps to make your business run smoother. What is your budget for the development?=_ What features do you want on your database application?=_ Why do you want to develop a database application?=_


What is the meaning of SQL Mirroring?

SQL mirroring, or database mirroring, is supposed to be able to increase the database space and the boost the protection of the database to make it a secure area.


What is an important step to take before entering your first data into you database?

First you must make a reasonable effort to make sure that your database is structured correctly.


How to make a database?

A database can be created by first creating a schema then creating tables. The tables are linked to each other.


What is a record in the database?

In the structure of a database, the part consisting of several uniquely named components called data fields. Several data records make up a data file, and several data files make up a database.