A database is needed to keep data for the booking systems of the ABC Clinic. Consider the below database schema of one relation including attributes for doctors (doc-), patients (pat-) and appointments (app-).
ABC(doc-firstname, doc-surname, doc-gender, doc-rego, doc-qualification, pat-ID, pat-givename, pat-surname, pat-gender, pat-DOB, pat-addr, pat-phone, app-ID, app-datetime, app-type)
Consider the two relations below. They are in BCNF with primary key attributes underlined:
Customer(custID, firstname, lastname)
Item(itemNo, desc, price)
A Transaction relation as below is proposed to keep data for orders. Each order is by one customer and it can contain multiple items with their quantities.
Transaction(custID, itemNo, orderID, quantity, discount, amount_due)
Given the FDs below:
orderID → custID, amount_due, discount
orderID, itemNo → quantity
custID, orderID → amount_due, discount
In addition to the lecture notes, you should also study by yourself the SQL*Plus tutorial on Canvas (the Oracle section) and other resources for syntax and useful functions.
The relational schema for the Academics database is as follows:
DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode)
ACADEMIC(acnum, deptnum*, famname, givename, initials, title)
FIELD(fieldnum, id, title)
INTEREST(fieldnum*, acnum*, descrip)
Some notes on the Academics database:
Primary keys are underlined and foreign keys are marked with *. You should download the SQL script for defining and populating the database academics.sql from Canvas (the Oracle section) and run academics.sql in your Oracle account to build the database.
select distinct AC1.givename, AC1.famname, AC2.givename, AC2.famname
from academic AC1, author AU1, academic AC2, author AU2
and not exists
from Interest I1, Interest I2
where I1.acnum =AC1.acnum
The A-Star consulting firm has decided to build a database. The company has hired you to design the database. Requirements are as follows.
The database is aimed to:
According to the requirements and design aim, give an Entity Relationship (ER) diagram for the database, making assumptions where necessary. You must represent entities, relationships and their attributes, and all applicable constraints in your ER diagram. Explain any constraints that can not be expressed in the ER diagram.
Consider the Musician database ER diagram as shown in Figure 1.
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2020). Database Concepts. Retrieved from https://myassignmenthelp.com/free-samples/isys1055-database-concepts.
"Database Concepts." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/isys1055-database-concepts.
My Assignment Help (2020) Database Concepts [Online]. Available from: https://myassignmenthelp.com/free-samples/isys1055-database-concepts
[Accessed 23 October 2021].
My Assignment Help. 'Database Concepts' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/isys1055-database-concepts> accessed 23 October 2021.
My Assignment Help. Database Concepts [Internet]. My Assignment Help. 2020 [cited 23 October 2021]. Available from: https://myassignmenthelp.com/free-samples/isys1055-database-concepts.
Often times, students face problems with how to start a paper. Sometimes, they have no prior knowledge of paper writing conventions or how to place the arguments or cite facts and information. Despite being taught by teacher, many falter and in turn mess with their grades. Hire our experts to know how to write a research papers, create a research paper template paper outline and even draft the entire paper from a scratch. Certain things are not be experimented when grades are at stake and a research paper is offcourse not a thing to be tried like a novice. Get seasoned help from those who have helped students ace grades in research papers for past 10+ years.
(Cinergix Pty Ltd. 2011)
TechTarget (2016), entity relationship diagram, Retrieved from http://searchcrm.techtarget.com/definition/entity-relationship-diagram.
Cinergix Pty Ltd. (2011), Ultimate Guide to ER Diagrams, Retrieved from http://creately.com/blog/diagrams/er-diagrams-tutorial/
Answer: CCAvg Education Mortgage Personal Loan Securities Account CD Account Online CreditCard 1.6 1 0 0 1 0 0 0 1.5 1 0 0 1 0 0 0 1 1 0 0 0 0 0 0 1 2 0 0 0 0 0 1 1.5 2 0 0 0 0 1 0 0.6 2 104 0 0 0 1 0 8.9 3 0 1 0 0 0 0 2.4 3 0 0 0 0 0 0 2.5 2 0 0 0 0 1 0 1.5 3 0 0 0 0 1 1 0.9 2 111 0 0 0 1 0 2 ...Read More
Answers: 1: a). Single precision IEEE 754 format- 0 01111110 10100000000000000000000 The first MSB is the sign, the middle portion is the exponent and the last portion is the mantissa. Decimal conversion- 8.125 * 10^-1 b) 5-bit word- 0 1010 Signed magnitude- +10 (Most significant bit-0 [positive] rest 4 bits are magnitude) One’s complement- 10101 (all the 0’s are replaced by 1 and vice-versa) Two’s complement- ...Read More
Answer: Data Warehouse Bus Matrix: Business processes Dimensions Date Payment method Customer Employee Flights Membership Points Diagnosis Tool Products Agents Commission Flight management X X X X X X Awarding programs and services X &nb...Read More
Answer: Trivial Functional Dependencies: Table Name Attributes Dependencies Author Email Name, Address, Telephone1, Telephone2, Telephone3 Publisher Name Address, URL, ABN WrittenBy Email, ISBN Title Book ISBN Title, Edition, Year, ListPrice, PublisherName StokedAt ISBN, Code StockQty ShoppingCart CartID Timest...Read More
Are you confident that you will achieve the grade?
Our best Expert will help you improve your grade