CREATE TABLE owner(ownerId NUMBER,
                    firstname VARCHAR(25) NOT NULL,
                    lastname VARCHAR(25) NOT NULL,
                    email VARCHAR(25) NULL UNIQUE,
                     CONSTRAINT owner_pk PRIMARY KEY(ownerId)
                    );

CREATE TABLE car(registration  VARCHAR(10) NOT NULL UNIQUE,
make VARCHAR(20) NOT NULL,
modelname VARCHAR(20) NOT NULL,
color VARCHAR(9) NOT NULL,
capacity NUMBER NOT NULL) ;

INSERT INTO owner VALUES(1,'ken@dit.ie','Ken','Delvin');
INSERT INTO owner VALUES(2,'jan@rte.ie','Jane','Doe');
INSERT INTO owner VALUES(3,'fred@ibm.ie','Fred','Bloggs');

INSERT INTO car  VALUES('07D11211','Toyota', 'Lexus','silver',6);
INSERT INTO car VALUES('00D12831','Volkswagen','Golf','blue',5) ;
INSERT INTO car VALUES('80D2002','Ford','Escort','brown',5) ;
INSERT INTO car VALUES('50D303','Ford','Anglia','black',4) ;

CREATE TABLE Ownership (
                          CONSTRAINT owner_fk ownerId references owner(ownerId),
                          CONSTRAINT reg_fk  regId references car(registration),
                          percentage NUMBER NULL,
                          CONSTRAINT t_pk PRIMARY KEY (ownerId,regId)
                        );


INSERT INTO Ownership VALUES(1,'00D12831',50) ;
INSERT INTO Ownership VALUES(2,'00D12831',50) ;
SELECT * FROM Ownership;

SELECT * FROM Ownership;
SELECT * FROM Car;
SELECT * FROM oWNER;
 SELECT * FROM ownership;