Computer Science, asked by DigitalmazaForum22, 1 year ago

Can anyone solve the question no 1

Attachments:

Answers

Answered by mayur771
1
¶ let me start with part (b) the following can be used as field:
1) admission number
2)name
3)class
4)roll no
5)parents name
¶ for part (a)
1)acc_no:- text
2)cust_name:- text/memo but memo is more appropriate.
3)transaction:- memo/text
4)balance:- number
•acc_no can be used as primary key
•right click on the adjacent record where you want to add new then select new row.
Please note that record and row are same thing.
hope it helps if so mark as brainly.

DigitalmazaForum22: Answer the for part a?
mayur771: ya actually it is given just after part b read the answer carefully
Answered by Anonymous
0

Each field has its own type and range of values:

purchase_time: date and time of the sale sale_id: integer values incrementing by one for every new sale customer_id: integer values incrementing by one for every new customer currency: text always in the 3-character currency code amount_paid: monetary real numeric values between $0.00 and $1,000.00 device: text, where the values can be: ‘desktop’, ‘mobile app’, and ‘mobile web’ has_discount: boolean where entries can be TRUE or FALSE notes: text, where the entry can be as long as what is allowed in our agent input tool (250 characters)

The kind of data (integers, text, real numbers, etc…) and the possible value ranges (0 to 1,000; any 3 characters; etc…) correspond to specific database data types.

What are the Possible Data Types?

Different databases have different data types available, but most fit into these categories:

Numeric:

integers: for numbers without fractions. Can be signed (allow positive and negative values) or unsigned (only allow positive numbers). Commonly used for ID fields and counts of something

decimals(x,y): for numbers with fractions requiring exact precision. Can be signed (allow positive and negative values) or unsigned (only allow positive numbers). Commonly used for monetary fields. The user specifies the number of significant digits allowed overall and after the decimal point in the parentheses

float / doubles: for numbers with fractions not requiring exact precision. Can be signed (allow positive and negative values) or unsigned (only allow positive numbers). Commonly used for all real numbers except monetary fields

Date/time:

date: for date values

time: for time values

timestamp / datetime: for date and time values

Text:

character(n):for fixed-length character strings, where the value in the parenthesis dictates the fixed size of each entry

varchar(n): for variable-length character strings, where the value in the parenthesis dictates the maximum accepted size of each entry

Boolean:

boolean: for boolean (true/false) values. Some databases (like MySQL) don’t have boolean data type and instead convert boolean values into integers (1=TRUE, 0 = FALSE)

Similar questions