Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
a question about sql oracle please guide me?
A table stores information about citizens who have applied for mykad. The minium age requirement
for mykad is 18 years. Every citizen who registers will be assigned a unique serial no which will be
autogenerated. Table stores information like first name*, last name, *address, * date of birth,
age*, *registration date, *city of birth, *home state, *city of residence, *picture and occupation.
(information with * is compulsory).
You have to design the table with all the necessary constraints, Keys (primary and foreign if any) and
justify your approach for creating the design. The table creation DDL statement should be included
alongwith the field names, datatypes and design in tabular form
2 Answers
- TheMadProfessorLv 71 decade agoFavorite Answer
'age' is redundant (and would become inaccurate over time anyway), so don't store it. If you want the age criteria actually enforced from within the table, add a check constraint:
CREATE TABLE <whatever>
(<various column definitions>,
CONSTRAINT validAge CHECK (DATEADD(y, 18, birthDate) <= registerDate);
- hinajosaLv 45 years ago
i'm somewhat rusty on Oracle yet this might help The consumer call is a client that has the needed get admission to to the tablespace "equipment" is the known default for teh Oracle equivalent of the basis consumer the password is in spite of you positioned for the equipment account password once you probably did the set up. "supervisor" is the default i think the host string is the Oracle occasion call you gave the installation in the time of the set up
