Create a database table that includes at least 12 columns   Use VBA tools to create a user form the form should be user friendly and interact with at least three other forms, It should allow the user to add a new complete information to the database and edit a current information available in the database. The user should be restricted to add any duplicated informatio

Fields in a database are defined by their field name, which specifies whether the field contains text, dates, numbers, or other formats. O True O False

Database indexes should ideally be created a small tables. O True False

Scenario and Database Model: Instant Ride InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the Instant Ride mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email: USER_ID 3001 3002 3003 3004 3005 3006 3007 3008 USERS Table 2001 2002 2003 2004 USER_FIRST_NAME Willie Justin Anthony Ece Jack Ryan Nursin Sarah Bobby Randy Jose DRIVERS Table Nursin Butler Howard In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information: Walker DRIVER_ID DRIVER_FIRST_NAME DRIVER LAST NAME DRIVER DRIVING LICENSE_ID…

True or False When working with the data in a database table, the column that is designated as the primary key must hold a unique value for each row.

Describe procedure of views saving reprogramming effort.

When is it acceptable to manually create an index?

Design and develop android application that inserts movie information into database. The following is required: Validation: duration must be >0 and less than 20 (Show appropriate toast message otherwise) Movie rating is a drop down list with values between 1 and 10 Movie year is a drop down list with values from 1950 until today's year Show appropriate success message (using dialog) when the movie is successfully added to database Insert movie information to database is achieved using a php web service Database type is MYSQL You should submit the following: o Java files Layout files o AndroidManifest.xml o Build.gradle that contains the dependencies of your project o php web service file Table movie looks like the following: Mid Mname Duration Rating myear The design looks like the following: Movie Name Movie Duration Movie Rating Movie Year Add Movie

Scenario and Database Model: InstantRide InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email:   In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information:   In the CARS table, all the cars in the InstantRide system are kept with the license plate, model and year:   Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and…