Answered step by step
Verified Expert Solution
Question
1 Approved Answer
DOCTOR DocID 101 102 103 FirstName Muhammad Maryam Sumayyah LastName Fatch Mazlan Idris Specialization Surgery Neurology Dermatology HireDate 15/05/2000 21/03/2001 07/02/2003 PATIENT Patient ID FirstName
DOCTOR DocID 101 102 103 FirstName Muhammad Maryam Sumayyah LastName Fatch Mazlan Idris Specialization Surgery Neurology Dermatology HireDate 15/05/2000 21/03/2001 07/02/2003 PATIENT Patient ID FirstName Khai Haqiem Siti Nurhaliza LastName Bahar Rusli Taruddin DocID 101 102 101 222 333 The tables show the data for PATIENT and DOCTOR. Each patient will be treated by only onc doctor and cach doctor will treat many patients. Answer the following questions. a) Create table for PATIENT with these constraints: PatientID is a primary key and unique. DocID is the foreign key which referring to DocID in DOCTOR table. PatientID cannot be null. (5 marks) 101). State its b) Admin wants to insert a new doctor named Ali bin Abu (DocID possibility of the insertion according to entity integrity constraint rules. (2 marks) c) Find the list al doctors who start working between 2000 until 2019 and his her specialization is surgery (3 marks A Read aloud Draw Instruction: 1. Create a database. 2. Construct SQL statements for the following questions. 3. Screenshot your Ms Access output 4. Submit your Ms Access database Consider the following relational database: PUBLISHER AUTHOR BOOK CUSTOMER WRITING BOOKNUM (PublisherName, City, State, Country, Telephone) (AuthorNum, AuthorName) (BookNum, BookName, Publication Year. Pages, PublisherName) (CustNum. CustName. Street, City. State Country. BookNum) (BookNum, AuthorNum) (BookNum, CustNum, BookDate. Price. Quantity) a) Create table PUBLISHER with S records (4 marks) b) Create table BOOK with 5 records c) Create table BOOKNUM 71 marks) d) Show the relationship between tables e) Modify table AUTHOR to add a new column called AuthorDOB. 1) List the book number: book name and number of pages of all the books published by John Wiley. View the rusults by book name in descending order. (3 marks) 2) Find how many books with at least 300 pages that is published by Pustaku Trading located in lasin. Melale hi Find the publisherwhich published the book that hus the earliest publication year
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started