Computers and Technology, 31.08.2019 05:20 colleenroyle8717

Dbms is a container where tables and data are stored? (true/false)

Answers: 2

Show answers

Answers

Answer from: salvadorperez26

true

Explanation:

Database or Database Management System

Database acts like a container which holds all the tables and data inside the tables.

Tables represent a real world subject and hold all relevant data pertaining to that subject.

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.

Database Schema

It refers to the blueprint of the database.

A schema shows all the tables, their relations with other tables and their constituent columns.

Every table has a primary key column, which acts as a unique identifier for the table, 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.

Example

Consider a scenario where a store, ABC, 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.

The Database is named as ABCdb.

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

idk i had the answer

Answer from: Quest

Ce3

Another question on Computers and Technology

Computers and Technology, 22.06.2019 16:50

Consider a slotted aloha system, where the time slot equals the fixed duration of each packet. assume that there are 4 stations a,b,c,d sharing the medium. (a) stations a,b,c,d receive one packet each from higher layers at times 1.3, 1.5, 2.6,5.7 respectively. show which transmissions take place when, according to the slottedaloha protocol; describe all transmissions until all four packets have been successful.when needed, each station has access to the following sequence of random number, provided by a random number generator and drawn uniformly between 0 and 1: (1) station a draws numbers: 0.31, 0.27, 0.78, 0.9, 0.9, 0.11, 0. (2) station b draws numbers: 0.45, 0.28, 0.11, 0.83, 0.37, 0.22, 0. (3)station c draws numbers: 0.1, 0.2, 0.3, 0.4, 0. (4) station d draws numbers: 0.36, 0.77, 0.9, 0.1, 0.1, 0.1, 0.1, 0. (b) in slotted aloha, a station transmits in each time slot with a given probability. what probabilities would you assign to each of the four stations so as to: (i) maximize the efficiency of the protocol? (ii) maximize fairness among the four stations? (c) will the efficiency increase or decrease if we modify slotted aloha as follows: (i) get rid of slots and allow stations to transmit immediately? (ii) implement carrier sensing? (iii) implement collision detection? (iv) implement collision avoidance?

Answers: 3

Answer

Computers and Technology, 22.06.2019 17:30

Rachel completed typing an official document with a word processing program. she wants to make sure that her document has no typographical errors. she also wants all headings to have the same font. which features in a word processing program should she use? rachel should use the feature in a word processing program to find typographical errors. she should apply to have uniform headings.

Answers: 1

Answer

Computers and Technology, 23.06.2019 09:30

The place where the extended axis of the earth would touch the celestial sphere is called the celestial

Answers: 1

Answer

Computers and Technology, 23.06.2019 13:30

Stops: using the information learned in this course, explain three things you will not do when driving. a. b. c. explain why you will not do these things when driving. starts: using the information learned in this course, explain three things you will do when driving. a. b. c. explain why you will do these particular things when driving. explain one thing you will stop doing as a passenger. explain one thing you will start doing as a passenger.

Answers: 3

Answer

You know the right answer?

Dbms is a container where tables and data are stored? (true/false)...

Questions