Database schemas and dependencies, Database Management System

Assignment Help:

1. Staff(staffID, firstName, lastName, availabilityID, experience, phone, mobile, email);

2. Availability(availabilityID, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday, Sick Leave);

3. Services (serviceID, itemBaseID, timeBasedID, priceID)

4. ItemBased (itemBasedID,itemName,priceID);

5. TimeBased (timebasedID,timename, priceid,hourlyrate);

6. Clients(clientID, firstName, lastName, phone, mobile, email, bookingID, paymentID);

7. Registered Clients (rClientId, rClientName, rClientAge, rClientAddress, rClientGender, rClientCreditCardNum, rclientCash)

8. Non Registered (nClientId, nClientName, nClientAge, nClientGender, nClientCreditCard, nClientcash)


9. 7.Beauty Salon (salonID,venueID , staffID, bookingID);

10. Parlour (parlourID, parlourName, parlourAddress,);

11. Treatment Venue (venueID, staffID, shopID,parlourID)

12. Bookings (bookingID, serviceName, staffID, clientID, venueID, Time);

13. Payment(paymentType, paymentID,)


Related Discussions:- Database schemas and dependencies

Sql iis setup and admin - maybe tfs, I want a good Microsoft Admin experien...

I want a good Microsoft Admin experienced in IIS and SQL Server. They require being able to set it up and administer from then onwards. Experience in Team Foundation Server a

Describe drop table command or cascade of sql, Describe DROP TABLE command ...

Describe DROP TABLE command of SQL along with both the options - CASCADE and RESTRICT. DROP TABLE command - This command drops the specified table. Dropping a table also dro

Introduction to Database Design and Development, Every School has many teac...

Every School has many teachers and many students. Each student is assigned to one school and each teacher works for one school only. Each teacher teaches more than one subject but

Explain what is rdbms, Explain what is RDBMS ? RDBMS - RDBMS is a datab...

Explain what is RDBMS ? RDBMS - RDBMS is a database management system (DBMS) which stores data within the form of relations. Relational databases are powerful since they need f

By the relations get details of employees working in sql, Consider the rela...

Consider the relations: PROJECT(proj#,proj_name,chief_architect) EMPLOYEE(emp#,emp_name) ASSIGNED(proj#,emp#) Use relational algebra to express the subsequent queries: (i) Get

What are the drawbacks of file oriented system in details, What are the dr...

What are the drawbacks of File Oriented System in details?

Explain cnt in the respects of qbe, Explain CNT in the respects of QBE ? ...

Explain CNT in the respects of QBE ? CNT: It is one of the aggregation commands given in QBE. It is used to identify number of tuples

Hashing techniques, folding method and mid square method using visual basic...

folding method and mid square method using visual basic

Describe second normal and third normal form, Database Management Systems ...

Database Management Systems 1. Explain SQL Server 2000 Architecture with diagram. 2. Describe Second Normal and Third Normal Form. 3. Explain about query engine and stora

Increased overheads on update-data replication, Increased overheads on upda...

Increased overheads on update : On the drawbacks side, it will need the system to ensure that all replicas of a relation are consistent. This shows that all the replicas of the rel

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd