create a database called : login inside this database create table called:users defined as following: Filed name Data type constraint user id 5 digits primary key password Up to 15 charter Type "user"or "admin"

create a database called : login inside this database create table called:users defined as following: Filed name Data type constraint user id 5 digits primary key password Up to 15 charter Type "user"or "admin"

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

1st Edition

ISBN:9781305657458

Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Publisher:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Chapter11: Building Solutions: Database, System, And Application Development Tools

Section: Chapter Questions

Problem 5MC

See similar textbooks

Similar questions

Which of the following data dictionary objects should be used to view information about the constraints in a database? USER_TABLES USER_RULES USER_COLUMNS USER_CONSTRAINTS None of the above objects should be used.
Assign privileges to the new account that allow connecting to the database, creating new tables, and altering an existing table.
Create an application which can access a database. Create a database with an application user, user specific for your application to use, and 1 table of a couple of fields properly indexed. Grant permissions for the user to access the table. (submit .SQL file) Create a simple application, language of your choice, (BE languages only, no JS or Node) which can do the following operations: (submit source code file): Connect using the application user created above. Insert into the table, and select from the table using a WHERE clause, where all fields are parameterized. Display results of the select. Use a simple web server API interface for data input and output, which can be accessed via local browser or curl.
create a new database (named MyUniversity), the creation (using the CREATE command) shouldbe done once. The database is now created and saved locally on your computer. When you close the workbench and reopen it again, no need to re-run this CREATE command again (the compiler will give you an error, as the database you would like to create was already created) Task Description: consider the following relations for a university: Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer) Department (did: integer, dname: string(30 chars), capacity: integer) Course (cid: integer, cname: string(50 chars), credit: integer) Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real) studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the…
Create a Java application for Checkers called CheckersStockTakingApp. The application should consist of a client side, a server side and a database.4.1 Create a database called checkersproducts using MySQL or any relational database management software you are comfortable with. The database should have a table called products that consists of the following columns and properties:prodID AUTO NUMBER (primary)prodName VARCHAR (30)prodType VARCHAR (30)prodPrice DECIMAL (6,2)4.2 Create a server class that will do the following:• Run on port 8000 and listen to a client• Initially output a “server is starting” message to the screen• Make a connection to the database• Receive product details from the client• Add product details to products table• Send a message back to client to inform whether or not the product was added• Handle any exceptions• Close the server when the user types "stop" on the client side and output a message"Server stopping...." 4.3 Create a client class that will do the…
Create a new database (named MyUniversity) Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer) Department (did: integer, dname: string(30 chars), capacity: integer) Course (cid: integer, cname: string(50 chars), credit: integer) Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real) studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the primary key of the department relation. Using SQL create these relations under the MyUniversity database. Place the constraints (e.g., default values, check, primary keys) you find appropriate:
Create a new database (named MyUniversity) Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer) Department (did: integer, dname: string(30 chars), capacity: integer) Course (cid: integer, cname: string(50 chars), credit: integer) Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real) studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the primary key of the department relation. Using SQL, develop and execute the following queries: For each student with GPA between 2.5 (included) and 3.5 (included), display the student’s name, GPA,and his/her department ID. Sort the results by the students’ IDs in descending order. For each student who joined the Computer Science department between 2018 (included) and 2020(included), display…
Create a new database (named MyUniversity) Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer) Department (did: integer, dname: string(30 chars), capacity: integer) Course (cid: integer, cname: string(50 chars), credit: integer) Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real) studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the primary key of the department relation. Using SQL, insert (random but meaningful) data records in the above tables. Create at least four different courses that include Operating Systems (3 credit hours), Data Bases (4 credithours), and Marketing (5 credit hours) courses – consider one more course. Create three departments that include a Computer Science department and a Business department…
Create a MySQL Database called “CSC306Class”. Create three (3) tables in the database called “studentInf”, “IntructorInf”, and “LikedAndDisliked”. Each table should consist of five columns that are relatable to the table name. Insert at least five row of data in each table. The data can be any information as long as it is related to the table name.
Create a GUI APPLICATION in JAVA PROGRAMMING LANGUAGE based on the following conditions :• Adding new record• Deleting record• Read all the record from the database• Searching record by using StudentID• Searching record by using CourseID• Sort Data by TotalScore• Exit the application.Detailed Steps are as follows ::: There will entry (Unique ID) of all the employee of any Organization. According to the date of joining and date up to which salary is created, Number of days will be entered. Basic pay will be defined according to the post of employee and department. Then component like medical allowance will be added, and Charges of Hostel/ Bus, Security, welfare fund and other will be deducted. Number of leaves taken by the employee. INSTRUCT ME WITH FULL DETAILS ON HOW TO DO THE NEXT STEPS IN MY IDE, LIKE HOW TO COPY AND PASTE THE CODE, AND ADDITIONAL APPLICATIONS, DON'T SEND ME FAKE AND IRRELEVANT SOLUTIONS WHICH IS ALREADY IN THE CHEGG. I WILL DIRECTLY REPORT YOUR SOLUTIONS
· Make an Application called “ Student Management System ” that connect with database called university , the database contain 3 Tables o Student Table \ this Table contain all Data About Student in University { 1. Id --- int , primarykey 2. Name --- String 3. Gpa --- Double 4. College --- IT 5. Age --- int } o Course Table \ this Table contain all Data About Courses in University { 1. CourseId ---- String 2. CourseName ---- String 3. TeacherName ---- String 4. college ---- String 5. number Of Student ---- int } o Student-Course Table \ this table contain a foreign key for both table “ Student and Course ” and contain data about the student who takes some courses or a courses that have number of Student { studentID --- int , foreign key from Student Table courseID --- int , foreign key from Course Table }
· Make an Application called “ Student Management System ” that connect with database called university , the database contain 3 Tables o Student Table \ this Table contain all Data About Student in University { 1. Id --- int , primarykey 2. Name --- String 3. Gpa --- Double 4. College --- IT 5. Age --- int } o Course Table \ this Table contain all Data About Courses in University { 1. CourseId ---- String 2. CourseName ---- String 3. TeacherName ---- String 4. college ---- String 5. number Of Student ---- int } o Student-Course Table \ this table contain a foreign key for both table “ Student and Course ” and contain data about the student who takes some courses or a courses that have number of Student { studentID --- int , foreign key from Student Table courseID --- int , foreign key from Course Table } · The Program should connect to the database and do the following operation : o Add Student o Delete Student o…