Can anyone solve the question no 1
Answers
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.
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)