Lab 1 Practical To The Fundamental Of Creating Tables Ct042 3 1 Ct042 3 1 introduction to databases sql lab 1 using ms server, a) build a database named lab 1 b) build the table below and insert the data into the table. table name: student studentid name gender dob address s01 ali male 2 feb 1996 kuala lumpur s02 nancy female 16 may 1997 bukit jalil s03 melvin male 20 nov 1998 null. Level 1 asia pacific university of technology & innovation page 1 of 3 ct042 3 1 introduction to databases sql 6. display a list of books where book name contains the alphabet ‘a’ in the second position 7. display a list of books where book name begins with the alphabet ‘b’ and are at least 2 characters in length 8.
Lab 1 Introduction To Sql Pdf Laboratory Work 1 Introductionо Ct042 3 1 introduction to databases sql lab 3 supplier primary key: supplierid product primary key: productid supplies suppliesid supplierid productid supplieddate quantitysupplied 001 s01 p01 11 1 17 100 002 s01 p02 22 2 2017 200 003 s01 p03 null 300 004 s02 p03 30 4 2017 400 primary key: suppliesid foreign key: supplierid, productid 1. Ct042 3 1 introduction to database final exam page 10 of 10 a patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. however, each appointment is made with only one doctor, and each appointment references a single patient. Ct042 3 1 introduction to databases page 1 of 3 practice test 2 answer all questions. this lab test carries 80 marks . 1 using microsoft sql server, create a new database and name it with your student identification number. Sql. tutorial. sql is a standard language for storing, manipulating and retrieving data in databases. our sql tutorial will teach you how to use sql in: mysql, sql server, ms access, oracle, sybase, informix, postgres, and other database systems.
Comments are closed.