Answer asap.. will give good review Step 1: Create a relational table called Pat

Question

Answer asap.. will give good review Step 1: Create a relational table called Patients and insert 5 sample records as below: Create Table Patients( PID int primary key, Name varchar(30) Not Null, Phone char(10), Email varchar(50), Username varchart20), Password varchar(20) Step 2: create XML data file and related schema file. Step 3: create JSON data file and related schema file Step 4: create AVRO file, compile and add some records of data using either JAVA APl or AVRO command line tools. Submit the detailed process and code. The example of data file, schema file and the necessary code may be available at the following links 1. http:/ljava.dzone.com/articles/getting-started-apache- avro 2. http://java.dzone.com/articles/getting-started-avro- part-2 Please keep consistent with all field names and data type.

Explanation / Answer

1. create table patients (Parent id PID int primarykey, name varchar(30) not null, phone char(10), email varchar(50),username varchar(20),password varchar (20));

insert into patients(1,"AAA",xxxxxxxxxx,xxx.com,"aaa1",ssss)

insert into patients(2,"BBB",yyyyyyyyyy,yyy.com,"bbb2",hhhh)

insert into patients(3,"CCC",zzzzzzzzzz,zzz.com,"ccc3",ffff)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.