(n integer; fleld should be the primary key) Author name (short text/120 characters) Book name (short text/255 characters) Publication year (number/integer) Pages (number/long integer) Category (short text/25 characters) which contains 1153 books record. Express the result in binary-style KB. A 8 x 10 inch photo scanned at 600 dots per inch (dpi) with 24-bit color. 1) Express your answer in binary-style MB. Suppose that your compression algorithm attains a compression factor of 200. 2) How many binary-style KB would the picture consume after compression?

(n integer; fleld should be the primary key) Author name (short text/120 characters) Book name (short text/255 characters) Publication year (number/integer) Pages (number/long integer) Category (short text/25 characters) which contains 1153 books record. Express the result in binary-style KB. A 8 x 10 inch photo scanned at 600 dots per inch (dpi) with 24-bit color. 1) Express your answer in binary-style MB. Suppose that your compression algorithm attains a compression factor of 200. 2) How many binary-style KB would the picture consume after compression?

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

Discuss the problems that can be caused by data redundancy.
In the hierarchy of data, what is the difference between a data attribute and a data item? What is the domain of an attribute?
In a few words, please explain the lingo used to describe the data. When was the data dictionary built, where did the information come from, and what is it used for?
Since the database is not available the following is provided to gain a better understanding Sales Table contains the following fields- Sales ID, Invoice No., TransDate, Description, Colour, Size, Qty, Price , Store ID, Year ID, Brand, Name (of customers), Address, Currency Id, Yearval Location Table contains the following fields - Store ID, Store Name, Store Type (which details what is Duty paid(DP) or Duty free(DF)), Hotel, Home Currency, and Can sell? Currency Table fields are - Currency ID, Rate (rates- USD: 2.0675 and BDS: 1) Relationships between tables have been formed and referencial intergrity enforced. QUESTIONS The company has been informed that the tax has been increased from 15% to 17.5%. Calculate how much additional tax (i.e., the difference) the store would have collected by year. Name this query Q3 – ADDED-TAX. Then, Create a report showing the following for Jan, Feb, Mar in 2009. Duty-free sales, duty-paid sales, and taxes (original) are collected monthly by…
Then, what exactly is meant by the term "data dictionary"? Explain.
What exactly is data redundancy? Please provide an example of redundant value.
Then, what exactly is a data dictionary? Explain.
Explain why you sometimes need to set aside significantly more space for a numeric field than any of the initial stored values require.
What is the significance of declaring that the granularity of data has been established?
The most important tables in the library information system are the following. Books (bid, author, title, publisher, year); Members (mid, name, surname, address, telephone); Rental (rid, mid, bid, eid, date); Employee (eid, name, surname, address, telephone) All tables are sorted according to the key. The following information is given. 1 page on the disk = 8KB |Books| = 1.000.000 records, 320 bytes, 25 records/page, 40000 pages |Members| = 10.000 records, 200 bytes, 40 records/page, 250 pages |Rental| = 300.000 records, 40 bytes, 200 records/page, 1500 pages |Employee| = 100 records, 200 bytes, 40 records/page, 3 pages We can have 25.000 pages in the buffer. QUESTION 2.1 B+ index is used on the attribute Books.publisher. The size of the record identifier is 8B, the size of the page identifier is 6B. Calculate the size of the B+ index whose pages are filled to their minimum capacity as accurately as possible. Write down all assumptions.
A relational database has the following schema: Customer (Cno, name, address, age, loan_type, loan_amount, year) Solve following queries in relational algebra: Select the records where loan_type is 'Personal'. Select the records where age is geater than 30 and loan_type is ‘soft’. Select records from Customer table where loan_type is ‘Personal' and loan_amount is Rs200000 or those customers who opened an account after 2017. Project the columns name and address from the Customer table.
The following action is being done by both database users and database creators: