1) What word can be used to describe a single item of data stored in each database record? a) Record b) Field c) Database d) Query 2) A collection of records stored in a structured way about a common entity a) Record b) Field c) Datatype d) Table 3) How many records are in the image? a) 2 b) 4 c) 6 d) 8 4) What would be a good primary key for a product table for a retail company like Tesco? a) Barcode or ProductID b) Lastname c) MemberID d) Postcode 5) What would be a good datatype for a car registration number? a) Number b) Short Text c) Currency d) Autonumber e) Date/Time 6) What would be a good datatype for postal code or postcode in Thailand? a) Number b) Short Text c) Currency d) Autonumber e) Date/Time 7) What would be a good datatype for SchoolFees in a school database? a) Number b) Short Text c) Currency d) Autonumber e) Date/Time 8) What would be a good primary key for a Teacher Table? a) Teacher First Name b) Teacher Code c) TeacherID d) Teacher Date of Birth 9) What type of key is Class_ID in a Class Table? a) Primary b) Foreign c) Composite 10) What type of key is TeacherID in a student table? a) Primary b) Foreign c) Composite

Database Maze Chase

สั่งพิมพ์
ฝัง

ลีดเดอร์บอร์ด

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

คืนค่าการบันทึกอัตโนมัติ: ใช่ไหม