One table should be able to store the username and password of users for session management. Insert one record in this table for use later in the project. The second table should be able to store the articles written by the user. The only information we need for articles is the author (which would be a user of the system), the title of the article and the content of the article. The content field should be able to store at least a thousand characters. Insert one simple record in this table for use later in the project

One table should be able to store the username and password of users for session management. Insert one record in this table for use later in the project. The second table should be able to store the articles written by the user. The only information we need for articles is the author (which would be a user of the system), the title of the article and the content of the article. The content field should be able to store at least a thousand characters. Insert one simple record in this table for use later in the project

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 5HOA: Access path A database table is composed of records and fields hold data. Data is stored in records....

See similar textbooks

Similar questions

Expand the database design you created in exercise1 so that it will also support the following situation: a specific therapist handles each therapy (a therapist can handle more than one). Along with all the details concerning sessions listed in exercise1, list the ID, last name, and first name of the therapist assigned to handle the request.
In this database we have users that can be two types students or instructors. They have groups and memberships. Any user can post and the post type can be video, photo or text. Here is the table structure: CREATE TABLE USER_ ( USER_ID INT NOT NULL AUTO_INCREMENT, CREATE_DATE DATE NOT NULL, PROF_DESC VARCHAR (100), PROF_PIC VARCHAR(40), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (USER_ID) ); CREATE TABLE USER_INFO( USER_ID INT NOT NULL, SU_EMAIL CHAR(18), USER_FNAME VARCHAR(15), USER_LNAME VARCHAR (15), USER_DOB DATE, USER_GENDER CHAR(1), PRIMARY KEY (USER_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE STUDENT ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, YEAR_ VARCHAR (10), MAJOR VARCHAR (20), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (SU_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE INSTRUCTOR ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, DEPARTMENT VARCHAR (40), INSTR_TYPE VARCHAR (40),…
EventHelpers is a company that specializes in event medical assistance. They can hande any type of medical emergency. The company has a range of employees from first aiders to paramedics with degrees. EventHelpers has contacted you to help them design the database so that they can keep track of which employees went to which events. The company provided you with the following details: • Afirst aider has a certificate, which indicates the expiration date of the certificate. The certificate has to be renewed every three (3) years. • A paramedic has a degree that does not expire. • The company needs the ID, Name, Sumame, Contact details, and the address of each employee. • The company sends several medical assistants, a few first aiders and, depending on the size of the events, 1-3 ambulances, to each event. • Each medical assistant is paid per hour based on their qualificafion. To book EventHelpers for an event, the following details are required: • The name of the event. • The time and…
Open your text editor and create a new document named model.php model.php will contain functions that will connect to a database potentially return PDO statementobjects to the controller for processing. updateMessagesfunction updateMessages($id)This method will take a single parameter of id which is the saved id from the last or latest message displayed. It will conditionally select from the table “messages”, id, name, message, and time. The condition is that the field id is greater than the parameter for id. The return is the PDOStatement object with the row data from the query.
Now that you've been hired to work on a database, you have the choice of using a trigger or a process. Triggers: What are they and when do you utilise them?
You have a list of all your contacts details that you would like to store in a database. Your goal is that when a record is inserted in contacts table, you also want this record to be stored (inserted) in a backup table. Assume you have the two tables created: CONTACTS and CONTACTS_BACKUP. These two (2) tables have the same records. The CONTACTS table have the following columns: CONTACT_ID (Primary_Key), FIRSTNAME, LASTNAME and MOBILE_NO. CONTACTS_ID FIRSTNAME LASTNAME MOBILE_NO 1 100 Princess Kim 813023895 2 101 Henry Packer 811257891 3 102 Petrus Johannes 855698712 4 103 Lukas Shilongo 832584691 The CONTACTS_BACKUP table have the same columns and records as the CONTACTS table. CONTACTS_ID FIRSTNAME LASTNAME MOBILE_NO 100 Princess Kim 813023895 2 101 Henry Packer 811257891 3 102 Petrus Johannes 855698712 4 103 Lukas Shilongo 832584691 You now need to keep both tables in sync so that when a record is inserted into the CONTACTS table it should automatically be inserted into…
A manager has a list of items that have been sorted according to an item ID. Some of them are duplicates. She wants to add a code to the database that assigns a 1 to the item if it is unique, and if there are duplicates, assigns the number of the duplicate. An example is shown below. The first two items are unique, so the repeat code is 1. However, Item ID 37695 is listed six times, so the codes are assigned from 1 to 6, and so on. Explain how to assign the correct code using an IF statement Item ID Repeat Code35080 135222 137695 137695 237695 337695 437695 537695 637712 137722 137757 137757 2 In cell B2 enter 1, and then type a formula into cell B3, followed by dragging the formula down column B until it aligns with the last row in the Item ID column. Which of the following is the correct formula to type into cell B3?
An insurance company needs to store their salespeople’s information who are selling their insurance policies. They already have a database with multiple tables, one of the tables (Salesperson) stores information about each salesperson along with the bonus percent they receive, based on the city where the insurance is sold. The table has the following fields: Salesperson(spID, spName, spBirthDate,spCitySelling, bonusPercent) spID: Unique identification number of the salesperson. spName: Full name of the salesperson. spBirthDate: Birthdate of the salesperson. spCitySelling: The city in which the salesperson is selling the insurance. bonusPercent: The bonus percent received by the salesperson based on the city in which he/she sells the insurance. Each salesperson can sell the insurance in just one city. However, for a city, there can be more than one salesperson appointed. Also, the bonus percent is fixed for each city. For example, all of the salespeople who sells insurance in…
The StayWell Property Management team considers creating a discount scheme for the property owners with more than one property in the system. You will need to provide all the owner IDs ( OWNER_NUM ) and the count of properties of the owners with more than one active property in the database. The output columns should be OWNER_NUM and COUNT(*) respectively. Task Provide a list of owner IDs ( OWNER_NUM ) for owners of 0.00 out of 10.00 more than one active property. O out of 1 checks passed. Review the results below for more details.
A hospital would like to set up a database recording which registered nurse looked after which patient etc. Each registered nurse has a unique nurse ID, and each patient has a unique patient ID, and the following attributes are found for nurses, and patients in the first round of design: NURSE: nurselD, suname, first name, birthdate, dept-code, sex, salary-level PATIENT: patientlD, surname, first name, birthdate, wardlD, sex, admission_date, discharge_date A recent duty list shows the patients that were cared by each nurse in past 2 months, see below for some samples:
The SQLiteOpenHelper and SQLiteCursor classes are described, with a focus on how they may be used to perform create, read, update, and delete (CRUD) actions on a SQLite database.
using php We run a dog grooming shop, there are new 4 breeds that are being registered to our system. Please add their names, breeds, and ages to the database, also display the new inputs with non-prepared statements Requirement 1: Require the programmer to insert rows Requirement 2: Require the programmer to display the rows after they have been changed Requirement 3: Require use of a non-prepared statement