Computers and Technology, 21.08.2019 23:30 rubes08

Explain what is a database schema and mention one example

Answers: 3

Show answers

Answers

Answer from: firdausmohammed80

Database

It is used to store data in tables. Tables, known as relations, are divided into columns and rows. Columns show the information stored while rows hold the actual information.

A database is a collection of tables which are related to other tables through common columns, hence known as relational database.

Schema

It refers to the blueprint of the database. A schema shows all the tables, their relations with other tables and the columns which relate or link two or more tables.

Every table has a primary key column along with other columns. The primary key ( pk ) when used in other table of the same database, becomes foreign key ( fk ) in the other table. The pk/ fk link tables in every database.

Schema can be logical and physical.

Logical schema

It defines the tables with their attributes ( columns ).

Physical schema

It is the actual implementation of the database which also includes structures like indexes, hash tables and others.

Example

Consider a scenario where a store needs to track data for a business. It keeps track of all its customers, products and orders. An order can contain only one product purchased by one customer.

Relations/ Tables

Customers ( custID, custName, custAddress, custPhone )

Products ( prodID, prodName, prodDescription, prodUnitPrice, prodQOH, prodThreshold )

Orders ( oID, oDate, custID, discount, total )

Foreign key custID references Customers ( custID )

OrderLine ( ID, oID, prodID, units, subtotal )

Foreign key oID references Orders ( oID )

Foreign key prodID references Products ( prodID )

Primary key of every table is shown as underlined.

Foreign key of every table is shown in italics.

The above is called the relational schema of the given scenario. It consists of all the tables with their columns or attributes. The tables are related through pk/ fk.

Answer from: Quest

by trying your best others ^_^

but don't try sending them fake answer, it must to be real answer.

the reason why you must not send them fake answer cause the experts and the questioner will moderate you and if they find out its fake they will report your to the owner of this website which its called

explanation:

Answer from: Quest

they really not common the os x is just a better version of the os like in iphone theirs xr and their xs

Another question on Computers and Technology

Computers and Technology, 22.06.2019 11:30

Write a function so that the main program below can be replaced by the simpler code that calls function original main program: miles_per_hour = float( minutes_traveled = float( hours_traveled = minutes_traveled / 60.0 miles_traveled = hours_traveled * miles_per_hour print('miles: %f' % miles_traveled) sample output with inputs: 70.0 100.0 miles: 116.666667

Answers: 3

Answer

Computers and Technology, 22.06.2019 19:30

The following is an excerpt from a slide presentation. today we will inverse operations solving equations using inverse operations solving inequalities using inverse operations from which part of the presentation does the slide most likely come from? a. introduction b. outline c. body d. conclusion

Answers: 1

Answer

Computers and Technology, 23.06.2019 02:30

Experimental data that is expressed using numbers is said to be

Answers: 1

Answer

Computers and Technology, 23.06.2019 18:00

What can a word user do with the customize ribbon dialog box? check all that apply. minimize the ribbon add a new tab to the ribbon remove a group from a tab add a group to a tab choose which styles appear choose which fonts appear choose tools to appear in a group

Answers: 1

Answer

You know the right answer?

Explain what is a database schema and mention one example...

Questions