Question

In: Computer Science

Can you correct my database syntax so it works on rextester or dbfiddle. Error(s), warning(s): Column,...

Can you correct my database syntax so it works on rextester or dbfiddle.

Error(s), warning(s):
Column, parameter, or variable #2: Cannot find data type VARCHAR2.

CREATE TABLE Supplier
(    SuppNo        CHAR(8),
   SuppName   VARCHAR2(30) CONSTRAINT SuppNameRequired NOT NULL,
   SuppEMail   VARCHAR2(50),
   SuppPhone   CHAR(14),
   SuppURL       VARCHAR2(100),
    SuppDiscount   DECIMAL(3,3),
CONSTRAINT PKSupplier PRIMARY KEY (SuppNo) );

INSERT INTO supplier
   (SuppNo,SuppName,SuppEmail,SuppPhone,SuppURL,SuppDiscount)
   VALUES('S2029929','ColorMeg, Inc.','[email protected]','(720)444-1231','www.colormeg.com',0.10);

INSERT INTO supplier
   (SuppNo,SuppName,SuppEmail,SuppPhone,SuppURL,SuppDiscount)
   VALUES('S3399214','Connex','[email protected]','(206)432-1142','www.connex.com',0.12);

INSERT INTO supplier
   (SuppNo,SuppName,SuppEmail,SuppPhone,SuppURL,SuppDiscount)
   VALUES('S4290202','Ethlite','[email protected]','(303)213-2234','www.ethlite.com',0.05);

INSERT INTO supplier
   (SuppNo,SuppName,SuppEmail,SuppPhone,SuppURL,SuppDiscount)
   VALUES('S4298800','Intersafe','[email protected]','(512)443-2215','www.intersafe.com',0.10);

INSERT INTO supplier
   (SuppNo,SuppName,SuppEmail,SuppPhone,SuppURL,SuppDiscount)
   VALUES('S4420948','UV Components','[email protected]','(303)321-0432','www.uvcomponents.com',0.08);

INSERT INTO supplier
   (SuppNo,SuppName,SuppEmail,SuppPhone,SuppURL,SuppDiscount)
   VALUES('S5095332','Cybercx','[email protected]','(212)324-5683','www.cybercx.com',0.00);
  
CREATE TABLE Purchase
(    PurchNo    CHAR(8),
   PurchDate   DATE CONSTRAINT PurchDateRequired NOT NULL,
   SuppNo       CHAR(8) CONSTRAINT SuppNo2Required NOT NULL,
   PurchPayMethod   CHAR(6) DEFAULT 'PO',
    PurchDelDate   DATE,
CONSTRAINT PKPurchase PRIMARY KEY (PurchNo),
CONSTRAINT SuppNoFK2 FOREIGN KEY (SuppNo) REFERENCES Supplier );

INSERT INTO purchase
   (PurchNo,PurchDate,SuppNo,PurchPayMethod,PurchDelDate)
   VALUES('P2224040','3-Feb-2017','S2029929','Credit','8-Feb-2017');
  
INSERT INTO purchase
   (PurchNo,PurchDate,SuppNo,PurchPayMethod,PurchDelDate)
   VALUES('P2345877','3-Feb-2017','S5095332','PO','11-Feb-2017');

INSERT INTO purchase
   (PurchNo,PurchDate,SuppNo,PurchPayMethod,PurchDelDate)
   VALUES('P3249952','4-Feb-2017','S3399214','PO','9-Feb-2017');

INSERT INTO purchase
   (PurchNo,PurchDate,SuppNo,PurchPayMethod,PurchDelDate)
   VALUES('P3854432','3-Feb-2017','S4290202','PO','8-Feb-2017');

INSERT INTO purchase
   (PurchNo,PurchDate,SuppNo,PurchPayMethod,PurchDelDate)
   VALUES('P9855443','7-Feb-2017','S4420948','PO','15-Feb-2017');
  
    CREATE TABLE OrderTbl
(    OrdNo        CHAR(8),
   OrdDate       DATE    CONSTRAINT OrdDateRequired NOT NULL,
   CustNo       CHAR(8) CONSTRAINT CustNoRequired NOT NULL,
        EmpNo       CHAR(8),
        OrdName    VARCHAR2(50),
        OrdStreet VARCHAR2(50),
        OrdCity    VARCHAR2(30),
        OrdState   CHAR(2),
        OrdZip     CHAR(10),
CONSTRAINT PKOrderTbl PRIMARY KEY (OrdNo),
CONSTRAINT FKCustNo FOREIGN KEY (CustNo) REFERENCES Customer,
CONSTRAINT FKEmpNo FOREIGN KEY (EmpNo) REFERENCES Employee );

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1116324','23-Jan-2017','C0954327','E8544399','Sheri Gordon','336 Hill St.','Littleton','CO','80129-5543');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1231231','23-Jan-2017','C9432910','E9954302','Larry Styles','9825 S. Crest Lane','Bellevue','WA','98104-2211');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1241518','10-Feb-2017','C9549302','','Todd Hayes','1400 NW 88th','Lynnwood','WA','98036-2244');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1455122','9-Jan-2017','C8574932','E9345771','Wally Jones','411 Webber Ave.','Seattle','WA','98105-1093');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1579999','5-Jan-2017','C9543029','E8544399','Tom Johnson','1632 Ocean Dr.','Des Moines','WA','98222-1123');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1615141','23-Jan-2017','C8654390','E8544399','Candy Kendall','456 Pine St.','Seattle','WA','98105-3345');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1656777','11-Feb-2017','C8543321','','Ron Thompson','789 122nd St.','Renton','WA','98666-1289');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O2233457','12-Jan-2017','C2388597','E9884325','Beth Taylor','2396 Rafter Rd','Seattle','WA','98103-1121');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O2334661','14-Jan-2017','C0954327','E1329594','Mrs. Ruth Gordon','233 S. 166th','Seattle','WA','98011');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O3252629','23-Jan-2017','C9403348','E9954302','Mike Boren','642 Crest Ave.','Englewood','CO','80113-5431');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O3331222','13-Jan-2017','C1010398','','Jim Glussman','1432 E. Ravenna','Denver','CO','80111-0033');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O3377543','15-Jan-2017','C9128574','E8843211','Jerry Wyatt','16212 123rd Ct.','Denver','CO','80222-0022');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O4714645','11-Jan-2017','C2388597','E1329594','Beth Taylor','2396 Rafter Rd','Seattle','WA','98103-1121');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O5511365','22-Jan-2017','C3340959','E9884325','Betty White','4334 153rd NW','Seattle','WA','98178-3311');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O6565656','20-Jan-2017','C9865874','E8843211','Mr. Jack Sibley','166 E. 344th','Renton','WA','98006-5543');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O7847172','23-Jan-2017','C9943201','','Harry Sanders','1280 S. Hill Rd.','Fife','WA','98222-2258');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O7959898','19-Feb-2017','C8543321','E8544399','Ron Thompson','789 122nd St.','Renton','WA','98666-1289');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O7989497','16-Jan-2017','C3499503','E9345771','Bob Mann','1190 Lorraine Cir.','Monroe','WA','98013-1095');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O8979495','23-Jan-2017','C9865874','','HelenSibley','206 McCaffrey','Renton','WA','98006-5543');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O9919699','11-Feb-2017','C9857432','E9954302','Homer Wells','123 Main St.','Seattle','WA','98105-4322');

Solutions

Expert Solution

Below is modified queries for 2 tables :  supplier &  purchase

CREATE TABLE supplier
(    SuppNo        CHAR(8),
   SuppName   VARCHAR(30) NOT NULL,
   SuppEMail   VARCHAR(50),
   SuppPhone   CHAR(14),
   SuppURL       VARCHAR(100),
    SuppDiscount   DECIMAL(3,3),
CONSTRAINT PKSupplier PRIMARY KEY (SuppNo) );

INSERT INTO supplier
   (SuppNo,SuppName,SuppEmail,SuppPhone,SuppURL,SuppDiscount)
   VALUES('S2029929','ColorMeg, Inc.','[email protected]','(720)444-1231','www.colormeg.com',0.10);

INSERT INTO supplier
   (SuppNo,SuppName,SuppEmail,SuppPhone,SuppURL,SuppDiscount)
   VALUES('S3399214','Connex','[email protected]','(206)432-1142','www.connex.com',0.12);

INSERT INTO supplier
   (SuppNo,SuppName,SuppEmail,SuppPhone,SuppURL,SuppDiscount)
   VALUES('S4290202','Ethlite','[email protected]','(303)213-2234','www.ethlite.com',0.05);

INSERT INTO supplier
   (SuppNo,SuppName,SuppEmail,SuppPhone,SuppURL,SuppDiscount)
   VALUES('S4298800','Intersafe','[email protected]','(512)443-2215','www.intersafe.com',0.10);

INSERT INTO supplier
   (SuppNo,SuppName,SuppEmail,SuppPhone,SuppURL,SuppDiscount)
   VALUES('S4420948','UV Components','[email protected]','(303)321-0432','www.uvcomponents.com',0.08);

INSERT INTO supplier
   (SuppNo,SuppName,SuppEmail,SuppPhone,SuppURL,SuppDiscount)
   VALUES('S5095332','Cybercx','[email protected]','(212)324-5683','www.cybercx.com',0.00);
  
CREATE TABLE purchase
(    PurchNo    CHAR(8),
   PurchDate   DATE NOT NULL,
   SuppNo       CHAR(8) NOT NULL,
   PurchPayMethod   CHAR(6) DEFAULT 'PO',
    PurchDelDate   DATE,
CONSTRAINT PKPurchase PRIMARY KEY (PurchNo),
CONSTRAINT SuppNoFK2 FOREIGN KEY (SuppNo) REFERENCES supplier(SuppNo) );

INSERT INTO purchase
   (PurchNo,PurchDate,SuppNo,PurchPayMethod,PurchDelDate)
   VALUES('P2224040','2017-02-03','S2029929','Credit','2017-02-11');
  
INSERT INTO purchase
   (PurchNo,PurchDate,SuppNo,PurchPayMethod,PurchDelDate)
   VALUES('P2345877','2017-02-03','S5095332','PO','2017-02-11');

INSERT INTO purchase
   (PurchNo,PurchDate,SuppNo,PurchPayMethod,PurchDelDate)
   VALUES('P3249952','2017-02-04','S3399214','PO','2017-02-09');

INSERT INTO purchase
   (PurchNo,PurchDate,SuppNo,PurchPayMethod,PurchDelDate)
   VALUES('P3854432','2017-02-03','S4290202','PO','2017-02-08');

INSERT INTO purchase
   (PurchNo,PurchDate,SuppNo,PurchPayMethod,PurchDelDate)
   VALUES('P9855443','2017-02-07','S4420948','PO','2017-02-15');

To create OrderTbl table first create Customer and Employee table and add data to it because OrderTbl references Customer and Employee table. Then modify syntax for OrderTbl as below:

    CREATE TABLE ordertbl
(    OrdNo        CHAR(8),
   OrdDate       DATE NOT NULL,
   CustNo       CHAR(8) NOT NULL,
        EmpNo       CHAR(8),
        OrdName    VARCHAR(50),
        OrdStreet VARCHAR(50),
        OrdCity    VARCHAR(30),
        OrdState   CHAR(2),
        OrdZip     CHAR(10),
CONSTRAINT PKOrderTbl PRIMARY KEY (OrdNo),
CONSTRAINT FKCustNo FOREIGN KEY (CustNo) REFERENCES Customer(CustNo),
CONSTRAINT FKEmpNo FOREIGN KEY (EmpNo) REFERENCES Employee(EmpNo) );

And then add data to OrderTbl using below queries.

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1116324','2017-01-23','C0954327','E8544399','Sheri Gordon','336 Hill St.','Littleton','CO','80129-5543');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1231231','2017-01-23','C9432910','E9954302','Larry Styles','9825 S. Crest Lane','Bellevue','WA','98104-2211');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1241518','2017-02-10','C9549302','','Todd Hayes','1400 NW 88th','Lynnwood','WA','98036-2244');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1455122','2017-01-09','C8574932','E9345771','Wally Jones','411 Webber Ave.','Seattle','WA','98105-1093');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1579999','2017-01-05','C9543029','E8544399','Tom Johnson','1632 Ocean Dr.','Des Moines','WA','98222-1123');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1615141','2017-01-23','C8654390','E8544399','Candy Kendall','456 Pine St.','Seattle','WA','98105-3345');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O1656777','2017-02-11','C8543321','','Ron Thompson','789 122nd St.','Renton','WA','98666-1289');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O2233457','2017-01-12','C2388597','E9884325','Beth Taylor','2396 Rafter Rd','Seattle','WA','98103-1121');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O2334661','2017-01-14','C0954327','E1329594','Mrs. Ruth Gordon','233 S. 166th','Seattle','WA','98011');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O3252629','2017-01-23','C9403348','E9954302','Mike Boren','642 Crest Ave.','Englewood','CO','80113-5431');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O3331222','2017-01-13','C1010398','','Jim Glussman','1432 E. Ravenna','Denver','CO','80111-0033');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O3377543','2017-01-15','C9128574','E8843211','Jerry Wyatt','16212 123rd Ct.','Denver','CO','80222-0022');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O4714645','2017-01-11','C2388597','E1329594','Beth Taylor','2396 Rafter Rd','Seattle','WA','98103-1121');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O5511365','2017-01-22','C3340959','E9884325','Betty White','4334 153rd NW','Seattle','WA','98178-3311');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O6565656','2017-01-20','C9865874','E8843211','Mr. Jack Sibley','166 E. 344th','Renton','WA','98006-5543');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O7847172','2017-01-23','C9943201','','Harry Sanders','1280 S. Hill Rd.','Fife','WA','98222-2258');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O7959898','2017-02-19','C8543321','E8544399','Ron Thompson','789 122nd St.','Renton','WA','98666-1289');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O7989497','2017-01-16','C3499503','E9345771','Bob Mann','1190 Lorraine Cir.','Monroe','WA','98013-1095');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O8979495','2017-01-23','C9865874','','HelenSibley','206 McCaffrey','Renton','WA','98006-5543');

INSERT INTO ordertbl
   (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
    OrdState, OrdZip)
   VALUES ('O9919699','2017-02-11','C9857432','E9954302','Homer Wells','123 Main St.','Seattle','WA','98105-4322');

venereology answered 4 months ago
Next > < Previous

Related Solutions

can you check if my answers are correct and can you please type the correct answers...
can you check if my answers are correct and can you please type the correct answers for each question 5 points) Trevor is interested in purchasing the local hardware/electronic goods store in a small town in South Ohio. After examining accounting records for the past several years, he found that the store has been grossing over $850 per day about 60% of the business days it is open. Estimate the probability that the store will gross over $850 at least...
"How can I connect my hadoop database or mysql database server to my d3 visual?"
"How can I connect my hadoop database or mysql database server to my d3 visual?"
My code works in eclipse, but not in Zybooks. I keep getting this error. Exception in...
My code works in eclipse, but not in Zybooks. I keep getting this error. Exception in thread "main" java.util.NoSuchElementException at java.base/java.util.Scanner.throwFor(Scanner.java:937) at java.base/java.util.Scanner.next(Scanner.java:1478) at Main.main(Main.java:34) Your output Welcome to the food festival! Would you like to place an order? Expected output This test case should produce no output in java import java.util.Scanner; public class Main {    public static void display(String menu[])    {        for(int i=0; i<menu.length; i++)        {            System.out.println (i + " - " + menu[i]);...
while doing FPLC my dye(MHI-148) got stuck in column? . so how can i clean the...
while doing FPLC my dye(MHI-148) got stuck in column? . so how can i clean the column efficient? and why some particle stuck in column?
How can I improve my code below to meet the requirements of this assignment with syntax...
How can I improve my code below to meet the requirements of this assignment with syntax add to my code to complete the assignment below: #include <iostream> #include <vector> using namespace std; class Inventory { private: int itemNumber; int quantity; double cost; double totalCost; public: Inventory() { itemNumber = 0; quantity = 0; cost = 0; totalCost = 0; } Inventory(int n, int q, double c) { itemNumber = n; quantity = q; cost = c; setTotalCost(); } void setItemNumber(int...
Here is my java code. It works and has the correct output, but I need to...
Here is my java code. It works and has the correct output, but I need to add a file and I am not sure how. I cannot use the FileNotFoundException. Please help! import java.io.File; import java.io.FileNotFoundException; import java.util.Scanner; public class Exercise { public static void main(String[] args) { Scanner input=new Scanner(System.in); int[] WordsCharsLetters = {0,0,0}; while(input.hasNext()) { String sentence=input.nextLine(); if(sentence!=null&&sentence.length()>0){ WordsCharsLetters[0] += calculateAndPrintChars(sentence)[0]; WordsCharsLetters[1] += calculateAndPrintChars(sentence)[1]; WordsCharsLetters[2] += calculateAndPrintChars(sentence)[2]; } else break; } input.close(); System.out.println("Words: " + WordsCharsLetters[0]); System.out.println("Characters: "...
12) Can you please see that the calculations are correct, this is my 3rd try with...
12) Can you please see that the calculations are correct, this is my 3rd try with this same question and I've paid for every attempt. Thank you. A bicycle manufacturer currently produces 349,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $1.90 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct in-house production...
Is my writing for this email correct? I mean academy and grammar. (you can edit and...
Is my writing for this email correct? I mean academy and grammar. (you can edit and add any sentence) Dear sir/madam, UK Visas and Immigration I hope you are doing well. I am working hard to provide evidence from The University of Sydney confirming my new admission dates commencing within 3 months according to your e-mail request on October 2, 2020. Noting that my Visa Application( GWF0565848 ) was to get an alternate visa with new entry dates because I...
Is my writing for this email correct? I mean academy and grammar. (you can edit and...
Is my writing for this email correct? I mean academy and grammar. (you can edit and add any sentence) Dear Prof. Joseph, I hope you are doing well. As you know that the circumstances of the Corona pandemic caused the borders to close and the suspension of international flights, which led to my delay in coming to my mission headquarters in Britain, in addition to that the University of Manchester has been largely closed to students since March 2020. I...
Is my writing for this email correct? I mean academy and grammar. (you can edit and...
Is my writing for this email correct? I mean academy and grammar. (you can edit and add any sentence) I hope you will help me in drafting this e-mail Dear Prof. Joseph. I hope you are doing well. As you know, I received an email from the decision-making center stating that it is necessary to update the Academic Technology Approval Scheme (ATAS) certificate which ended on July 15,2020. Consequently, I have applied for the ATAS online to UKVI on October...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT