Database question (Please help if you can) 1. List 5 different attributes that are or can...
Database question (Please help if you can)
1. List 5 different attributes that are or can be used as primary keys in a database. (Look at everyday scenarios)
Homework Answers
Primary Keys :
1 ) Student ID ( In school or college )
2 ) SSN ( social security number )
3 ) Employee ID ( In IT or government jobs )
4 ) Project ID ( In projects )
5 ) Account No ( In banks )
6 ) IMEI Number ( Identifiaction of an mobile )
Add Answer to:
Database question (Please help if you can)
1. List 5 different attributes that are or can...
Database Questions (Please help if you can) For the same query task, different DBMSs may use...
Database Questions (Please help if you can) For the same query task, different DBMSs may use different SQL statements. true (b) false Given a table, any column of this table can be used as a key of the table. true (b) false It is allowed to have multiple keys in a table. true (b) false When we create a table in a DBMS, if we do not explicitly specify the database, the table can never be created the DBMS does...
Database Schemas: Please draw the schemas like the example and not just list the entities and attributes! Thanks in adva...
Database Schemas:
Please draw the schemas like the example and not just list the
entities and attributes! Thanks in advance!
Convert the E-R diagrams to relational schema and show Primary Keys (using underline) Foreign Keys (using dotted underline) .Referential Integrity Your schema should look similar to the example below: CUSTOMER CustName ORDER OrderDate dob admitdate D,C gradstudent advisor major mimor class person phone D,C home homeid street buyer city ssn state ssn address zip nobedrms spousename profession spouseprofess minprice bdrms...
A small surgery center needs your help to create a database. The office manager has identified...
A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments. Please identify the attributes and primary keys needed for each of the entities. Identify the data types you would use for each of the attributes. Determine the relationships between the entities and find the one-to-many and many-to-many relationships. Use the ER matrix to determine the relationships. Create an ER diagram using Visio based...
QUESTION 1 What is the most common relationship within a relational database? Select the best answer...
QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an "entity'? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL...
c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I att...
c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I attribute as a primary key for an entity to make t unique if necessary. Library has a number of branches in the city, each branch having a name, address and librarian. Books have title, authors and publisher. A book can have multiple authors but a single publisher. Note that same...
Please see images for the database info. 1. Specify, in your own language, the project requiremen...
Please see images for the database info. 1. Specify, in your own language, the project requirement; identify the different types of users; and different views from different user groups. 2. For #2, at least two user groups and a user view for each user group. Also, the following steps are for each user groups/user views until step 8 3. Illustrate your data modeling by using ER model. 4. Use a document of your own, determine the attributes; use your own...
Database design Part One (Conceptual Database Design) As a database developer, you have been asked to...
Database design
Part One (Conceptual Database Design) As a database developer, you have been asked to design a new database the operation of the new project within the Liverpool John Moores University (LJMU). LJMU i planning to deliver a number of professional training courses in Al. Each course is delivered by one member of staff at LJMU's Training Centre; each staff is allocated a staff number. The policy of LJMU is to record the start working date of each staff,...
Please help me answer these: In the relational database model, an entity consists of one and...
Please help me answer these: In the relational database model, an entity consists of one and only one entity instance (or record). A. True B. False 2. In the relational database model, the foreign key name does NOT have to be the same as the primary key name. A. True B. False 3. Logical relationships between tables (or entities) in the relational database model are created with primary and candidate keys. A. True B. False 4. In the relational database...
Subject : Database Task #1: Make a database for judiciary system in which you have to...
Subject : Database Task #1: Make a database for judiciary system in which you have to define i)Entities ii)Attributes iii)Relationships iv)Keys implementations v)Which model you will follow for making this kind of db.
Create a series of ER Diagrams using MySQL Workbench. Each question below is a different version...
Create a series of ER Diagrams using MySQL Workbench. Each question below is a different version of the same database, with each version increasing in complexity. You need to submit an ER diagram for each version, in pdf or png format. The easiest would be to export your diagrams as png format and insert them into an MS Word document. For each ER diagram clearly indicate primary keys, foreign keys, and relationships, including cardinality (i.e. 1-to-many). Indicate in your diagram...
Database Schemas:
Please draw the schemas like the example and not just list the
entities and attributes! Thanks in advance!
Convert the E-R diagrams to relational schema and show Primary Keys (using underline) Foreign Keys (using dotted underline) .Referential Integrity Your schema should look similar to the example below: CUSTOMER CustName ORDER OrderDate dob admitdate D,C gradstudent advisor major mimor class person phone D,C home homeid street buyer city ssn state ssn address zip nobedrms spousename profession spouseprofess minprice bdrms...
QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an "entity'? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL...
c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I attribute as a primary key for an entity to make t unique if necessary. Library has a number of branches in the city, each branch having a name, address and librarian. Books have title, authors and publisher. A book can have multiple authors but a single publisher. Note that same...
Database design
Part One (Conceptual Database Design) As a database developer, you have been asked to design a new database the operation of the new project within the Liverpool John Moores University (LJMU). LJMU i planning to deliver a number of professional training courses in Al. Each course is delivered by one member of staff at LJMU's Training Centre; each staff is allocated a staff number. The policy of LJMU is to record the start working date of each staff,...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago